How To Import Data From Asana To Google Sheets

Reading Time: 5 minutes

Asana is a web-based project management and task-tracking tool. It allows teams to organize, track and manage their work in one place. It provides features such as task assignments, due dates, subtasks, and file attachments. It is widely used in project and work management.

Imagine being able to effortlessly import all of your data from Asana to Google Sheets, without any hassle. And on top of that, imagine being able to set a schedule for automatic updates, so your data is always up-to-date and accurate. This means you’ll have real-time visibility of your team’s progress and be able to make informed decisions quickly.

All of this is possible with Amigo, a powerful data integration tool with infinite possibilities. With Amigo, you can integrate Asana with Google Sheets. Sounds cool, Right? Amigo makes it easy to import all of your data from Asana to Google Sheets. You can also set a schedule to automatically update the imported data, ensuring your data is always up-to-date and accurate.

To import data from Asana to Google Sheets, we will follow the following steps:

Steps to import data from Asana to Google Sheets

Here’s the step-by-step guide to import data from Asana to Google Sheets.

Step 1: Log on to Amigo

Sign in to Amigo with a valid email address. Yes, that’s right – you can access Amigo without going through the signing-up process.

Sign in to Amigo

On the left side, click on the Imports option. That’s our first step to integrate Asana to Google Sheets.

Click on imports

Click on Create new imports.

Create new imports to import data from asana to Google Sheets

From the list of sources, select the Custom API option as we will integrate Asana API to Google Sheets.

Select custom API option

In order to proceed further, we require an endpoint URL along with the API access key. That brings us to another step which is to generate Asana API key.

Custom API workspace

Step 2: Generate the API key

Click on Create new token to generate your Personal Access Token also known as API key. Using the key the authenticity of the API requests can be verified.

Create new personal access tokens

Enter the token name and check the terms and conditions. Select Create token to create your personal access token.

Create the tokens

You have successfully generated your token. Make sure to note it down as you won’t be able to see it again.

Copy your tokens

Step 3: Get the endpoint URL

Go to the Asana API documentation and scroll down to the Rest API section

Scroll down to rest api

In this tutorial, we will import tasks in the project from Asana to Google Sheets. Click on the Tasks option and select Get tasks from a project option from the list of tasks options.

select the highlighted option

Copy the endpoint URL and note down the headers and their respective values.

Note down the endpoint URL and header and key values

Step 4: Import data from Asana to Google Sheets

Get back to Amigo just where we left. Enter the endpoint URL. Replace {project_gid} in the URL with the project ID of the Asana project you want to export to Google Sheets.

The project ID can be found in the URL of the project.

Example: In the given URL, the portion highlighted in red is the project_gid of the project.

https://app.asana.com/0/1203686644442885/list

Enter the endpoint URL and replace the project_gid

In the Authentication tab, select the Bearer option and enter the Access token.

Auhtenticate by entering the personal acess token

Enter the headers and their respective values as per the documentation.

Enter the header and values

You can also set the refresh schedule to automatically update the data. Don’t forget to push the Toggle ON.

Set a refresh schedule

Click Run to display the preview of the data.

Click run to preview data and organize it

Flatten and Expand the preview data in order to organise them. On the top right corner, click Import to Google Sheets to import the data.

Click import to Google Sheets

To import data from Asana to Google Sheets, you need to connect Amigo to Google Drive. Add a connection and click the Export button.

Select the connection or add new connection

The following image is the snippet of imported data from Asana to Google Sheets.

Snippet of imported data

Hurray!!! We have learned how to integrate Asana with Google Sheets and import data successfully. Similarly, you can also explore the other endpoints and import data as per your requirements. After exporting the data from Asana to Google Sheets, Amigo will automatically update the imported data on the daily basis or at a frequency of your choice.

You can also set an alert to let Amigo send the analytics report to you and your team via email and/or Slack. Open the spreadsheet and use Amigo Add-on to set alerts. Click here to learn more.

The Amigo extension can connect Google Sheets to multiple sources and allows to import data automatically. It’s a convenient and versatile tool for importing and exporting data to Google Sheets. It can save a lot of time and effort. To learn more about other various kinds of data that can be imported to Google Sheets, visit our blog.

Some related articles you may be interested in:

Import YouTube Data To Google Sheets
Import TikTok Data To Google Sheets
Import Morningstar Data To Google Sheets

X
Hire expert data analysts on-demand. Get 30 Days Free Trial