Back to Blog

No-Code Asana Google Sheets Integration For Scheduled Data Exports

Reporting in Asana allows you to use the predefined dashboard templates, such as Project by owner or Projects with the most completed task, and create custom charts. However, we all agree that the available reporting features are rather limited. So, many users tend to manage their reporting tasks outside of Asana. For this, they need to export data first. In this article, we’ll talk about the available exporting options to one of the most popular spreadsheet apps – Google Sheets. 

Asana to Google Sheets – how to export

There is no native Asana to Google Sheet integration…well, this is not actually true. You can pull data from Asana projects in your Portfolio to Google Sheets. So this works for all Business and Enterprise, but not Basic and Premium ones.

The simplest way to get data from Asana is to export it as a CSV file, which you can then import into Google Sheets. This is the manual method, which does not allow you to implement any automation. 

The third option is to connect your Google spreadsheet to Asana via its REST API. This will let you set up an ETL pipeline and automate data load on a schedule. The most important thing about this is that you won’t need to write a single line of code to do this! 

Let’s now explore all the options so you can choose the best one for your specific needs. 

Asana export to Google Sheets via CSV

We’ll start with the plainest option available to all Asana users. To export data from Asana as a CSV file, you need to click the Actions drop-down and select the respective option. 

1 export csv

The CSV file will be downloaded to your device. After that, you’ll need to import it to Google Sheets. Let’s see this step by step in the example below.

Export Asana board to Google Sheets 

  • In My Tasks, click the Actions drop-down.
2 actions drop down
  • Select Export CSV to download a CSV file with your Asana data.
3 export csv
  • Open the Google Sheets spreadsheet where you want to load the Asana records. Go to File => Import.
4 google sheets import
  •  Click Upload and select your CSV file or drag it to the field.
5 upload csv file
  • Configure the import by selecting the available options from drop-downs; then click Import data.
6 configure import

There you go!

7 asana board google sheets

Asana Google Sheets integration for portfolios

Asana Business and Enterprise subscribers can manage their portfolios and export them directly to Google Sheets. The flow is the same as with the CSV export, but here Google Sheets is available as the option.

8 portfolio google sheets

The export ends in a new spreadsheet with three sheets: Overview, Asana portfolio data and Live source data.

9 portfolio exported to google sheets

On the Overview tab, you’ll find the instructions on how to use this report. The data will be automatically updated every hour from the initial export. 

Although this looks good, this option is not available for all Asana users and it’s limited to one data entity – portfolios. For more advanced exporting capabilities, check out the next method that involves exporting Asana to Google Sheets via API.

Connect to Asana API in Google Sheets without coding

To connect Google Sheets to API, we’ll use Coupler.io. It is a no-code iPaaS tool to import data from multiple sources into three destinations. Yes, besides Google Sheets, you can load data to Excel or Google BigQuery.

Before the setup, however, we need to obtain a personal access token to authenticate our calls to the Asana API.

Get a personal access token in Asana

10 new access token
  • Enter a name for your token, read and agree to the API terms and conditions, and click Create token.
11 token name
  • Copy your access token to a spreadsheet or a text editor, because you won’t see it in Asana again.
12 copy your token

Now you’re ready to do integration in Google Sheets with the Asana API.

Integrate Asana in Google Sheets

Sign up to Coupler.io with your Google account, click Add new importer, name it whatever you want, and configure as follows:

Note: Coupler.io is also available as an add-on for Google Sheets. If this option is more comfortable for you, install the add-on from the Google Workspace Marketplace.

Set up source

  • Select JSON as the source application.
13 json source
  • Enter the Asana API URL that corresponds to the data entity you want to export. 

The basis Asana API URL is the following:

https://app.asana.com/api/1.0/{endpoint}

The {endpoint} will differ depending on your exporting needs. Check out the Asana API documentation for details. For example, the following URL will return the records for the current authenticated user.

https://app.asana.com/api/1.0/users/me
14 json url
  • Add the following authorization string with your access token to the Request headers field:
Authorization: Bearer {your-access-token}
15 request headers
  • Add the following string to the Path field:
data
16 path

Note: You may need to use fields URL query parameters and Columns to customize your queries to the Asana API and return more refined data. We’ll check them out in the examples below.

Now you can jump to the destination settings.

