Google Sheets + Todoist
Save newly completed Todoist tasks as new rows in Google Sheets
Need to archive your completed tasks somewhere handy? Use this Todoist Google Sheets integration to automatically save completed Todoist tasks to a new row in a Google Spreadsheet.
Need to archive your completed tasks somewhere handy? Use this Todoist Google Sheets integration to automatically save completed Todoist tasks to a new row in a Google Spreadsheet.
- When this happens...
New Completed TaskOnly for Todoist Premium users! Triggers when you complete a task (including recurring tasks) on a project.
TriggerScheduledZapier checks for new data every 15 min on the Free plan - automatically do this!
Create Spreadsheet RowCreate a new row in a specific spreadsheet.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
New Project
Triggers when a new project is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planTaskRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TaskRequired
CommentRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TaskRequired
TitleRequired
Assigned To
Due Date (Human Formatted)
Due Date (Raw Formatted)
Priority
Labels
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Create Subtask
Creates a new task as a child of another task in Todoist.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Get Project Collaborators
Get all collaborators for a specific project
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
Project
ActionThis is an event a Zap performs.SearchFind existing data in your appNameRequired
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNameRequired
Project
TitleRequired
Note
Section
Assigned To
Due Date (Human Formatted)
Due Date (Raw Formatted)
Priority
Labels
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNo Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Trigger Column
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Spreadsheet Containing the Worksheet to CopyRequired
Worksheet to CopyRequired
Copy To
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Headers
Overwrite?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Text Bold
Text Italic
Text Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Bottom-Up
Row Count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
ColumnsRequired
Row CountRequired
First Row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Headers
Overwrite?
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
ProjectRequired
E-Mail AddressRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TaskRequired
SectionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ProjectRequired
CommentRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Project
TitleRequired
Note
Section
Assigned To
Due Date (Human Formatted)
Due Date (Raw Formatted)
Priority
Labels
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
HTTP MethodRequired
URLRequired
Query String Parameters
Headers
Additional Request Headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Get Task Comments
Get the comments of a Task as a line item
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appEmail AddressRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appNameRequired
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundDrive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNo Team Drive
SpreadsheetRequired
WorksheetRequired
Trigger Column
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
HTTP MethodRequired
URLRequired
Query String Parameters
Headers
Additional Request Headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Bottom-Up
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Bottom-Up
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
About Google Sheets
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Related categories
Similar apps
Zapier Tables
Databases, Spreadsheets, Zapier
Zoho Creator
App Builder, Zoho
Smartsheet
SpreadsheetsAbout Todoist
Managing millions of tasks, Todoist is an online task management app and todo list. It has Web, iPhone, Android, Chrome, Firefox, Outlook flavors (and more!).
Related categories
Similar apps
Trello
Project Management
Asana
Project Management
Google Tasks
Google, Task ManagementRelated Zap Templates
- Add completed Todoist tasks to Google Sheets
- Turn Google Sheets rows into Todoist tasks
- Add new Google Sheets rows to Todoist as tasks
- Create Google Sheet rows for new completed tasks in Todoist
- Create Google Sheet rows for new incomplete tasks in Todoist
- Create multiple Google Sheets rows for new incomplete Todoist tasks
- Add tasks to Todoist from a Google Sheets spreadsheet after a delay
- Create Todoist tasks for new or updated Google Sheet rows
- Create Todoist tasks from new or updated Google Sheets rows on team drive
- Add new completed Todoist tasks to Google Sheets as multiple rows
- Update Google Sheets rows with new completed tasks from Todoist
- Update Google Sheets rows for new incomplete Todoist tasks
- Mark tasks as completed in Todoist when new or updated rows appear in Google Sheets
- Update Google Sheets rows with new completed Todoist tasks
- Update Google Sheets rows for new incomplete Todoist tasks
- Add new Todoist projects to Google Sheets as updated rows in a spreadsheet
- Add new incomplete Todoist tasks to Google Sheets rows
- Add new Google Sheets rows to update Todoist tasks
- Create multiple rows in Google Sheets for new Todoist projects
- Update Google Sheets rows with new incomplete Todoist tasks
- Create rows in Google Sheets for new Todoist projects
- Mark tasks as completed in Todoist when new rows are added to Google Sheets
- Create spreadsheet rows in Google Sheets for new Todoist projects
- Create Todoist tasks from new or updated Google Sheets rows
- Update Google Sheets rows with new completed Todoist tasks
- Update Todoist tasks with new or updated Google Sheets rows
- Receive AI-generated summaries of all your completed tasks from Todoist in Slack
- Create spreadsheets in Google Sheets for new projects in Todoist
- Create spreadsheets in Google Sheets from new completed tasks in Todoist
- Manage new or updated Google Sheets rows by adding comments to tasks in Todoist
- Manage new incomplete Todoist tasks by creating Google Sheets spreadsheets
Related Zap Templates
- Add completed Todoist tasks to Google Sheets
- Create Google Sheet rows for new completed tasks in Todoist
- Add tasks to Todoist from a Google Sheets spreadsheet after a delay
- Add new completed Todoist tasks to Google Sheets as multiple rows
- Mark tasks as completed in Todoist when new or updated rows appear in Google Sheets
- Add new Todoist projects to Google Sheets as updated rows in a spreadsheet
- Create multiple rows in Google Sheets for new Todoist projects
- Mark tasks as completed in Todoist when new rows are added to Google Sheets
- Update Google Sheets rows with new completed Todoist tasks
- Create spreadsheets in Google Sheets for new projects in Todoist
- Manage new incomplete Todoist tasks by creating Google Sheets spreadsheets
- Turn Google Sheets rows into Todoist tasks
- Create Google Sheet rows for new incomplete tasks in Todoist
- Create Todoist tasks for new or updated Google Sheet rows
- Update Google Sheets rows with new completed tasks from Todoist
- Update Google Sheets rows with new completed Todoist tasks
- Add new incomplete Todoist tasks to Google Sheets rows
- Update Google Sheets rows with new incomplete Todoist tasks
- Create spreadsheet rows in Google Sheets for new Todoist projects
- Update Todoist tasks with new or updated Google Sheets rows
- Create spreadsheets in Google Sheets from new completed tasks in Todoist
- Add new Google Sheets rows to Todoist as tasks
- Create multiple Google Sheets rows for new incomplete Todoist tasks
- Create Todoist tasks from new or updated Google Sheets rows on team drive
- Update Google Sheets rows for new incomplete Todoist tasks
- Update Google Sheets rows for new incomplete Todoist tasks
- Add new Google Sheets rows to update Todoist tasks
- Create rows in Google Sheets for new Todoist projects
- Create Todoist tasks from new or updated Google Sheets rows
- Receive AI-generated summaries of all your completed tasks from Todoist in Slack
- Manage new or updated Google Sheets rows by adding comments to tasks in Todoist