Asana + Google Sheets
Create spreadsheets in Google Sheets from completed Asana tasks
Ensure up-to-the-minute tracking with this automated workflow connecting Asana and Google Sheets. Each time a task is completed in Asana, the specifics are instantly logged into an existing Google Sheets spreadsheet. This reliable process eliminates the need for manually inputting data, always keeping you informed with the most recent task completion details.
Ensure up-to-the-minute tracking with this automated workflow connecting Asana and Google Sheets. Each time a task is completed in Asana, the specifics are instantly logged into an existing Google Sheets spreadsheet. This reliable process eliminates the need for manually inputting data, always keeping you informed with the most recent task completion details.
- 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.
TriggerPollingZapier checks for new data every 15 min on the Free plan - automatically do this!
Create SpreadsheetCreates a new spreadsheet. Choose from a blank spreadsheet, a copy of an existing one, or one with headers.
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 ZapPollingZapier 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.WorkspaceRequired
ProjectRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.WorkspaceRequired
ProjectRequired
Fields
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 ZapPollingZapier 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
Privacy Setting
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.Copy
WorkspaceRequired
Project
Task TemplateRequired
Task Name
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
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.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 appEmail Address or IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appGet Tasks from Project
Retrieves a list of tasks associated with a specific project.
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 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 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.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.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
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
ColumnsRequired
Row countRequired
First row
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
WorkspaceRequired
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.New Tag Created
Triggered when you create a new tag.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planWorkspaceRequired
ProjectRequired
SectionRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Workspace / OrganizationRequired
Try ItTriggerThis is the start of your ZapPollingZapier 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
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 appGet Tasks from Project
Fetches a list of tasks associated with a specific project.
ActionThis is an event a Zap performs.SearchFind existing data in your appGet Tasks from Project
Retrieves a list of tasks associated with a specific project.
ActionThis is an event a Zap performs.SearchFind existing data in your appWorkspaceRequired
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 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
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.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
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.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
Search from last row
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
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
Related categories
About Google Sheets
Related categories
Related Zap Templates
- Add new Asana tasks to Google Sheets rows
- Create Asana tasks from new rows in Google Sheets
- 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
- Create rows in Google Sheets from new completed tasks in Asana
- Add newly-completed Asana tasks to Google Sheets rows
- Add new tasks in Asana projects to Google Sheets row(s)
- Create multiple rows in Google Sheets for new Asana projects
- Update Google Sheets rows with updated Asana tasks
- Create Google Sheet rows for new updated tasks in Asana
- Track new orders logged to a Google Sheet as tasks in Asana
- Add new Google Sheets worksheets to Asana as tasks
- Create new Google Sheets rows to generate Asana tasks
- Create Asana tasks from new Google Sheets rows in a team drive
- Create Google Sheet rows for new completed tasks in Asana
- Create Google Sheet rows for new tagged tasks in Asana
- Create Google Sheet row(s) for new tasks in Asana projects
- 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
- title Create worksheets in Google Sheets for new Asana projects
- Create Asana tasks from new Zeplin screens
- 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
- Upload new Holded sales invoices to Google Drive as files
- 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
- Create new HoneyBook clients from updated Google Drive files
- 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
- Replace Google Drive files when new Slack channel messages are posted
- Create new Asana tasks from new or updated rows in Google Sheets team drive
- Create new Asana tasks from new Google Sheets rows
- Create multiple Google Sheets rows from new Asana subtasks
- Update Google Sheets rows whenever tasks in Asana projects are updated
- Create multiple spreadsheet rows in Google Sheets for new tasks in Asana projects
- Add rows to Google Sheets for completed tasks in Asana
- Create tasks in Asana for new conversations in Intercom
- 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
- Manage updated Asana tasks by creating corresponding rows in Google Sheets
- Update Google Sheets rows with updated tasks in Asana projects
- Send emails in Gmail when tasks in Asana projects get updated
- Create text files in Google Drive from new transcripts in Fathom
- Create Google Drive files from new Trello cards for seamless organization
- Update Google Sheets rows each time tasks are completed in Asana
- Create Asana projects from templates every time new rows are added in 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 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 tasks in Asana from new rows in Google Sheets
- Create Google Sheets rows for new Asana projects
- Update Asana actions with new or updated rows from 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 new Asana tasks in a project section from new Google Sheets rows
- Create multiple spreadsheet rows in Google Sheets for each completed task 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 Google Sheets rows for new Asana subtasks
- Create new Asana tasks from new Google Sheets rows on team drive
- Create new Asana tasks from updated rows in Google Sheets
- Create projects in Asana from new or updated rows in Google Sheets
- Update tasks in Asana when new or updated rows are detected in Google Sheets
- Create new Asana sections from new Google Sheets worksheets
- 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
- 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 Asana tasks from new or updated rows in your Google Sheets team drive
- Create tasks in Asana from new rows in Google Sheets
- Create tasks in Asana from new or updated rows in Google Sheets
- 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
- Update tasks in Asana when new rows are added to Google Sheets
- Add newly tagged tasks from Asana to Google Sheets as rows
- Create spreadsheets in Google Sheets for new tasks in Asana
- Create tasks in Asana from new rows in Google Sheets team drive
- Create multiple rows in Google Sheets when new comments on tasks occur in Asana
- Create tasks in Asana for new rows in Google Sheets
- Create Google Sheets spreadsheets when new tags are added in Asana
- Create new Google Sheets rows from updated Asana tasks for seamless project tracking
- Create tasks in Asana for new worksheets in Google Sheets
- Create Asana subtasks from new or updated Google Sheets rows on team drive
Related Zap Templates
- Add new Asana tasks to Google Sheets rows
- Add new Asana tasks when Google Sheets rows are updated
- Add newly-completed Asana tasks to Google Sheets rows
- Update Google Sheets rows with updated Asana tasks
- Add new Google Sheets worksheets to Asana as tasks
- Create Google Sheet rows for new completed tasks in Asana
- Create multiple Google Sheets rows from new Asana tasks in project.
- title Create worksheets in Google Sheets for new Asana projects
- 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 new Asana tasks from new Google Sheets rows
- 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
- Update Google Sheets rows with updated tasks in Asana projects
- Create Google Drive files from new Trello cards for seamless organization
- Trigger Asana api requests with new or updated rows in Google Sheets
- Create spreadsheets in Google Sheets for every new project in Asana
- Create tasks in Asana from new rows in Google Sheets
- Create Asana subtasks from new or updated Google Sheets rows
- Create new Asana tasks in a project section from new Google Sheets rows
- Create spreadsheet rows in Google Sheets for completed tasks in Asana
- Create new Asana tasks from updated rows in Google Sheets
- Create new Asana sections from new Google Sheets worksheets
- Create new Asana sections from new or updated Google Sheets rows
- Create new Asana projects from new Google Sheets worksheets
- Create worksheets in Google Sheets for new subtasks in Asana
- Create tasks in Asana from new rows in Google Sheets
- Create Asana tasks for new or updated rows in Google Sheets team drive
- Add newly tagged tasks from Asana to Google Sheets as rows
- Create multiple rows in Google Sheets when new comments on tasks occur in Asana
- Create new Google Sheets rows from updated Asana tasks for seamless project tracking
- Create Asana tasks from new rows in Google Sheets
- Create Asana tasks with new or updated rows in Google Sheets
- Add new tasks in Asana projects to Google Sheets row(s)
- Create Google Sheet rows for new updated tasks in Asana
- Create new Google Sheets rows to generate Asana tasks
- Create Google Sheet rows for new tagged tasks in Asana
- Create multiple Google Sheets rows for completed Asana tasks
- Create Asana tasks from new Zeplin screens
- 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
- Replace Google Drive files when new Slack channel messages are posted
- Create multiple Google Sheets rows from new Asana subtasks
- Add rows to Google Sheets for completed tasks in Asana
- Create spreadsheet rows in Google Sheets for each new tag created in Asana
- Send emails in Gmail when tasks in Asana projects get updated
- Update Google Sheets rows each time tasks are completed in Asana
- Create new Asana projects from new Google Sheets spreadsheets
- Create spreadsheet rows in Google Sheets for new tags created in Asana
- Create Google Sheets rows for new Asana projects
- Create Google Sheets rows for newly completed Asana tasks
- Create multiple spreadsheet rows in Google Sheets for each completed task in Asana
- Create Google Sheets rows for new Asana subtasks
- Create projects in Asana from new or updated rows 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
- Create spreadsheets in Google Sheets for new tasks in Asana projects
- Create tasks in Asana from new or updated rows in Google Sheets
- Create Google Sheets rows for new Asana tasks
- Create spreadsheets in Google Sheets for new tasks in Asana
- Create tasks in Asana for new rows in Google Sheets
- Create tasks in Asana for new worksheets in Google Sheets
- Create Asana tasks from updated Google Sheets rows
- Create rows in Google Sheets from new completed tasks in Asana
- Create multiple rows in Google Sheets for new Asana projects
- Track new orders logged to a Google Sheet as tasks in Asana
- Create Asana tasks from new Google Sheets rows in a team drive
- Create Google Sheet row(s) for new tasks in Asana projects
- Create rows in Google Sheets for new Asana subtasks
- Create worksheets in Google Sheets for new Asana project tasks
- Upload new Holded sales invoices to Google Drive as files
- Create new HoneyBook clients from updated Google Drive files
- Create tasks in Asana from new rows in Google Sheets team drive
- Create new Asana tasks from new or updated rows in Google Sheets team drive
- Update Google Sheets rows whenever tasks in Asana projects are updated
- Create tasks in Asana for new conversations in Intercom
- Manage updated Asana tasks by creating corresponding rows in Google Sheets
- Create text files in Google Drive from new transcripts in Fathom
- Create Asana projects from templates every time new rows are added in Google Sheets
- Create Asana projects from templates for every new or updated row in Google Sheets
- Add new or updated Google Sheets rows to Asana project sections as tasks
- Update Asana actions with new or updated rows from 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 new Asana tasks from new Google Sheets rows on team drive
- Update tasks in Asana when new or updated rows are detected in Google Sheets
- Create new Asana projects from updated Google Sheets rows
- Create Google Sheets spreadsheets from new Asana projects
- Duplicate worksheets in Google Sheets when tasks get completed in Asana
- Create Asana tasks from new or updated rows in your Google Sheets team drive
- Create spreadsheet rows in Google Sheets for new task tags in Asana
- Update tasks in Asana when new rows are added to Google Sheets
- Create tasks in Asana from new rows in Google Sheets team drive
- Create Google Sheets spreadsheets when new tags are added in Asana
- Create Asana subtasks from new or updated Google Sheets rows on team drive