[UPDATED] Sync an Asana portfolio to Google Sheets
Barbara Elena Ramirez
|
17 steps
|
2 minutes
Google Workspace
Asana
Google Docs
Google Account
Google Contacts
Set up a Google Sheet
1
Navigate to <https://docs.google.com/spreadsheets/d/18hM-VghfW-tyukk7Z3Zo5Q-OpfNp4SJpV2ckmbZ_7Q4/copy>
2
Click "Make a copy".
3
Go back to Asana and copy the link provided in the portfolio.
4
Go back to the Google Sheet creared and click "Extensions".
5
Click "Asana Exports".
6
Click "Sync with Asana".
7
The first time it will ask you to grant access from your Google Account. Click "Ok".
8
Select your Google account.
9
Click "Allow".
10
Repeat steps to "Sync with Asana".
11
Paste the URL of the portfolio you copied earlier and click "Ok".
12
Give Asana a minute to populate the Google Sheet with the data from the portfolio.
Get the Asana Exports add-onn for Google Workspace
13
Click "Asana Exports".\ \ *This will take you to the [Asana Exports](https://workspace.google.com/marketplace/app/asana_exports/766596199153) add-on for Google Workspace.*
14
Click "Continue".
15
Read the terms and privacy policy, and Agree.
16
Click "Finish.
17
Click "Done".
