Back to Linear in Google Sheets
SheetXAI logo
Linear logo
Linear · Google Sheets Guide

Create a Linear Project and Bulk-Add Milestones From a Google Sheet

2026-05-15
5 min read

The Scenario

A startup CTO is kicking off a new product line. The project plan has been living in a Google Sheet for two weeks — eight milestones, each with a name and a target date, agreed on by the team in a planning session. The Linear workspace doesn't have the project yet. The engineers are expecting to start tracking work against it by end of week.

The bad version:

  • Open Linear, click "Projects," click "New Project," type the project name, set the team, save.
  • Now click "Milestones" inside the new project, click "Add Milestone," type the first milestone name, set the date from the date picker, save.
  • Repeat for milestone 2. Then 3. Then 4.
  • Eight milestones later, you've spent 25 minutes doing setup work that was already written down in the sheet. The dates are in — but you're not confident they match the sheet, because you were clicking fast and the date picker is fussy.

The project should have existed in Linear 20 minutes ago.

The Easy Way: One Prompt in SheetXAI

SheetXAI is an AI agent that lives inside your Google Sheet. It reads the project planning data you've already laid out and uses its built-in Linear integration to create the project and all its milestones in one shot.

Create a new Linear project called "Mobile App v2" for the Product team, then create a milestone for each row in this sheet using column A as the milestone name and column B as the target date

What You Get

  • A new Linear project created with the name and team you specified.
  • One milestone per row, with names and target dates pulled directly from your sheet columns.
  • Milestones appear in Linear in the same order as the rows.
  • A confirmation with the new project's URL and a count of milestones created.

What If the Data Is Not Quite Ready

The project name and team are in the sheet, not hardcoded

You want the prompt to read the project details from cells rather than having to type them in.

Create a new Linear project using the name in cell A1 for the team in cell B1, then create a milestone for each row in columns A and B below row 3

Some milestones don't have dates yet

A few rows in column B are blank — those milestones exist but don't have dates assigned.

Create a new Linear project called "Platform Revamp" for the Infrastructure team, then create a milestone for each row in this sheet using column A as the name and column B as the target date — skip the date if column B is blank

The sheet has both milestones and sub-tasks mixed together

Column C marks whether each row is a milestone or a task. You only want the milestones in Linear's milestone list.

Create a new Linear project called "Q3 Platform Work" for the Platform team, then create a milestone for every row where column C says "milestone" using column A as the name and column B as the date

Full project bootstrap from a planning sheet

Create the project, add all milestones, then write the milestone IDs back so the sheet stays linked to Linear.

Create a new Linear project using cell A1 as the name and cell B1 as the team name — then for each row starting at row 4, create a milestone using column A as the name and column B as the date, and write the returned milestone ID into column C

One prompt. The project and all its milestones exist in Linear before the next tab loads.

Try It

Get the 7-day free trial of SheetXAI and open any Google Sheet with a project plan — milestone names, dates, team assignments — then ask it to create the Linear project and load all the milestones at once. Once the project exists, the bulk-create-issues guide shows how to populate it with tickets from the same sheet.

Stop memorizing formulas.
Tell your spreadsheet what to do.

Join 4,000+ professionals saving hours every week with SheetXAI.

Learn more