- How to automatically add a new row in Google Sheets for a completed task in Asana
- 1. Add the Asana "Task completed" trigger
- 2. Add the Google Sheets "Add row to sheet" automation
- 3. Turn on the playbook
- Learn more about integrating with Google Sheets and Asana
- Related blog posts
- More how-to guides featuring Google Sheets and Asana
How to automatically add a new row in Google Sheets for a completed task in Asana
Add the Asana "Task completed" trigger
Every playbook starts with a trigger. The trigger detects changes in your connected apps and runs your playbook in response.
Click "Add trigger" and select "Task completed" under Asana. Then, select the project. This trigger will automatically detect all the completed tasks in Asana to add new rows in Google Sheets.
If this is your first time using Asana integration in Relay.app, you'll be prompted to connect your Asana account.
Add the Google Sheets "Add row to sheet" automation
Integrate the Google Sheets automation into your playbook to ensure the prompt addition of a row to your Google Sheets with every task completed in Asana. Add a new step and select "Add row to sheet" from the list of Google Sheets automations.
Connect Google Sheets to Relay.app if you haven't already, then fill out the mandatory and relevant details. You can reference fields from Asana to automatically pass along the right data.
Turn on the playbook
Activating your playbook is the final step to automate adding a new row in Google Sheets for every completed task in Asana. Once turned on, it will respond to every completed task in Asana by adding a new row in Google Sheets without manual intervention.
To enable your playbook, click the toggle button located in the header. It is advisable to perform a test run of your playbook beforehand to ensure all steps work seamlessly together and reminders are sent correctly.