Import Asana Data to Google Sheets
In this guide, we’ll walk through how to pull tasks from the Asana API directly into Google Sheets, using the API Connector add-on for Sheets.
There are 2 ways to connect to the Asana API:
- Preset “Connect” button (OAuth) premium
- Personal access token. Please check the appendix for detailed instructions to retrieve your token.
- Before You Begin
- Part 1: Connect to the Asana API
- Part 2: Create your API Request URL
- Part 3: Pull Asana API Data into Sheets
- Part 4: More Example API URLs
- Part 5: Handle Pagination
- Appendix: Connect with an Asana Personal Access Token
Before You Begin
Click here to install the API Connector add-on from the Google Marketplace.
Part 1: Connect to the Asana API
- Open up Google Sheets and click Add-ons > API Connector > Manage Connections.
- In the list of available connections, find Asana and click Connect.
- You be asked to authorize the connection. Click Allow.
- You’ll then be returned to your Google Sheet, and can verify that your Asana connection is active in the Connections screen.
Part 2: Create Your API Request URL
We’ll first make a simple request to the /me endpoint.
- Base URL:https://app.asana.com/api/1.0
- Endpoint: /users/me
Putting it all together, we get the full API Request URL:
Part 3: Pull Asana API Data into Sheets
Now let’s grab that Asana data!
- Open up Google Sheets and click Add-ons > API Connector > Open.
- In the Create tab, enter the Request URL we just created
- On the OAuth menu, select Asana.
- We don’t need any headers so just leave that section empty.
- Create a new tab. Give it a name and click “Set current” to use that tab as your data destination.
- Name your request and click Run. A moment later you’ll see details about your account populate your sheet:
- Pay special attention to the field labeled
data.workspaces.gid. This is your workspace ID, which we can use to make further requests for tasks and project information.
Part 4: More Example API URLs
- Experiment with different endpoints and query strings as described in the documentation. For example, to retrieve all your tasks, enter the following in the API Request field:
PROJECT_IDwith your project ID (run a request to the
/projectsendpoint or click on your project and check the URL bar to see this value).
- To create a new task in Asana from Google Sheets, make a POST request with this URL
As noted earlier, find your
PROJECT_IDvalue from the URL bar in the interface, and get your
WORKSPACE_IDfrom your initial
https://app.asana.com/api/1.0/users/merequest. Input your task details into the POST body as described in the documentation, like this:
You will immediately see your new task reflected in your Asana dashboard. Note that you can only create one task at a time with this method.
Part 5: Handle Pagination
Asana recommends using pagination when retrieving large result sets, to break responses into smaller sets. If your response set is too large, you may receive an error like this: “The result is too large. You should use pagination (may require specifying a workspace)!” To resolve this issue, paginate your response by using the ‘limit’ and ‘offset’ parameters as described in the documentation.
In API Connector, you can either run these paginated request URLs manually or loop through automatically using pagination handling (paid feature), like this:
- API URL: enter your request URL, including limit=100
- Pagination type:
next page URL
- Field name:
- Number of pages: enter the number of pages you’d like to fetch
Appendix: Connect with an Asana Personal Access Token
This method is an alternative to the method described above. Instead of clicking Connect from the Manage Connections screen, retrieve your own personal token.
- Log in to Asana and click your profile icon in the top right corner to open the profile drop-down menu. Click ‘My Profile Settings’
- From the My Profile Settings menu, click Apps
- Click Manage Developer Apps
- On the Developer Apps screen, click “+New Access Token”
- A screen will open, prompting you to provide a name. You can name it whatever you like, but here we’ll name it Google Sheets. Check the terms and conditions box, and click Create Token.
- You’ll now see your Token. Congrats! Copy it to your clipboard.
- To use this token, under Headers, enter Authorization as your Key, and Bearer YOUR_TOKEN as your Value, like this:
- Your requests should run as described above. Just make sure to select OAuth = None as you’re connecting with a token instead.