Asana + Google Sheets
Create multiple spreadsheet rows in Google Sheets for each completed task in Asana
Keep track of your accomplishments in real time with this Asana to Google Sheets workflow. Every time a task is completed in Asana, a new row will be instantly created in your chosen Google Sheets document. This way, you can effortlessly compile a comprehensive record of your completed projects without manually transferring the data. It's a simple solution to help you stay organized and aware of your productivity.
Keep track of your accomplishments in real time with this Asana to Google Sheets workflow. Every time a task is completed in Asana, a new row will be instantly created in your chosen Google Sheets document. This way, you can effortlessly compile a comprehensive record of your completed projects without manually transferring the data. It's a simple solution to help you stay organized and aware of your productivity.
- When this happens...
Completed TaskTriggered when a task within a project, or any project within a workspace, is marked as completed. Does not trigger on completed subtasks.
TriggerScheduledZapier checks for new data every 15 min on the Free plan - automatically do this!
Create Multiple Spreadsheet RowsCreate one or more new rows in a specific spreadsheet (with line item support).
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
WorkspaceRequired
ProjectRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.ProjectRequired
Task
Workspace
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planWorkspaceRequired
ProjectRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.WorkspaceRequired
ProjectRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Workspace / OrganizationRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planTask IDRequired
WorkspaceRequired
ProjectRequired
SectionRequired
Position in Section
Before/After Task ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Helptext
Workspace
Project
Tag
NameRequired
Task Fields
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Workspace / OrganizationRequired
ProjectRequired
Section NameRequired
Section to Insert After
Section to Insert Before
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.WorkspaceRequired
Name
Description
Is the description rich text?
Mark Task as complete?
Mark Task as liked?
Assignee
Followers
Tags
Custom Field Info
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.WorkspaceRequired
ProjectRequired
TaskRequired
TextRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
HTTP MethodRequired
URLRequired
Query String Parameters
Headers
Additional Request Headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.WorkspaceRequired
ProjectRequired
Section NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appTask IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appWorkspace
Email Address or IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appProjectRequired
Task NameRequired
WorkspaceRequired
Description
Is the description rich text?
Mark Task as complete?
Mark Task as liked?
Assignee
Followers
Tags
Custom Field Info
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundTask IDRequired
WorkspaceRequired
Name
Description
Is the description rich text?
Mark Task as complete?
Mark Task as liked?
Assignee
Followers
Tags
Custom Field Info
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 ZapScheduledZapier checks for new data every 15 min on the Free planDrive
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 To
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Headers
Overwrite?
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
Text Bold
Text Italic
Text 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
Bottom-Up
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
Headers
Overwrite?
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
WorkspaceRequired
ProjectRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New Tag Created
Triggered when you create a new tag.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planWorkspaceRequired
ProjectRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.WorkspaceRequired
ProjectRequired
Disclaimer
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Workspace/Organization
Triggered when you add a new workspace/organization.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planProjectRequired
TaskRequired
FileRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Workspace or Organization
Project TemplateRequired
Project NameRequired
Make Public?Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Parent Task IDRequired
WorkspaceRequired
Name
Description
Is the description rich text?
Mark Task as complete?
Mark Task as liked?
Assignee
Followers
Tags
Custom Field Info
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.WorkspaceRequired
Team
NameRequired
NotesRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Task IDRequired
Mark Task as complete?
Mark Task as liked?
Name
Assignee
Followers
Tags
Description
Is the description rich text?
Custom Field Info
WorkspaceRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Workspace
NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appWorkspaceRequired
ProjectRequired
Task NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appPremium User Help Text
WorkspaceRequired
Projects (Any)
Text
Is Subtask?
Is Completed?
Sort By
Sort Ascending?
Has Attachment?
Is Blocking?
Is Blocked?
Resource Subtype
Custom Fields Help Text
ActionThis is an event a Zap performs.SearchFind existing data in your appWorkspaceRequired
NameRequired
Team
NotesRequired
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundWorkspaceRequired
ProjectRequired
Task NameRequired
Description
Is the description rich text?
Mark Task as complete?
Mark Task as liked?
Assignee
Followers
Tags
Custom Field Info
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 ZapScheduledZapier 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.TitleRequired
Spreadsheet to Copy
Headers
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.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
HTTP MethodRequired
URLRequired
Query String Parameters
Headers
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
Bottom-Up
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
Bottom-Up
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 Asana
Asana is a leading work management platform that helps teams orchestrate their work, from daily tasks to strategic initiatives. With Asana, organizations have a living system of clarity where everyone can see, discuss, and execute their team’s priorities.
Related categories
Similar apps
Google Tasks
Google, Task Management
Todoist
Task Management
Toodledo
Task Management
About Google Sheets
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Related categories
Similar apps
Zapier Tables
Databases, Spreadsheets, Zapier
Zoho Creator
App Builder, Zoho
Smartsheet
SpreadsheetsRelated Zap Templates
- Add new Asana tasks to Google Sheets rows
- Create Asana tasks from updated Google Sheets rows
- Add new Asana tasks when Google Sheets rows are updated
- Create Asana tasks with new or updated rows in Google Sheets
- Add new tasks in Asana projects to Google Sheets row(s)
- Create new Google Sheets rows to generate Asana tasks
- Add newly-completed Asana tasks to Google Sheets rows
- Update Google Sheets rows whenever tasks in Asana projects are updated
- Create Asana tasks from new Google Sheets rows in a team drive
- Track new orders logged to a Google Sheet as tasks in Asana
- Create multiple rows in Google Sheets for new Asana projects
- Update Google Sheets rows each time tasks are completed in Asana
- Manage updated Asana tasks by creating corresponding rows in Google Sheets
- Create Asana tasks from new or updated Google Sheets rows (Team Drive)
- Create worksheets in Google Sheets for new Asana projects
- Add new Google Sheets worksheets to Asana as tasks
- Create Asana tasks from new Google Sheets rows
- Generate Asana tasks from new rows in Google Sheets (Team Drive)
- Create multiple Google Sheets rows from new Asana tasks in project.
- Create multiple Google Sheets rows for completed Asana tasks
- Create rows in Google Sheets for new Asana subtasks
- Create spreadsheet columns for new Asana projects in Google Sheets
- Create worksheets in Google Sheets for new Asana project tasks
- Create spreadsheets in Google Sheets for new Asana projects
- Create spreadsheet rows in Google Sheets for new Asana teams
- Update Google Sheets rows with new Asana project tasks for seamless organization
- Update Google Sheets rows when new tags are added to Asana tasks
- Add multiple Google Sheets rows when new Asana tags are added to tasks
- Add completed Asana tasks to a new Google Sheets row for easy tracking
- Create spreadsheet rows in Google Sheets each time tags are added to tasks in Asana
- Update Google Sheets rows when new Asana subtasks are created
- Create tasks in Asana from new rows in Google Sheets team drive
- Create tasks in Asana for new or updated rows in Google Sheets
- Create spreadsheet rows in Google Sheets for new tasks in Asana projects
- Create new Asana tasks from new Google Sheets rows
- Create multiple Google Sheets rows from new Asana subtasks
- Create multiple spreadsheet rows in Google Sheets for new tasks in Asana projects
- Add rows to Google Sheets for completed tasks in Asana
- Create Google Sheets rows for new Asana projects
- Create Asana tasks in project sections from new or updated Google Sheets rows
- Create spreadsheet rows in Google Sheets for each new tag created in Asana
- Update Google Sheets rows with updated tasks in Asana projects
- Create Asana subtasks from new or updated Google Sheets rows
- Create spreadsheets in Google Sheets from completed Asana tasks
- Create duplicate tasks in Asana for new spreadsheet rows in Google Sheets
- Create multiple spreadsheet rows in Google Sheets for every updated task in Asana projects
- Create Asana projects from templates every time new rows are added in Google Sheets
- Update tasks in Asana when new rows are added to Google Sheets
- Trigger Asana api requests with new or updated rows in Google Sheets
- Create new Asana projects from new Google Sheets spreadsheets
- Create Asana projects from templates for every new or updated row in Google Sheets
- Create Asana tasks from new Google Sheets rows
- Create tasks in Asana from new or updated rows in Google Sheets
- Create spreadsheets in Google Sheets for every new project in Asana
- Create spreadsheet rows in Google Sheets for new tags created in Asana
- Add new or updated Google Sheets rows to Asana project sections as tasks
- Create spreadsheet rows in Google Sheets for new tasks in Asana projects
- Create spreadsheet rows in Google Sheets whenever new tags are added to tasks in Asana
- Create tasks in Asana from new rows in Google Sheets
- Create Google Sheets rows for new Asana projects
- Create worksheets in Google Sheets for new tasks in Asana projects
- Update Asana actions with new or updated rows from Google Sheets team drive
- Create tasks in Asana from new or updated rows in Google Sheets team drive
- Create Asana subtasks from new or updated Google Sheets rows
- Create Google Sheets rows for newly completed Asana tasks
- Create duplicate worksheets in Google Sheets for every new project in Asana
- Create multiple rows in Google Sheets for new tasks in an Asana project
- Create new Asana tasks in a project section from new Google Sheets rows
- Create worksheets in Google Sheets for every new project in Asana
- Create Google Sheets rows from updated Asana tasks in projects
- Update Asana tasks with new or updated rows in Google Sheets team drive
- Create spreadsheet rows in Google Sheets for completed tasks in Asana
- Create new Asana tasks from new or updated Google Sheets rows
- Create Google Sheets rows for new Asana subtasks
- Create spreadsheet rows in Google Sheets for new tasks in Asana projects
- Create new Asana tasks from updated rows in Google Sheets
- Create multiple spreadsheet rows in Google Sheets for updated tasks in Asana projects
- Create projects in Asana from new or updated rows in Google Sheets
- Create Google Sheets rows for new tagged tasks in Asana
- Create Google Sheets rows from updated Asana tasks in projects
- Create new Asana tasks in project sections from new Google Sheets rows
- Update tasks in Asana when new or updated rows are detected in Google Sheets
- Create new Asana sections from new Google Sheets worksheets
- Update tasks in Asana when new spreadsheet rows are added in Google Sheets
- Create tasks in Asana from new or updated rows in Google Sheets on team drive
- Create new Asana projects from updated Google Sheets rows
- Create new Asana sections from new or updated Google Sheets rows
- Track completed tasks in Asana by creating spreadsheet rows in Google Sheets
- Create Google Sheets spreadsheets from new Asana projects
- Create new Asana projects from new Google Sheets worksheets
- Create new Asana projects from templates when new rows are added in Google Sheets
- Create spreadsheet rows in Google Sheets for new tasks in Asana projects
- Create new Google Sheets rows every time tags are added to tasks in Asana
- Duplicate worksheets in Google Sheets when tasks get completed in Asana
- Create worksheets in Google Sheets for new subtasks in Asana
- Create spreadsheets in Google Sheets for new tasks in Asana projects
- Create spreadsheet rows in Google Sheets for new task tags in Asana
- Create Asana tasks for new or updated rows in Google Sheets team drive
- Create Google Sheets rows for new Asana tasks
Related Zap Templates
- Add new Asana tasks to Google Sheets rows
- Create Asana tasks with new or updated rows in Google Sheets
- Add newly-completed Asana tasks to Google Sheets rows
- Track new orders logged to a Google Sheet as tasks in Asana
- Manage updated Asana tasks by creating corresponding rows in Google Sheets
- Add new Google Sheets worksheets to Asana as tasks
- Create multiple Google Sheets rows from new Asana tasks in project.
- Create spreadsheet columns for new Asana projects in Google Sheets
- Create spreadsheet rows in Google Sheets for new Asana teams
- Add multiple Google Sheets rows when new Asana tags are added to tasks
- Update Google Sheets rows when new Asana subtasks are created
- Create spreadsheet rows in Google Sheets for new tasks in Asana projects
- Create multiple spreadsheet rows in Google Sheets for new tasks in Asana projects
- Create Asana tasks in project sections from new or updated Google Sheets rows
- Create Asana subtasks from new or updated Google Sheets rows
- Create multiple spreadsheet rows in Google Sheets for every updated task in Asana projects
- Trigger Asana api requests with new or updated rows in Google Sheets
- Create Asana tasks from new Google Sheets rows
- Create spreadsheet rows in Google Sheets for new tags created in Asana
- Create spreadsheet rows in Google Sheets whenever new tags are added to tasks in Asana
- Create worksheets in Google Sheets for new tasks in Asana projects
- Create Asana subtasks from new or updated Google Sheets rows
- Create multiple rows in Google Sheets for new tasks in an Asana project
- Create Google Sheets rows from updated Asana tasks in projects
- Create new Asana tasks from new or updated Google Sheets rows
- Create new Asana tasks from updated rows in Google Sheets
- Create Google Sheets rows for new tagged tasks in Asana
- Update tasks in Asana when new or updated rows are detected in Google Sheets
- Create tasks in Asana from new or updated rows in Google Sheets on team drive
- Track completed tasks in Asana by creating spreadsheet rows in Google Sheets
- Create new Asana projects from templates when new rows are added in Google Sheets
- Duplicate worksheets in Google Sheets when tasks get completed in Asana
- Create spreadsheet rows in Google Sheets for new task tags in Asana
- Create Asana tasks from updated Google Sheets rows
- Add new tasks in Asana projects to Google Sheets row(s)
- Update Google Sheets rows whenever tasks in Asana projects are updated
- Create multiple rows in Google Sheets for new Asana projects
- Create Asana tasks from new or updated Google Sheets rows (Team Drive)
- Create Asana tasks from new Google Sheets rows
- Create multiple Google Sheets rows for completed Asana tasks
- Create worksheets in Google Sheets for new Asana project tasks
- Update Google Sheets rows with new Asana project tasks for seamless organization
- Add completed Asana tasks to a new Google Sheets row for easy tracking
- Create tasks in Asana from new rows in Google Sheets team drive
- Create new Asana tasks from new Google Sheets rows
- Add rows to Google Sheets for completed tasks in Asana
- Create spreadsheet rows in Google Sheets for each new tag created in Asana
- Create spreadsheets in Google Sheets from completed Asana tasks
- Create Asana projects from templates every time new rows are added in Google Sheets
- Create new Asana projects from new Google Sheets spreadsheets
- Create tasks in Asana from new or updated rows in Google Sheets
- Add new or updated Google Sheets rows to Asana project sections as tasks
- Create tasks in Asana from new rows in Google Sheets
- Update Asana actions with new or updated rows from Google Sheets team drive
- Create Google Sheets rows for newly completed Asana tasks
- Create new Asana tasks in a project section from new Google Sheets rows
- Update Asana tasks with new or updated rows in Google Sheets team drive
- Create Google Sheets rows for new Asana subtasks
- Create multiple spreadsheet rows in Google Sheets for updated tasks in Asana projects
- Create Google Sheets rows from updated Asana tasks in projects
- Create new Asana sections from new Google Sheets worksheets
- Create new Asana projects from updated Google Sheets rows
- Create Google Sheets spreadsheets from new Asana projects
- Create spreadsheet rows in Google Sheets for new tasks in Asana projects
- Create worksheets in Google Sheets for new subtasks in Asana
- Create Asana tasks for new or updated rows in Google Sheets team drive
- Add new Asana tasks when Google Sheets rows are updated
- Create new Google Sheets rows to generate Asana tasks
- Create Asana tasks from new Google Sheets rows in a team drive
- Update Google Sheets rows each time tasks are completed in Asana
- Create worksheets in Google Sheets for new Asana projects
- Generate Asana tasks from new rows in Google Sheets (Team Drive)
- Create rows in Google Sheets for new Asana subtasks
- Create spreadsheets in Google Sheets for new Asana projects
- Update Google Sheets rows when new tags are added to Asana tasks
- Create spreadsheet rows in Google Sheets each time tags are added to tasks in Asana
- Create tasks in Asana for new or updated rows in Google Sheets
- Create multiple Google Sheets rows from new Asana subtasks
- Create Google Sheets rows for new Asana projects
- Update Google Sheets rows with updated tasks in Asana projects
- Create duplicate tasks in Asana for new spreadsheet rows in Google Sheets
- Update tasks in Asana when new rows are added to Google Sheets
- Create Asana projects from templates for every new or updated row in Google Sheets
- Create spreadsheets in Google Sheets for every new project in Asana
- Create spreadsheet rows in Google Sheets for new tasks in Asana projects
- Create Google Sheets rows for new Asana projects
- Create tasks in Asana from new or updated rows in Google Sheets team drive
- Create duplicate worksheets in Google Sheets for every new project in Asana
- Create worksheets in Google Sheets for every new project in Asana
- Create spreadsheet rows in Google Sheets for completed tasks in Asana
- Create spreadsheet rows in Google Sheets for new tasks in Asana projects
- Create projects in Asana from new or updated rows in Google Sheets
- Create new Asana tasks in project sections from new Google Sheets rows
- Update tasks in Asana when new spreadsheet rows are added in Google Sheets
- Create new Asana sections from new or updated Google Sheets rows
- Create new Asana projects from new Google Sheets worksheets
- Create new Google Sheets rows every time tags are added to tasks in Asana
- Create spreadsheets in Google Sheets for new tasks in Asana projects
- Create Google Sheets rows for new Asana tasks