Google Sheets + Google Tasks
Track new completed Google Tasks in Google Sheets
Improve your productivity and keep your task records up-to-date with this workflow. As soon as you complete a task in Google Tasks, corresponding information is created within Google Sheets. This automatic process ensures a thorough summary of your completed tasks, enhancing your task management capabilities and increasing efficiency.
Improve your productivity and keep your task records up-to-date with this workflow. As soon as you complete a task in Google Tasks, corresponding information is created within Google Sheets. This automatic process ensures a thorough summary of your completed tasks, enhancing your task management capabilities and increasing efficiency.
- When this happens...
New Completed TaskTriggers when a task is completed in a specific task list.
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
Task ListRequired
Include Assigned Tasks?
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
New Task List
Triggers when a new task list is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planTask ListRequired
TitleRequired
Notes
Due On
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.Results will output in a line-item format. Subsequent action steps will need to support line-items. If not, you can transform this into t
Task ListRequired
Display Completed TasksRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
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
SpreadsheetRequired
WorksheetRequired
Frozen Rows Count
Frozen Columns Count
Sheet Position
Hide Sheet
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Source RangeRequired
Destination RangeRequired
Paste Type
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.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
Cell RangeRequired
Validation TypeRequired
Input Message
Strict Validation
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.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
ColumnsRequired
Row countRequired
Output format
First row
ActionThis is an event a Zap performs.SearchFind existing data in your appSpreadsheet IDRequired
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
Task ListRequired
Include Assigned Tasks?
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planList TitleRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ListRequired
TaskRequired
Title
Status
Notes
Due Date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ListRequired
TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appListRequired
TitleRequired
Task ListRequired
Notes
Due On
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.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Condition TypeRequired
Background Color
Text Color
Bold Text
Italic Text
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.Drive
SpreadsheetRequired
WorksheetRequired
Confirm DeletionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Format TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SpreadsheetRequired
WorksheetRequired
New Sheet NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Sort by ColumnRequired
Sort OrderRequired
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
A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Row IDRequired
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
Row count
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
Row count
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 Google Tasks
Related categories
Related Zap Templates
- Create Google Tasks from new Google Sheets rows
- Create new Google Sheet rows from new Google tasks
- Create Google Sheet rows for new completed Google Tasks
- Create spreadsheets in Google Sheets from new task lists in Google Tasks
- Create tasks in Google Tasks from new or updated Google Sheets spreadsheet rows on team drive
- Create a new Google task whenever you update a row in Google Sheets
- Create tasks in Google Tasks from new rows in Google Sheets (team drive)
- Create api requests in Google Tasks for new spreadsheet rows added in Google Sheets (team drive)
- Update Google Sheets rows for new Google Tasks task lists
- Create task lists in Google Tasks from new or updated rows in Google Sheets
- Create task lists in Google Tasks from new rows in Google Sheets
- Create multiple rows in Google Sheets for new completed tasks in Google Tasks
- Update Google Sheets rows for every new completed task in Google Tasks
- Create spreadsheets in Google Sheets for new tasks in Google Tasks
- Update Google Sheets rows with new tasks from Google Tasks
- Create multiple rows in Google Sheets for new tasks in Google Tasks
- Update tasks in Google Tasks when new rows are added in Google Sheets
- Create spreadsheet rows in Google Sheets for new task lists in Google Tasks
- Update spreadsheet rows in Google Sheets with new completed tasks from Google Tasks
- Update Google Tasks tasks when new or updated Google Sheets rows are detected
- Create new Google Sheets columns for every new task in Google Tasks
- Create task lists in Google Tasks from new or updated rows in Google Sheets team drive
- Create worksheets in Google Sheets from new task lists in Google Tasks
- Update Google Tasks with new or updated rows from Google Sheets
- "transfer completed Google Tasks to Google Sheets as new actions"
- Create task lists in Google Tasks for new spreadsheets in Google Sheets
- Record new completed Google Tasks in Google Sheets
- Log new completed Google Tasks as actions in Google Sheets
- Update Google Tasks when new or updated rows are detected in Google Sheets
- Create spreadsheet row at top in Google Sheets for each new completed task in Google Tasks
- Create multiple rows in Google Sheets for new task lists in Google Tasks
- Create new spreadsheet rows at top in Google Sheets for every new task in Google Tasks
Related Zap Templates
- Create Google Tasks from new Google Sheets rows
- Create spreadsheets in Google Sheets from new task lists in Google Tasks
- Create tasks in Google Tasks from new rows in Google Sheets (team drive)
- Create task lists in Google Tasks from new or updated rows in Google Sheets
- Update Google Sheets rows for every new completed task in Google Tasks
- Create multiple rows in Google Sheets for new tasks in Google Tasks
- Update spreadsheet rows in Google Sheets with new completed tasks from Google Tasks
- Create task lists in Google Tasks from new or updated rows in Google Sheets team drive
- "transfer completed Google Tasks to Google Sheets as new actions"
- Log new completed Google Tasks as actions in Google Sheets
- Create multiple rows in Google Sheets for new task lists in Google Tasks
- Create new Google Sheet rows from new Google tasks
- Create tasks in Google Tasks from new or updated Google Sheets spreadsheet rows on team drive
- Create api requests in Google Tasks for new spreadsheet rows added in Google Sheets (team drive)
- Create task lists in Google Tasks from new rows in Google Sheets
- Create spreadsheets in Google Sheets for new tasks in Google Tasks
- Update tasks in Google Tasks when new rows are added in Google Sheets
- Update Google Tasks tasks when new or updated Google Sheets rows are detected
- Create worksheets in Google Sheets from new task lists in Google Tasks
- Create task lists in Google Tasks for new spreadsheets in Google Sheets
- Update Google Tasks when new or updated rows are detected in Google Sheets
- Create new spreadsheet rows at top in Google Sheets for every new task in Google Tasks
- Create Google Sheet rows for new completed Google Tasks
- Create a new Google task whenever you update a row in Google Sheets
- Update Google Sheets rows for new Google Tasks task lists
- Create multiple rows in Google Sheets for new completed tasks in Google Tasks
- Update Google Sheets rows with new tasks from Google Tasks
- Create spreadsheet rows in Google Sheets for new task lists in Google Tasks
- Create new Google Sheets columns for every new task in Google Tasks
- Update Google Tasks with new or updated rows from Google Sheets
- Record new completed Google Tasks in Google Sheets
- Create spreadsheet row at top in Google Sheets for each new completed task in Google Tasks