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

Move Todoist Tasks Between Projects Using a Sheet as the Routing Manifest

2026-05-13
4 min read
See the Excel version →

The Scenario

You are a department head. Your team just went through a restructure. Reporting lines changed, projects were consolidated, and sixty tasks are now in the wrong Todoist projects.

You built the routing manifest in a Google Sheet during the reorganization meeting — 60 task IDs in column A, target project names in column B. The fix should have happened two hours ago.

The bad version of the next two hours:

  • You open each task in Todoist, click the three-dot menu, choose Move to Project, select the target project
  • Sixty times
  • Around task thirty you accidentally move a task to the wrong project because you clicked too fast
  • You realize you have no way to easily undo it
  • You finish at 8 PM, exhausted, and not confident every task landed in the right project.

The fast version is one prompt.

The Easy Way: One Prompt in SheetXAI

SheetXAI is an AI agent inside your spreadsheet that reads the routing manifest and moves every task in one operation, without you opening the Todoist UI.

Open the SheetXAI sidebar and type:

Move each Todoist task listed in column A of my sheet to the project named in column B. Write 'Moved' or the error message into column C for each row.

SheetXAI reads the sixty rows and fires a move request for each task ID. Column C tells you the result for every row.

What You Get

Every task moved to its new project, with a status column as the audit log:

  • Column C status — 'Moved' for successful moves, error message if a task ID was not found or a project name did not match
  • Speed — all sixty tasks processed in one prompt
  • Integrity — tasks are moved, not deleted and recreated, so their history and comments stay intact

Tasks that fail to move are visible immediately in column C, so you know exactly what needs a manual follow-up before you close the laptop.

What If the Data Is Not Quite Ready

Restructure routing manifests are assembled fast and under pressure.

When some project names in column B do not exactly match Todoist project names

The manifest says "Eng Backend" but the Todoist project is "Engineering — Backend."

For each row in my sheet, move the task in column A to the project in column B. If the exact project name is not found, try partial matching (e.g., 'Eng Backend' should match 'Engineering — Backend'). Write 'Moved' or the error into column C, including what project name was actually matched.

When some tasks also need to move to a specific section within the new project

Column C in the sheet has a section name as well as a project.

For each row in my sheet, move the Todoist task in column A into the project named in column B and the section named in column C. If the section does not exist, create it. Write 'Moved' or the error into column D.

When you want to move tasks and also update their assignees at the same time

After the restructure, task ownership changed too. Column C has the new assignee email.

For each row in my sheet, move the Todoist task in column A to the project in column B, and reassign it to the person with the email in column C. Write 'Moved and reassigned' or the error into column D.

When you need to run the manifest for two departments and want a single summary

The IT and Ops teams each have their own routing sheet tabs.

Process the 'IT Routing' tab: move each task in column A to the project in column B, write status into column C. Then process the 'Ops Routing' tab the same way. After both are done, write a summary into cell A1 of the 'Summary' tab: total tasks moved, total errors for IT, total tasks moved, total errors for Ops.

The pattern: the routing manifest is in the sheet. SheetXAI reads it and moves every task without you touching the Todoist UI.

Try It

Get the 7-day free trial of SheetXAI and open any task routing manifest or reorganization sheet, then ask it to move the tasks. The Todoist integration is included in every SheetXAI plan. For related workflows, see how to bulk-update task priorities and due dates from a sheet or the Todoist in Google Sheets overview.

Stop memorizing formulas.
Tell your spreadsheet what to do.

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

Learn more