The Scenario
The VP of Engineering has a board meeting in two weeks and wants a single slide showing how work is distributed across all active Linear projects — specifically, the number of issues in Todo, In Progress, and Done for each one. Eight projects. Three states. The VP doesn't have time to click through every project's board view and copy numbers into a slide manually, and they're asking you to pull it together.
The bad version:
- Open the first Linear project, look at the board view, count the Todo column, write the number down. Count In Progress. Count Done. Write those down.
- Navigate back. Open the second project. Repeat.
- Eight projects. The board view doesn't show counts prominently — you're eyeballing columns or scrolling through filter views, which take time to load.
- By project 5 you realize the VP actually wanted "In Review" as a separate state, not grouped with In Progress. Back to project 1.
The slide should take 20 minutes to build. The data collection is eating the whole morning.
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, counts issues by state for each one, and writes the summary directly into the sheet.
List all Linear projects and for each one count the number of issues in each workflow state, then write the results into this sheet with one row per project
What You Get
- One row per active Linear project.
- Columns for project name and the issue count in each workflow state (Todo, In Progress, In Review, Done, Cancelled, etc.).
- Projects with zero issues in a state show 0, not a blank.
- A sheet that's immediately copy-pasteable into a slide or pivot table.
What If the Data Is Not Quite Ready
The VP wants only the four key states, not every workflow state
There are nine workflow states in the workspace. The board presentation only needs four of them.
Create a summary in this sheet with one row per Linear project showing the project name and the count of issues in Todo, In Progress, In Review, and Done states only
Some projects are archived and shouldn't appear
The workspace has 12 projects total but only 8 are active. You want to exclude archived ones.
List all active (non-archived) Linear projects and for each one write the project name, team, and issue counts in Todo, In Progress, and Done states into this sheet
The VP wants the total across all projects as well
They want per-project rows plus a grand total row at the bottom.
List all active Linear projects and write one row per project with the project name and issue counts for Todo, In Progress, In Review, and Done — then add a totals row at the bottom summing each state column
Full board-ready summary with percentage complete
Per-project counts plus a completion percentage column for the slide.
For each active Linear project: write the project name, count of issues in Todo, In Progress, and Done states — then add a column showing the percentage of issues that are Done out of the total non-cancelled issues, rounded to one decimal place
One prompt produces the data the slide needs, without anyone navigating eight project boards.
Try It
Get the 7-day free trial of SheetXAI and open a blank Google Sheet before your next leadership review — then ask it to pull issue counts across all your Linear projects into a summary table. Pair this with the sprint retro guide if you also need per-cycle velocity data for the same presentation.