Asana + Google Sheets
Track completed tasks in Asana by creating spreadsheet rows in Google Sheets
Whenever a task is completed in Asana, let this workflow update a row in your Google Sheets document instantly. No longer do you need to manually update your spreadsheet every time a task is finished, this automation does it for you. Enjoy a streamlined task management process and ensure your data in Google Sheets is always up-to-date with your project’s progress in real-time.
Whenever a task is completed in Asana, let this workflow update a row in your Google Sheets document instantly. No longer do you need to manually update your spreadsheet every time a task is finished, this automation does it for you. Enjoy a streamlined task management process and ensure your data in Google Sheets is always up-to-date with your project’s progress in real-time.
- 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!
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.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 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
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.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 appEmail Address or IDRequired
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 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 ZapScheduledZapier 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 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
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 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 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
About Google Sheets
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Related categories
Related Zap Templates
- Create new Asana tasks from new Google Calendar events
- Add new Typeform entries to Asana as tasks
- Add new Google Calendar appointments to an Asana task list
- Create Asana tasks from new Google Forms responses
- Create Asana tasks from new Calendly events
- Add new Google Tasks items to Asana
- Add new Asana tasks to Motion
- Create Asana tasks from updated Google Sheets rows
- Create Asana tasks from new emails in Gmail
- Create Google Calendar events from new Asana tasks
- Create Asana tasks from new saved Slack messages
- Create Asana tasks for labeled Gmail emails [Business Gmail Accounts Only]
- Create Asana tasks every week at a scheduled time
- Add new Asana tasks to Google Sheets rows
- Create Asana tasks from new Airtable records
- Create Asana tasks from new rows in Google Sheets
- Create Asana tasks for new or updated Google Calendar events
- Add new Asana projects to Clockify
- Add new tl;dv recordings to Asana as tasks
- Create new Asana tasks for new Dubsado leads
- Create Asana tasks from new Microsoft Outlook calendar events
- Add new Jotform submissions to Asana as tasks
- Add new Asana tasks to Airtable
- Create new Asana tasks when HoneyBook projects are moved to a new stage
- Create Asana tasks from new Gravity Forms submissions
- Generate Asana tasks from new appointments in Acuity Scheduling
- Create Asana tasks from new Acuity Scheduling appointments
- Create Asana tasks for new Trainerize clients
- Add new Formstack entries to Asana as tasks
- Create tasks on Asana for new incoming emails
- Create tasks in Asana when deals enters new stages in HubSpot
- Create Asana tasks from Gmail emails matching a search query [Business Gmail Accounts Only]
- Create Asana tasks from Mailchimp subscribers
- Add new starred Gmail emails as tasks in Asana [Business Gmail Accounts Only]
- Add new Asana tasks to Todoist
- Create new Asana tasks from added tl;dv transcripts
- Add new messages in Slack channels as Asana tasks
- Create Asana projects from new MOCO projects
- Add new GitHub issues to Asana as tasks
- Create Asana tasks for new Typeform entries
- Create Asana tasks for new or updated Google Calendar events
- Create tasks on Asana for new Cognito Forms entries
- Create Asana tasks with new items in Notion databases
- Create Asana projects from accepted Quotient quotes
- Add new Evernote notes to Asana
- Push Slack messages to Asana and create tasks on demand
- Send new Asana tasks in projects as Slack channel messages
- Create tasks in Asana for new Freshdesk tickets
- Add ClickUp tasks when tags are added to Asana tasks
- Create tasks in Asana from new contracts signed in Dubsado
- Create Asana tasks for new reactions added in Slack
- Add new Pipedrive activities to Asana as tasks
- Add new Asana tasks when Google Sheets rows are updated
- Add new tasks on Asana to Any.do
- Create Asana tasks from new BugHerd tasks
- Create Asana tasks for new Dubsado projects as leads
- Add new Asana tasks to Google Tasks
- Add new Salesforce tasks to Asana
- Update tasks in Motion when tasks are updated in Asana
- Get a digest of completed Asana tasks sent to your email on a daily, weekly, or monthly basis
- Send Gmail emails for new completed tasks in Asana
- Create Asana tasks from new Sembly AI tasks
- Save new Todoist incomplete tasks as new Asana tasks
- Convert new HubSpot deals into Asana tasks
- Send Discord channel messages for new tasks in project in Asana
- Transform new flagged emails in Microsoft Outlook into tasks in Asana
- Create Asana tasks for new Smartsheet rows
- Create Trello cards from new Asana tasks
- Create tasks in Asana for new leads from Facebook Lead Ads
- Send Slack channel messages for new comments on Asana tasks
- Add new Zendesk tickets to Asana as tasks
- Create Asana tasks from new saved messages in Slack
- Create Asana tasks with new or updated rows in Google Sheets
- Create new tasks in Asana when services are accepted in Ignition
- Create tasks in Asana with new or updated Airtable records
- Create Asana tasks from new Dropbox files
- Create Asana tasks for new incomplete tasks in Todoist
- Create Asana tasks for new form submissions in Squarespace
- Create tasks in Asana when your 123FormBuilder form is filled out
- Save URL as Task in Asana
- Create Asana projects from Harvest projects
- Create Asana tasks every month
- Create Asana tasks for new WooCommerce orders
- Add new Facebook Lead Ads leads to Asana as tasks
- Create Asana Tasks from Wufoo Form Entries
- Add new ClickUp tasks to Asana
- Create Asana tasks for new Loomly posts
- Create Asana tasks for new Google Calendar event starts
- Add new Zoho Forms submissions to Asana as tasks
- Create Asana tasks for new form submissions in Webflow
- Create Asana tasks from new or moved Trello cards
- Send new digests of completed Asana tasks to Slack
- Create new Motion tasks from new tasks in Asana
- Send Slack channel messages for completed tasks in Asana
- Create tasks in Asana for new action items in Fathom
- Create Asana tasks from a Formsite form
- Create Asana tasks for new RSS feed items
- Add new Basecamp 3 to-dos to Asana as new tasks
- Create tasks in Asana for every new action item in Fathom
- Send Slack direct messages for new tasks in project in Asana
Related Zap Templates
- Create new Asana tasks from new Google Calendar events
- Create Asana tasks from new Google Forms responses
- Add new Asana tasks to Motion
- Create Google Calendar events from new Asana tasks
- Create Asana tasks every week at a scheduled time
- Create Asana tasks from new rows in Google Sheets
- Add new tl;dv recordings to Asana as tasks
- Add new Jotform submissions to Asana as tasks
- Create Asana tasks from new Gravity Forms submissions
- Create Asana tasks for new Trainerize clients
- Create tasks in Asana when deals enters new stages in HubSpot
- Add new starred Gmail emails as tasks in Asana [Business Gmail Accounts Only]
- Add new messages in Slack channels as Asana tasks
- Create Asana tasks for new Typeform entries
- Create Asana tasks with new items in Notion databases
- Push Slack messages to Asana and create tasks on demand
- Add ClickUp tasks when tags are added to Asana tasks
- Add new Pipedrive activities to Asana as tasks
- Create Asana tasks from new BugHerd tasks
- Add new Salesforce tasks to Asana
- Send Gmail emails for new completed tasks in Asana
- Convert new HubSpot deals into Asana tasks
- Create Asana tasks for new Smartsheet rows
- Send Slack channel messages for new comments on Asana tasks
- Create Asana tasks with new or updated rows in Google Sheets
- Create Asana tasks from new Dropbox files
- Create tasks in Asana when your 123FormBuilder form is filled out
- Create Asana tasks every month
- Create Asana Tasks from Wufoo Form Entries
- Create Asana tasks for new Google Calendar event starts
- Create Asana tasks from new or moved Trello cards
- Send Slack channel messages for completed tasks in Asana
- Create Asana tasks for new RSS feed items
- Send Slack direct messages for new tasks in project in Asana
- Add new Typeform entries to Asana as tasks
- Create Asana tasks from new Calendly events
- Create Asana tasks from updated Google Sheets rows
- Create Asana tasks from new saved Slack messages
- Add new Asana tasks to Google Sheets rows
- Create Asana tasks for new or updated Google Calendar events
- Create new Asana tasks for new Dubsado leads
- Add new Asana tasks to Airtable
- Generate Asana tasks from new appointments in Acuity Scheduling
- Add new Formstack entries to Asana as tasks
- Create Asana tasks from Gmail emails matching a search query [Business Gmail Accounts Only]
- Add new Asana tasks to Todoist
- Create Asana projects from new MOCO projects
- Create Asana tasks for new or updated Google Calendar events
- Create Asana projects from accepted Quotient quotes
- Send new Asana tasks in projects as Slack channel messages
- Create tasks in Asana from new contracts signed in Dubsado
- Add new Asana tasks when Google Sheets rows are updated
- Create Asana tasks for new Dubsado projects as leads
- Update tasks in Motion when tasks are updated in Asana
- Create Asana tasks from new Sembly AI tasks
- Send Discord channel messages for new tasks in project in Asana
- Create Trello cards from new Asana tasks
- Add new Zendesk tickets to Asana as tasks
- Create new tasks in Asana when services are accepted in Ignition
- Create Asana tasks for new incomplete tasks in Todoist
- Save URL as Task in Asana
- Create Asana tasks for new WooCommerce orders
- Add new ClickUp tasks to Asana
- Add new Zoho Forms submissions to Asana as tasks
- Send new digests of completed Asana tasks to Slack
- Create tasks in Asana for new action items in Fathom
- Add new Basecamp 3 to-dos to Asana as new tasks
- Add new Google Calendar appointments to an Asana task list
- Add new Google Tasks items to Asana
- Create Asana tasks from new emails in Gmail
- Create Asana tasks for labeled Gmail emails [Business Gmail Accounts Only]
- Create Asana tasks from new Airtable records
- Add new Asana projects to Clockify
- Create Asana tasks from new Microsoft Outlook calendar events
- Create new Asana tasks when HoneyBook projects are moved to a new stage
- Create Asana tasks from new Acuity Scheduling appointments
- Create tasks on Asana for new incoming emails
- Create Asana tasks from Mailchimp subscribers
- Create new Asana tasks from added tl;dv transcripts
- Add new GitHub issues to Asana as tasks
- Create tasks on Asana for new Cognito Forms entries
- Add new Evernote notes to Asana
- Create tasks in Asana for new Freshdesk tickets
- Create Asana tasks for new reactions added in Slack
- Add new tasks on Asana to Any.do
- Add new Asana tasks to Google Tasks
- Get a digest of completed Asana tasks sent to your email on a daily, weekly, or monthly basis
- Save new Todoist incomplete tasks as new Asana tasks
- Transform new flagged emails in Microsoft Outlook into tasks in Asana
- Create tasks in Asana for new leads from Facebook Lead Ads
- Create Asana tasks from new saved messages in Slack
- Create tasks in Asana with new or updated Airtable records
- Create Asana tasks for new form submissions in Squarespace
- Create Asana projects from Harvest projects
- Add new Facebook Lead Ads leads to Asana as tasks
- Create Asana tasks for new Loomly posts
- Create Asana tasks for new form submissions in Webflow
- Create new Motion tasks from new tasks in Asana
- Create Asana tasks from a Formsite form
- Create tasks in Asana for every new action item in Fathom