Connect Google Sheets and Todoist

Plans are often drafted in a spreadsheet and done in Todoist. FlowMattic links them: rows become tasks or whole projects, finished tasks are logged back to the sheet, and the row is marked done when you tick the task off. It suits freelancers who bill from a sheet, managers handing out work from a plan, and anyone who reviews their week in Google Sheets.

Try FlowMattic free See example workflows

13 triggers 34 actions 6 example workflows 3 ready-made templates Unlimited runs

Try a pairing

When this happens in Google Sheets6 triggers

Do this in Todoist15 actions

1. TriggerNew Spreadsheet Row

2. ActionCreate a New Label

When Google Sheets fires New Spreadsheet Row, FlowMattic runs Create a New Label in Todoist with the data from that event.

You build this in the FlowMattic workflow builder on your own site. See the setup steps

Google Sheets and Todoist workflows you can build

Each one uses only triggers and actions the two integrations ship today, plus FlowMattic's own tools. Where the library has a ready-made template, import it instead of building from scratch.

Ready-made template

Log each completed Todoist task in a Google Sheet

Every task you finish adds a row with its name, project and completion time, which gives you a work diary for weekly reviews or client billing.

Task CompletedAdd New Row

View the template

Create a Todoist task from each new row and save its ID

A row in your plan becomes a task with the due date from the sheet, and Update Row writes the new task's ID back, which links the two for later workflows.

New Spreadsheet RowCreate TaskUpdate Row

Mark the row done when the Todoist task is completed

Lookup Row Data finds the row holding that task ID and Update Row sets the status and date, so the plan in the sheet shows progress without anyone updating it.

Task CompletedLookup Row DataUpdate Row

Set up a Todoist project for each new client in the sheet

A new client row creates a project named after the client, adds sections such as Onboarding and Delivery, and puts the first kickoff task in place.

New Spreadsheet RowCreate a ProjectCreate SectionCreate Task

Hand out this week's rota from a sheet every Monday

A Schedule reads the rota tab, Iterator walks through each line and Create Task adds that week's duties to Todoist, so recurring jobs follow the sheet rather than memory.

ScheduleGet Row DataIteratorCreate Task

Keep a register of Todoist projects in Google Sheets

New Project adds a row with the project name and date it was created, so you have one list of every project for planning, budgets and archiving later.

New ProjectAdd New Row

Set up: completed tasks in a sheet

By the end, each Todoist task you complete is written to your sheet as a new row.

Add the header row
Create a sheet with columns such as Task, Project, Labels and Completed.
Connect both apps
In FlowMattic Connects, add your Todoist account and a Google account that can edit the spreadsheet.
Trigger on Task Completed
Create a workflow with Todoist and Task Completed, then complete a test task so FlowMattic captures its fields.
Write the row
Add Google Sheets with Add New Row, map the task fields to the columns, test the step and switch the workflow on.

Import the ready-made template Beginner, about 5 min to set up

From Google Sheets	To Google Sheets
Task content	Task
Project ID	Project
Labels	Labels
Completed at	Completed

Triggers and actions in this pair

A trigger starts a workflow. An action is something FlowMattic does in the app as a step.

Good to know

Task Completed sends the project ID rather than its name. Add a Get a Project step if you want the project name in the sheet.
Linking a row to a task needs the task ID saved on the row, as in the second example. Without it, Lookup Row Data has nothing reliable to search for.
New Or Updated Spreadsheet Row fires on every edit, so using it to create tasks can make duplicates. New Spreadsheet Row creates one task per new row.

Google Sheets

Integration page

Triggers (6)

New Spreadsheet RowTrigger when a new row is added to the spreadsheet
New Or Updated Spreadsheet RowTrigger when a row is updated in the spreadsheet
Deleted Spreadsheet RowTrigger when a row is deleted from the spreadsheet
Update Cell DataTrigger when any cell is updated in the spreadsheet
Update Specific Cell DataTrigger when a specific cell is updated in the spreadsheet
Update Specific Column ValueTrigger when a specific column value is updated in the spreadsheet

Actions (19)

