The Scenario
It's Monday morning and the VP of Product has asked for a snapshot of all active engineering work by end of day — specifically, every issue across the Backend, Frontend, and Platform teams that isn't Done or Cancelled. The exec team wants it in a slide deck by 4 PM. Linear is where the data lives. The slide deck will not be built inside Linear.
The bad version:
- Navigate to the Backend team in Linear, set the filter to exclude Done and Cancelled, scroll through 60-something issues, and manually copy identifier, title, assignee, priority, and state into a sheet row by row.
- Switch to Frontend, repeat. Switch to Platform, repeat.
- Midway through the second team you realize you missed a column — you forgot to include the state. Now you have to go back and fill it in for everything you already copied.
Three teams, 140 issues, and you're the one doing the data entry. The deck is due in six hours.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads what you're looking at, connects to Linear through its built-in integration, and writes the query results directly into the sheet — no manual copying, no filter-and-scroll.
Pull all Linear issues for the team named Backend that are not in a Done or Cancelled state and write the identifier, title, assignee, priority, and state into this sheet
What You Get
- One row per issue, written directly into the sheet starting at row 1.
- Columns populated for identifier (e.g., BKD-42), title, assignee name, priority level, and current workflow state.
- Issues filtered to active states only — Done and Cancelled excluded.
- If you need multiple teams, a follow-up prompt appends below the first set.
What If the Data Is Not Quite Ready
You need all three teams in one pull
You don't want to run three separate prompts and stitch the results together.
Pull all Linear issues across the Backend, Frontend, and Platform teams that are not in Done or Cancelled state, and write the team name, identifier, title, assignee, priority, and state into this sheet
The issue list needs to be sorted before pasting into the deck
Leadership wants it sorted by priority descending, then by team.
Export all open Linear issues across the Backend, Frontend, and Platform teams into this sheet with columns for team, identifier, title, assignee, and priority — sort by priority (urgent first) and then alphabetically by team name
You only want issues assigned to a specific person
The engineering director needs their own team's work only.
Pull all Linear issues assigned to the user with email in cell A1 that are not in Done or Cancelled state and write the identifier, title, team, state, and due date into this sheet
Full filter plus enrichment in one shot
Pull the active issues, flag anything with no assignee, and add a column marking issues past their due date.
Export all open Linear issues for the Backend team into this sheet with identifier, title, assignee, state, and due date — leave the assignee column blank where there is no assignee and add a column F that says "overdue" if the due date is before today, otherwise leave it empty
One prompt. The conditional logic runs inside SheetXAI before anything lands in the sheet.
Try It
Get the 7-day free trial of SheetXAI and open a blank Google Sheet, then ask it to pull your current Linear issue list into it. Once the data is there, see the cross-project issue count summary guide for how to turn those rows into an executive-ready breakdown by state.