The Scenario
A product manager is preparing for the all-hands next week. The exec team wants a single timeline slide showing every upcoming milestone across all active Linear projects — project name, milestone name, and target date, sorted chronologically. Eight active projects, somewhere between 30 and 40 milestones total. The PM has never exported milestone data from Linear before and is discovering that the UI doesn't make it easy to see milestones across multiple projects at once.
The bad version:
- Open the first project in Linear, navigate to the Milestones section, note down each milestone name and target date.
- Open the second project, navigate to Milestones again, note them down.
- Eight projects. Some have five milestones, some have two. The dates are in different formats depending on how different team leads entered them. By the time you've gone through all eight, you're not sure if the sorting is right and you've already gone back to fix a wrong date twice.
The all-hands prep has consumed an hour and a half of the PM's Monday, and the slide isn't built yet.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It queries Linear for all active projects and their milestones, then writes the full list — project name, milestone name, and target date — into the sheet in sorted order.
List all Linear projects and for each project fetch its milestones, writing the project name, milestone name, and target date into columns A, B, and C
What You Get
- One row per milestone, across all active Linear projects.
- Columns for project name, milestone name, and target date.
- Projects with no milestones are skipped rather than generating blank rows.
- Dates written in a consistent format, ready to sort in the sheet.
What If the Data Is Not Quite Ready
The slide needs milestones sorted by target date, not by project
The all-hands slide goes chronologically, not project by project.
Pull all milestones for every active Linear project into this sheet sorted by target date ascending, with columns for project name, milestone name, and target date
You only want milestones with a target date set
Some milestones exist but have no date. They shouldn't appear in the timeline slide.
List all Linear projects and for each one fetch milestones that have a target date set — write project name, milestone name, and target date into this sheet sorted by date
You need to filter to milestones coming up in the next 90 days
The slide covers the near-term roadmap only, not the full backlog.
Pull all milestones across active Linear projects that have a target date within the next 90 days, write project name, milestone name, and target date into this sheet sorted by date ascending
Full roadmap view with overdue flags and team attribution
Pull all milestones, flag overdue ones, and include the team that owns each project.
List all milestones across all active Linear projects: write the project name, team name, milestone name, target date, and a column marking "overdue" if the target date is before today or "upcoming" if it is not — sort by target date ascending
One prompt produces the timeline table the all-hands slide needs.
Try It
Get the 7-day free trial of SheetXAI and open a blank Google Sheet before your next all-hands prep — then ask it to pull the full milestone roadmap across all your active Linear projects. Pair this with the cross-project issue count guide if the exec team also wants to see current workload alongside the timeline.