Add New RowAdd a new row with mapped data
Update RowUpdate existing row in specific spreadsheet with mapped data
Delete RowDelete row by ID in specific spreadsheet
Clear Row DataClear data or row by ID in specific spreadsheet
Lookup Row DataSearch for data in specific spreadsheet
Get Cell DataGet data for particular cell in specific spreadsheet
Update Cell DataUpdate data for particular cell in specific spreadsheet
Get Row CountGet total number of rows in specific spreadsheet
Get Row DataGet rows data from the sheet based on specified range
Create Spreadsheet ColumnCreate a new column in specific spreadsheet
Create New SheetCreate a new sheet in specific spreadsheet
Import CSV or JSON to Existing SheetImport CSV or JSON data to existing sheet in specific spreadsheet
Copy SheetCopy a sheet to another or within the same spreadsheet
Get RowsRetrieve rows in JSON format for use with Iterator
Export sheet to CSVExport the selected sheet to CSV format and save to WordPress Media Library
Export Sheet to ExcelExport the spreadsheet to Excel (.xlsx) format and save to WordPress Media Library
Export Sheet to PDFExport the spreadsheet to PDF format and save to WordPress Media Library
Export Sheet to OpenDocumentExport the spreadsheet to OpenDocument (.ods) format and save to WordPress Media Library
Export Sheet to TSVExport the selected sheet to TSV format and save to WordPress Media Library

Todoist

Integration page

Triggers (7)

New TaskTriggers when new task is created
Task UpdatedTriggers when task is updated
Task CompletedTriggers when task is completed
New ProjectTriggers when new project is created
Project UpdatedTriggers when project is updated
Added LabelTriggers when new label is added
Added FilterTriggers when new filter is added

Actions (15)

Create a New LabelCreates a new label
Create a ProjectCreates a new project
Create TaskCreates a new task
Create SectionCreates a new section
Add a Project CommentAdds a new comment to project (Only for todoist premium user)
Add a Task CommentAdds a new comment to task (Only for todoist premium user)
Delete ProjectDelete a existing project
Delete TaskDelete a existing task
Delete SectionDelete a existing section
Get a ProjectRetrieves a project details
Get Label by IDRetrieves a label by ID
Get SectionRetrieves a section details
Update ProjectUpdates an existing project
Update TaskUpdates an existing task
Update SectionUpdates an existing section

Why run this pair with FlowMattic

Google Sheets and Todoist connect through FlowMattic on your own site, with no separate automation account in the middle and no charge per run.

Your plans go through your server

Tasks and rows move between Todoist and Google through FlowMattic on your own WordPress site, not through another company's automation account.

Log everything, pay nothing more

Runs are unlimited, so logging every finished task and every new row costs the same however busy your week is.

Two-way without copying

Both apps have triggers and actions here, so the sheet can feed Todoist and Todoist can report back to the sheet.

Common questions

How do I set up a Google Sheets Todoist integration?

Connect both accounts in FlowMattic. To create tasks, start from New Spreadsheet Row and add Todoist's Create Task. To log finished work, start from Task Completed and add Google Sheets' Add New Row. Test each with real data before switching it on.

Can a due date in the sheet become the task's due date?

Yes. Map the date column into Create Task. If the sheet uses a different date format, run it through Date/Time Formatter first.

Can I import a whole list of tasks at once?

Yes. Start from Schedule, read the rows with Get Row Data, loop with Iterator and run Create Task for each row. Run it once, then switch to New Spreadsheet Row for new additions.

Can I track time spent per project?

Todoist does not send time spent here, but each completed task's timestamp goes in the sheet, and you can add your own estimate column to total by project.

Will deleting a row delete the task?

Not automatically. Delete Task is a Todoist action, but it needs the task ID, so it works only if you can pass that ID to the workflow.

Did not find your answer? You can browse the help center or ask us directly.

Start automating Google Sheets and Todoist

Install FlowMattic, connect both accounts and import a template. Every run stays on your own server.

Try FlowMattic free See pricing

30-day money-back guarantee Unlimited workflows and runs Self-hosted

Reviewed 23 Oct 2026. The example workflows are written with AI from the real triggers and actions of both integrations and checked against them. Google Sheets integration 2.2.4, Todoist integration 1.0.