Google Sheets + Google Tasks Integrations
How to connect Google Sheets + Google Tasks
Zapier lets you send info between Google Sheets and Google Tasks automatically—no code required.
Triggered when you create a new spreadsheet.
Creates a new task.
Popular Google Sheets + Google Tasks workflows
Create new Google Sheet rows from new Google tasks
Create new Google Sheet rows from new Google tasksCreate a new Google task whenever you update a row in Google Sheets
Create a new Google task whenever you update a row in Google SheetsCreate Google Sheet rows for new completed Google Tasks
Create Google Sheet rows for new completed Google Tasks
New Spreadsheet Row (Team Drive)Triggered when a new row is added to the bottom of a spreadsheet - works best with Team Drives.Trigger- New Spreadsheet RowTriggered when a new row is added to the bottom of a spreadsheet.Trigger
- New SpreadsheetTriggered when you create a new spreadsheet.Trigger
- New or Updated Spreadsheet Row (Team Drive)Triggered when a new row is added or modified in a spreadsheet - works best with Team Drives.Trigger
- New or Updated Spreadsheet RowTriggered when a new row is added or modified in a spreadsheet.Trigger
- New WorksheetTriggered when you create a new worksheet in a spreadsheet.Trigger
- Create Spreadsheet ColumnCreate a new column in a specific spreadsheet.Action
- Create Spreadsheet RowCreate a new row in a specific spreadsheet.Action
- Google Sheets
Create one or more new rows in a specific spreadsheet (with line item support).
Scheduled
Action
- Google Sheets
Create a new worksheet by copying an existing worksheet.
Scheduled
Action
- Google Sheets
Create a blank spreadsheet or duplicate an existing spreadsheet. Optionally, provide headers.
Scheduled
Action
- Google Sheets
Create a blank worksheet with a title. Optionally, provide headers.
Scheduled
Action
- Google Sheets
Deletes the content of a row in a specific spreadsheet. Deleted rows will appear as blank rows in your spreadsheet. Please use with caution.
Scheduled
Action
- Google Sheets
Update a row in a specific spreadsheet.
Scheduled
Action
- Google Sheets
Finds many matched rows (10 max.) by a column and value.
Scheduled
Action
- Google Sheets
Returns many rows (20 max.) as a single JSON value and flat rows (line items).
Scheduled
Action
- Google Sheets
Finds a row by a column and value. Returns the entire row if one is found.
Scheduled
Action
- Google Sheets
Finds or creates a specific lookup row.
Scheduled
Action
- Google Tasks
Triggers when a task is completed in a specific task list.
Scheduled
Trigger
- Google Tasks
Triggers when a new task is added.
Scheduled
Trigger
- Google Tasks
Triggers when a new task list is created.
Scheduled
Trigger
- Google Tasks
Creates a new task list.
Scheduled
Action
- Google Tasks
Creates a new task.
Scheduled
Action
- Google Tasks
Update an existing task.
Scheduled
Action
- Google Tasks
Searches for an incomplete task.
Scheduled
Action
- Google Tasks
Find or Create Task.
Scheduled
Action
How Google Sheets + Google Tasks Integrations Work
- Step 1: Authenticate Google Sheets + Google Tasks.30 seconds
- Step 2: Pick one of the apps as a trigger, which will kick off your automation.15 seconds
- Step 3: Choose a resulting action from the other app.15 seconds
- Step 4: Select the data you want to send from one app to the other.2 minutes
- That’s it! More time to work on other things.
Google Sheets Tutorials
Google Tasks Tutorials
Get started for free
You can't add more hours to the day. Zapier is the next best thing.
Terms of Service