The Scenario
You are a QA engineer. Today is release day. Your team verified 35 bugs as fixed in this morning's build. The task IDs are in a Google Sheet — a column of Todoist task IDs pulled from the bug tracker earlier this week.
All 35 need to be marked complete in Todoist before the release notes go out.
The bad version of the next forty-five minutes:
- You open Todoist and search for the first task ID
- You click the task, mark it complete, search for the next one
- After ten tasks you realize the Todoist search is not showing task IDs — it only searches task names
- You switch to the Todoist URL trick, changing the ID in the URL bar, one at a time
- You finish twenty-two tasks before the release notes meeting starts, and the rest are still open.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that reads the column of task IDs and marks every one complete in Todoist in one operation.
Open the SheetXAI sidebar and type:
Mark as complete every Todoist task whose ID is listed in column A of my sheet. Write 'Completed' or the error message into column B for each row.
SheetXAI works through the column, fires a close request for each task ID, and writes the status back to column B. Before the meeting starts, column B tells you exactly which tasks closed cleanly and which ones returned errors.
What You Get
Every verified task marked complete, with a status column as the audit trail:
- Column B status — 'Completed' for each successful close, or the error message if a task was not found or already closed
- Speed — all 35 tasks in one prompt, not thirty-five separate searches and clicks
- Accuracy — no missed tasks, no accidental closes of the wrong task
The status column doubles as the release sign-off log. You can share the sheet with the release manager as confirmation that every verified bug was closed in the system.
What If the Data Is Not Quite Ready
Release-day task lists are assembled quickly and not always clean.
When some task IDs in the sheet are already closed
A few tasks were closed earlier in the day by another team member.
Mark as complete every Todoist task whose ID is in column A. If a task is already complete, write 'Already closed' in column B. If not found, write 'NOT FOUND'. If successfully closed now, write 'Completed'. Continue regardless of errors.
When you also need to add a comment to each closed task
The release process requires a comment on each closed bug with the build number.
For each task ID in column A, first add a comment: 'Verified fixed in build 4.2.1 — QA sign-off'. Then mark the task complete. Write 'Done' or the error into column B.
When the sheet has two columns — task IDs and verification notes
Some tasks have specific notes about what was verified. You want each note posted before closing.
For each row in my sheet, post the text in column B as a comment on the Todoist task in column A, then mark the task complete. If column B is empty, skip the comment and just close the task. Write 'Done' or the error into column C.
When you want a summary of what was closed written into a separate tab for the release notes
The release manager needs a plain-English summary of what was closed for the release announcement.
Mark as complete every Todoist task whose ID is in column A. Write status into column B. Then fetch the task names for all successfully closed tasks and write them into the 'Release Notes' tab as a bulleted list with one task name per row, preceded by 'Fixed: '.
The pattern: the task ID column is the only input. SheetXAI does the closures and writes the status back.
Try It
Get the 7-day free trial of SheetXAI and open any sheet with a column of Todoist task IDs, then ask it to close them all. The Todoist integration is included in every SheetXAI plan. For related workflows, see how to bulk-update task properties from a sheet or the Todoist in Google Sheets overview.