Set up destination

  • Choose Google Sheets as the destination app.
5 google sheets destination
  • Connect your Google account.
5.2 connect google account
  • Pick a spreadsheet on your Google Drive and select a sheet where you want to load the data from Asana. You can create a new sheet by entering a new name.
17 destination

Note: You can also benefit from optional parameters, such as Cell address and Import mode. Read more about it in the Coupler.io documentation

Сlick Save and Run and check out the data in your spreadsheet by clicking View Results.

18 view results

Import Asana data to Google Sheets automatically on a schedule

Coupler.io allows you to schedule data refresh from Asana at a custom frequency, such as every hour, every day, etc. For this, you need to enable the Automatic data refresh and configure the schedule.

6 hubspot export schedule

Now let’s check out this Asana Google Sheets integration in practice.

Export Asana tasks to Google Sheets

You can export tasks from Asana by project or tag, subtasks per task, and many more. Here is a list of endpoints related to exporting Asana tasks via API.

EndpointDescription
/tasksReturns the compact task records for some filtered set of tasks.
/tasks/{task_gid}Returns the complete task record for a single task.
/projects/{project_gid}/tasksReturns the compact task records for all tasks within the given project, ordered by their priority within the project. 
/sections/{section_gid}/tasksBoard view only: Returns the compact section records for all tasks within the given section.
/tags/{tag_gid}/tasksReturns the compact task records for all tasks with the given tag.
/user_task_lists/{user_task_list_gid}/tasksReturns the compact list of tasks in a user’s My Tasks list.
/tasks/{task_gid}/subtasksReturns a compact representation of all of the subtasks of a task.
/tasks/{task_gid}/dependenciesReturns the compact representations of all of the dependencies of a task.
/tasks/{task_gid}/dependentsReturns the compact representations of all of the dependents of a task.
/workspaces/{workspace_gid}/tasks/searchAllows you to build complex filters to find and retrieve the exact data on tasks.
*gid is a globally unique identifier

Note: You can’t export all tasks from your Asana workspace in bulk. They must be filtered by either assignee, or project, or section.

Let’s return the compact records for the tasks filtered by the project. Here are the parameters you’ll need to apply:

JSON URL

https://app.asana.com/api/1.0/tasks

Request headers

Authorization: Bearer {your-access-token}

URL query parameters

project: {project_gid}

Path

data
19 tasks by project parameters

Here is what we’ve got:

20 asana tasks in google sheets

We used the URL query parameters field this time to filter tasks by project. However, this field can be avoided if you use the following API URL instead:

JSON URL

https://app.asana.com/api/1.0//projects/{project_gid}/tasks

Load Asana custom fields in Google Sheets

Check out another example – how you can export custom fields from Asana to Google Sheets. Here are the options available:

EndpointDescription
/custom_fields/{custom_field_gid}Returns the complete definition of a specific custom field’s metadata.
/workspaces/{workspace_gid}/custom_fieldsReturns a list of the compact representation of all of the custom fields in a workspace.

We’ll export a list of all of the custom fields in our workspace using the following parameters:

JSON URL

https://app.asana.com/api/1.0/workspaces/{workspace_gid}/custom_fields

Request headers

Authorization: Bearer {your-access-token}

Path

data
21 custom fields parameters

Here is the result in Google Sheets:

22 asana custom fields google sheets

As well as the examples we introduced above, you can export many other entities from Asana to Google Sheets using Coupler.io. Check out the Asana API documentation to learn the entire list of endpoints for Asana API URL and their parameters. 

Bonus: how you can export the Asana calendar to Google Sheets

Unfortunately, you can’t export calendar data from Asana to GSheets with Coupler.io because there is no such entity in Asana API. However, there is a workaround that we’d like to share with you.

Asana allows you to sync any project, tag, or My Tasks list to Google Calendar. You can see this option in the drop-down menu:

23 sync to calendar option

Once you click it, you’ll get a URL, which you’ll need to copy and paste in Google Calendar. 

24 url to sync calendar

After successful synchronization, you can export Google Calendar to Google Sheets. We’ve blogged about this and provided several options, so check them out in our Export Google Calendar to Google Sheets article for more information.

Good luck with your data!

Back to Blog

Comments are closed.

Access your data
in a simple format for free!

Start Free