The Scenario
The backlog review took two hours. You went through 180 tasks with the team and marked 25 as cancelled — scope changes, duplicate work, features that got cut. The task IDs ended up in your Google Sheet as you went: project ID in column A, task ID in column B. The backlog needs to be clean before the next planning session, which is tomorrow.
You consider deleting them one at a time. You open TickTick. You search for the first task ID.
The bad version:
- You search for each task by ID, open it, navigate to the delete option in the context menu, confirm the deletion, and return to the sheet to copy the next ID.
- By task eight you've realized TickTick's search sometimes returns similar tasks before the exact one, so you're double-checking IDs before deleting to make sure you're not removing the wrong task.
- At task 19 you close the wrong dialog and accidentally leave a task in the backlog that was supposed to be deleted, which gets picked up by a developer tomorrow morning.
Twenty-five tasks. Twenty-five search-and-delete cycles. An hour of work that should have been one sentence.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the project and task IDs from your cleanup list and permanently removes every task from TickTick in a single operation — writing confirmation back into column C so you have a clean record.
Delete each TickTick task using the project ID from column A and task ID from column B in the 'Cancelled Tasks' sheet, then write 'Deleted' into column C for each success.
What You Get
- All 25 tasks in the sheet are permanently deleted from TickTick.
- Column C receives 'Deleted' for each task that was successfully removed.
- If a task ID doesn't exist or has already been deleted, column C receives an error note for that row — the rest of the batch continues unaffected.
- No other tasks are touched — the operation is scoped exactly to the IDs in your sheet.
What If the Data Is Not Quite Ready
Some task IDs may no longer exist in TickTick
Tasks may have been deleted earlier by another team member, and you don't want errors on every duplicate attempt.
For each row in the 'Cancelled Tasks' sheet, attempt to delete the TickTick task using project ID from column A and task ID from column B. If the task no longer exists, write 'Already removed' in column C. If deleted successfully, write 'Deleted'. For other errors, write 'ERROR: [reason]'.
You want to soft-check before deleting anything
This is a large batch and you want to confirm the task names match what you expect before anything is permanently removed.
For each row in the 'Cancelled Tasks' sheet, look up the TickTick task using project ID from column A and task ID from column B, and write the current task title into column C. Do not delete anything yet — I'll review the titles and confirm.
The cleanup list spans two sheets
Cancelled tasks from two different sprints are in separate tabs.
Delete all TickTick tasks listed in the 'Sprint 14 Cancelled' sheet (project ID in A, task ID in B, write result in C), then do the same for the 'Sprint 15 Cancelled' sheet.
Full kill chain: validate, delete, and write a completion report in one shot
Check the 'Cancelled Tasks' sheet for rows missing a project ID in column A or a task ID in column B and write 'MISSING ID' in column C for those rows. For all valid rows, permanently delete the corresponding TickTick task and write 'Deleted [timestamp]' into column C. For any deletion failure, write 'ERROR: [reason]'. Count the total deleted and failed at the bottom of column C.
One pass, one result column, a summary at the bottom — the backlog is clean and you have the record to prove it.
Try It
Get the 7-day free trial of SheetXAI and open the cancelled-task list from your last backlog review, then ask it to delete all 25 tasks from TickTick in one shot. Also see: bulk-completing finished tasks from a QA checklist or bulk-updating due dates and priorities after a re-plan — or go back to the TickTick integration overview.