[UPDATED] Sync an Asana portfolio to Google Sheets | Scribe

    [UPDATED] Sync an Asana portfolio to Google Sheets

    • Google WorkspaceGoogle Workspace
    • AsanaAsana
    • Google DocsGoogle Docs
    • Google AccountGoogle Account
    • Google ContactsGoogle 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".
    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".