How to Integrate Asana with Google Sheets

Quick summary

This tutorial shows you how to integrate Asana with Google Sheets using a Zapier Zap, so that Asana task events automatically sync data into a Google Sheets spreadsheet. The setup requires connecting both accounts via OAuth and configuring a trigger in Asana and an action in Google Sheets.

Steps

1. Log in to Zapier, click "Create," and then select "Zaps" to get started.
2. Click "Trigger" to proceed to the trigger setup.
3. Search for "Asana" to set it as the Trigger App.
4. Choose an event under Asana to define what will trigger the Zap.
5. Click "Allow" to grant Zapier permission to access your Asana account.
6. Choose the account you want to connect to.
7. Select "Allow" to confirm the account connection.
8. After signing in, click "Continue" to proceed.
9. Choose a value under "Workspace / Organization" then click "Continue" to proceed.
10. Click "Test trigger" to verify the Asana trigger is working correctly.
11. Choose a Project then click "Continue with selected record" to confirm the test data.
12. Search and select "Google Sheets" as the action app.
13. Choose an event under Google Sheets to define what action to perform.
14. Log in to your Google Sheets account and hit "Continue."
15. Complete and customize the required fields to map Asana data to Google Sheets.
16. Click "Test step" to verify the Google Sheets action works correctly.
17. After testing, click "Publish" to complete the integration and activate the Zap.