Asana + Google Sheets

Create Asana tasks with new rows in Google Sheets

When this happens
Step 1: New Spreadsheet Row
Then do this
Step 2: Create Task

A Google Sheets spreadsheet can be an easy way to collect data. However often times that data should be turned into todo lists and tasks. This integration makes that easy, automatically creating Asana tasks from new rows in a Google Sheets spreadsheet.

How It Works

Setup your Google Spreadsheet/Form
When new rows/submissions are create, Zapier will create new Asana tasks

What You Need

A Google Spreadsheet
An Asana account with projects

Try this template

Supported triggers and actions

What does this mean?

New Spreadsheet Row (Team Drive)
Triggered when a new row is added to the bottom of a spreadsheet - works best with Team Drives.
Trigger
Scheduled
New Spreadsheet Row
Triggered when a new row is added to the bottom of a spreadsheet.
Trigger
Instant
New Spreadsheet
Triggered when you create a new spreadsheet.
Trigger
Scheduled
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
Scheduled
New or Updated Spreadsheet Row
Triggered when a new row is added or modified in a spreadsheet.
Trigger
Instant

New Worksheet
Triggered when you create a new worksheet in a spreadsheet.
Trigger
Scheduled
Create Spreadsheet Column
Create a new column in a specific spreadsheet.
Action
Write

Create Spreadsheet Row
Create a new row in a specific spreadsheet.
Action
Write

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
Asana
Triggered when a task within a project, or any project within a workspace, is marked as completed. Does not trigger on completed subtasks.
Scheduled
Trigger
Asana
Triggered when you add a new project.
Scheduled
Trigger
Asana
Triggered when you add a new story.
Scheduled
Trigger
Asana
Triggered when you add a new subtask.
Scheduled
Trigger
Asana
Triggered when you create a new tag.
Scheduled
Trigger
Asana
Triggered when you add a new task to a project.
Instant
Trigger
Asana
Triggered when you add a tag to a task.
Scheduled
Trigger
Asana
Triggered when you add a new team.
Scheduled
Trigger
Asana
Triggered when a task in a project is updated.
Instant
Trigger
Asana
Triggered when you add a new user.
Scheduled
Trigger
Asana
Triggered when you add a new workspace/organization.
Scheduled
Trigger
Asana
Attaches a File to a task.
Scheduled
Action
Asana
Adds a subtask to an existing task.
Scheduled
Action
Asana
Adds a new project.
Scheduled
Action
Asana
Adds a new story (a comment is a story).
Scheduled
Action
Asana
Adds a new task.
Scheduled
Action
Asana
Adds a task to a section of a project.
Scheduled
Action
Asana
Updates an existing Task.
Scheduled
Action
Asana
Finds an existing project.
Scheduled
Action
Asana
Finds an existing section within a workspace project.
Scheduled
Action
Asana
Finds an existing task within a workspace project(s).
Scheduled
Action
Asana
Finds an existing task by its ID.
Scheduled
Action
Asana
Finds an existing user of your Asana account.
Scheduled
Action
Asana
Finds or creates a specific find project.
Scheduled
Action
Asana
Finds or creates a specific find task 2.
Scheduled
Action
Asana
Finds or creates a specific find task id.
Scheduled
Action