Update a Google Sheets row when a task in a specific Asana project is completed

■Overview

Do you manually transfer the progress of tasks managed in Asana, a project management tool, to Google Sheets? This double entry is not only time-consuming but can also lead to human errors such as missed updates and data entry mistakes. This workflow integrates Asana with Google Sheets and automates everything from reporting task completion to updating Google Sheets, eliminating the challenges of these routine tasks.

■Recommended for

• Anyone who uses Asana and Google Sheets together and manually transfers task progress
• Managers who want to spend less time creating project progress reports and focus on core responsibilities
• Anyone looking to automate data synchronization between Asana and Google Sheets and improve operational accuracy

■Benefits of this template

• When a task is completed in Asana, the relevant information is automatically updated in Google Sheets, freeing up the time spent on manual data entry for other tasks
• Prevent human errors such as data entry mistakes and missed updates, and always manage progress based on accurate information

■Workflow steps

1. First, connect Asana and Google Sheets to Yoom
2. Next, select Asana as the trigger and set the action to “When a task in a specific project is completed”
3. Then, set the Asana “Search for tasks” action as an operation to retrieve detailed information about the completed task
4. Finally, set the Google Sheets “Update a record” action as an operation to update the corresponding row based on the retrieved information

※ “Trigger”: An action that starts the workflow. “Operation”: An action that processes information within the workflow after the trigger starts.

■Customization options

• For the Google Sheets “Update a record” operation, specify the spreadsheet and sheet you want to update
• You can freely customize the fields to update by setting dynamic information retrieved from Asana, such as the task name and completion date, as variables, or entering fixed values such as “Completed”

■Notes

• Connect both Asana and Google Sheets to Yoom.
• You can choose a trigger interval of 5, 10, 15, 30, or 60 minutes.
• Note that the shortest trigger interval varies depending on your plan.