Try It

Create new Google Sheet rows from new Google tasks

  1. When this happensStep 1: New Task

  2. Then do thisStep 2: Create Spreadsheet Row

Want to same minutes (hours!) from having to copy/paste items between Google Sheets and Google Tasks? Let this Zapier automation create a new row in Google Sheets whenever you update a Google task. That'll give you a log of the tasks you need to do right alongside the rest of your spreadsheets in Google Drive.

How It Works

  1. A new Google task is created.
  2. Zapier adds that task in Google Sheets as a new row.

What You Need

  • Google account
Try It

Connect Google Sheets + Google Tasks in Minutes

It's easy to connect Google Sheets + Google Tasks and requires absolutely zero coding experience—the only limit is your own imagination.

All Triggers & Actions

New Spreadsheet Row (Team Drive)

Triggered when a new row is added to the bottom of a spreadsheet - works best with Team Drives.

New Spreadsheet

Triggered when you create a new spreadsheet.

InstantNew or Updated Spreadsheet Row

Triggered when a new row is added or modified in a spreadsheet.

Create Task List

Creates a new task list.

Update Task

Update an existing task.

InstantNew Spreadsheet Row

Triggered when a new row is added to the bottom of a spreadsheet.

New or Updated Spreadsheet Row (Team Drive)

Triggered when a new row is added or modified in a spreadsheet - works best with Team Drives.

New Worksheet

Triggered when you create a new worksheet in a spreadsheet.

Create Task

Creates a new task.

Find Task

Searches for an incomplete task.

Connect the apps you use every day

Get started with a Free account

Or
By signing up, you agree to Zapier’s Terms of Service