Google Sheets + Todoist
Create Google Sheet rows for new completed tasks in Todoist
When you have completed tasks, sometimes you'll want to keep track of them in a spreadsheet. Zapier helps you do this easily by creating rows in a Google Sheet when you have new completed tasks in Todoist. Now you'll have a running history of all your completed tasks.
When you have completed tasks, sometimes you'll want to keep track of them in a spreadsheet. Zapier helps you do this easily by creating rows in a Google Sheet when you have new completed tasks in Todoist. Now you'll have a running history of all your completed tasks.
- When this happens...
New Completed TaskTriggers when you complete a task (including recurring tasks) on a project.
TriggerPollingZapier 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 ZapPollingZapier 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.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 foundDrive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier 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.Drive
Spreadsheet Containing the Worksheet to CopyRequired
Worksheet to CopyRequired
Copy Worksheet Destination
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
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
Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
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
Search from last row
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
Search from last row
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
Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
Additional request headers
Body
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
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 ZapPollingZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
Use Timezone set up on the spreadsheet to format date values?
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.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
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
Bold
Italic
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
Search from last row
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
Overwrite existing worksheet with the same title
Headers
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
Related categories
About Todoist
Related categories
Related Zap Templates
- Save newly completed Todoist tasks as new rows in Google Sheets
- Add completed Todoist tasks to Google Sheets
- Turn Google Sheets rows into Todoist tasks
- Add tasks to Todoist from a Google Sheets spreadsheet after a delay
- Add new Google Sheets rows to Todoist as tasks
- Create Google Sheet rows for new incomplete tasks in Todoist
- Create Todoist tasks for new or updated Google Sheet rows
- Create multiple Google Sheets rows for new incomplete Todoist tasks
- 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
- 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
- Create tasks in Todoist for new spreadsheets in Google Sheets
- Create new Todoist projects from new Google Sheets spreadsheets
- Create new Todoist projects from new Google Sheets rows
- Create tasks in Todoist from new or updated rows in Google Sheets
- Create new Todoist tasks from new or updated Google Sheets rows
- Create new Todoist tasks from new Google Sheets rows in team drive
- Create new Todoist projects from new or updated rows in Google Sheets
Related Zap Templates
- Save newly completed Todoist tasks as new rows in Google Sheets
- Add tasks to Todoist from a Google Sheets spreadsheet after a delay
- Create Todoist tasks for new or updated Google Sheet rows
- 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 from new completed tasks in Todoist
- Create tasks in Todoist for new spreadsheets in Google Sheets
- Create tasks in Todoist from new or updated rows in Google Sheets
- Create new Todoist projects from new or updated rows in Google Sheets
- Add completed Todoist tasks to Google Sheets
- Add new Google Sheets rows to Todoist as tasks
- Create multiple Google Sheets rows for new incomplete Todoist tasks
- 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
- Manage new or updated Google Sheets rows by adding comments to tasks in Todoist
- Create new Todoist projects from new Google Sheets spreadsheets
- Create new Todoist tasks from new or updated Google Sheets rows
- Turn Google Sheets rows into Todoist tasks
- Create Google Sheet rows for new incomplete tasks in Todoist
- 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
- Create spreadsheets in Google Sheets for new projects in Todoist
- Manage new incomplete Todoist tasks by creating Google Sheets spreadsheets
- Create new Todoist projects from new Google Sheets rows
- Create new Todoist tasks from new Google Sheets rows in team drive