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

Bulk Update Linear Issue States and Assignees From a Google Sheet

2026-05-15
5 min read

The Scenario

It's Thursday afternoon. The tech lead spent the morning doing offline sprint triage — going through 30 open issues in a spreadsheet, reassigning owners and adjusting priorities based on what the team can actually deliver this cycle. The sheet is done. The decisions are made. Now those changes need to land in Linear before the sprint starts Friday morning.

The bad version:

  • Open Linear, search for the first issue identifier in the sheet, open the ticket, click the assignee field, find the new owner in the dropdown, save.
  • Click the priority field, change it, save.
  • Go back to the sheet, find the next identifier, switch back to Linear, search again.
  • Thirty tickets. Each one requires a search, two field changes, and two saves. By ticket 18 you've accidentally assigned the wrong person because Linear's search autocomplete picked the first result instead of the one you wanted.

The sprint is starting in less than 24 hours. This is not what the tech lead's afternoon was supposed to look like.

The Easy Way: One Prompt in SheetXAI

SheetXAI is an AI agent that lives inside your Google Sheet. It reads the triage decisions in your sheet and pushes all of them to Linear at once through its built-in integration — no searching, no clicking through individual tickets.

Update each Linear issue in column A: set the assignee to the email in column B and priority to the value in column C

What You Get

  • All 30 issues updated in Linear — assignee and priority set from the sheet columns you specified.
  • Issues where the email in column B doesn't match a Linear workspace member surface as a warning row, not a silent failure.
  • A completion summary showing how many issues were updated and which rows had errors.

What If the Data Is Not Quite Ready

Some rows only need a state change, not a reassignment

The triage sheet has a mix: some rows change assignee and priority, others just flip the state.

For every row in this sheet where column D is not empty, update the corresponding Linear issue in column A to the state in column D — leave assignee and priority unchanged

The priority column uses numbers instead of words

The sheet was built before anyone agreed on a convention. Column C has 1, 2, 3, 4.

Update each Linear issue in column A: set the priority using column C where 1=urgent, 2=high, 3=medium, 4=low — and set the assignee to the email in column B

The team lead wants to unassign issues that were intentionally left blank

Blank assignee in the sheet means "remove current owner."

For each row in this sheet: update the Linear issue in column A — set the assignee to the email in column B (if column B is blank, remove the assignee) and set the priority to column C

Full triage apply with status writeback

Push all the changes and confirm completion in the sheet.

Update every Linear issue in column A: set assignee to column B, priority to column C, and state to column D if column D is not empty — then write "updated" into column E for each row that succeeded and the error message for any that failed

The pattern works across any combination of fields. You describe what to change; SheetXAI handles the API calls.

Try It

Get the 7-day free trial of SheetXAI and open any Google Sheet with a list of Linear issue identifiers and your triage decisions — then ask it to apply all the changes at once. Pair this with the sprint cycle assignment guide if you also need to move these issues into the active cycle.

Stop memorizing formulas.
Tell your spreadsheet what to do.

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

Learn more