The Scenario
Your sprint review just wrapped. You and your team spent an hour going through the board, and you marked 35 tasks as "Done" in column D of your tracking sheet — that's your source of truth, the spreadsheet everyone's been updating all sprint. Now those same tasks need to be marked complete in Google Tasks so the list doesn't look like an open graveyard when someone checks it next week.
The bad version:
- Open Google Tasks, search for the first task by name, click into it, mark it complete, go back, find the next one, repeat.
- Spend 40 minutes on a task that should take 40 seconds.
- Miss six tasks because the names in the sheet don't exactly match what ended up in Google Tasks after someone renamed them mid-sprint.
Your sprint review already ran long. Reconciling two task systems by hand is not the follow-up work anyone signed up for — it's the kind of maintenance that quietly eats the hours you were supposed to spend on the next sprint.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the data you have and uses its built-in Google Tasks integration to act on it — including marking tasks complete based on a status column you've already filled in. One prompt, all 35 tasks.
Open the SheetXAI sidebar and paste this prompt:
For every row in this sheet where column D says 'Done', find the matching Google Task by the ID in column E and mark it as completed
What You Get
- Every row where column D is "Done" processed against the Google Task ID in column E.
- The matching tasks marked complete in Google Tasks, no manual clicking required.
- Rows where column D is not "Done" left untouched.
- Any task ID that can't be found flagged in a status column so you know what to follow up on.
What If the Data Is Not Quite Ready
Task IDs are missing — you only have task names
If column E is empty and you're matching by title rather than ID, the lookup is fuzzier but still workable.
For every row in this sheet where column D says 'Done', find the Google Task in the 'Sprint 14' list whose title matches column A and mark it as completed — if no exact match is found, write 'not found' to column F
The status column has mixed values you need to normalize first
If column D has entries like "done", "DONE", "Done ✓", or "Completed" rather than a clean single value, match on intent rather than exact string.
For every row where column D contains any variation of 'done' or 'completed' (case-insensitive, ignore trailing punctuation or emoji), mark the Google Task with the ID in column E as complete — write the result to column F
Some tasks belong to different task lists and you need to target the right one
If your sheet tracks tasks across multiple lists and column F holds the list name, completion needs to be scoped to the right list.
For every row where column D says 'Done': look up the Google Task with ID in column E within the list named in column F, mark it complete, and write 'completed' or the error message to column G
Clean status column, complete tasks, and write a summary in one pass
For a sprint close-out where your PM wants a record, you want the action and the audit trail together.
Normalize column D values (treat 'Done', 'done', 'DONE', 'Completed' as equivalent), then for every matching row: mark the Google Task with ID in column E as completed, write 'completed' to column G, and after processing all rows add a row at the bottom that says 'Sprint close: X tasks marked complete, Y not found' with the actual counts
The sprint close-out is one operation, not three steps you run and reconcile afterward.
Try It
Get the 7-day free trial of SheetXAI and open the sprint tracking sheet you already have — mark the done rows in their status column, then ask SheetXAI to close them all out in Google Tasks in one go. See also bulk task creation for the start-of-sprint flow, or explore the full Google Tasks integration overview.