Back to Blog

Asana to BigQuery Integration Without Coding

Asana allows you to export your project data in CSV and JSON formats. This way you can load data from Asana to BigQuery. However, it’s not actually connecting Asana and BigQuery, but rather a manual download and upload of files. It may work for a one-time purpose. 

On the other hand, if you want to automate the export of data from Asana to BigQuery on a schedule, you need to integrate these apps. This can be done either with or without coding. The latter sounds more attractive, doesn’t it? So, let’s see how it works.

How to connect Asana to BigQuery without coding

To connect Asana to BigQuery, you’ll need to complete the following steps:

  1. Get a personal access token in Asana
  2. Set up an Asana to BigQuery integration using Coupler.io
    • Specify the data to export 
    • Connect a BigQuery project and specify the dataset and table for the exported data
    • Configure the schedule for automated data exports

Let’s see how it works.

Connect Asana to BigQuery via API without coding

To export Asana to BigQuery on a schedule, we will use the Asana API and Coupler.io, a tool that will let you connect to the API without any coding. 

Coupler.io also provides a number of ready-to-use integrations, such as Trello, Jira, Airtable, and many more. In addition to BigQuery, you can select other destinations: Google Sheets and Microsoft Excel. 

Some say that the Asana integration will be available soon as well. Meanwhile, you can configure the Asana to BigQuery connection yourself using the Asana API. For this, you need to obtain a personal access token.

Get a personal access token in Asana

1 create new token asana
  • Name your token, and agree to the API terms and conditions, then 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

Set up the Asana to BigQuery integration

Sign up to Coupler.io, click Add new importer, and select the following apps:

  • JSON as a source
  • BigQuery as a destination 
2.0 json bigquery

Then proceed to the configuration. 

Set up source

  • Enter the Asana API URL with the endpoint that corresponds to the data you want to export to BigQuery. 
https://app.asana.com/api/1.0/{endpoint}

You can learn the most common endpoints in this section. To get information about all the available endpoints, go to the Asana API documentation

For this example, we use the following URL to return the tasks for the specified project:

https://app.asana.com/api/1.0/tasks
2.1 asana json url
  • Leave GET as the HTTP method and add the following request header:
    • Key – Authorization
    • Value – Bearer {your-access-token}

You need to enter your access token instead of {your-access-token}

2.2 request header
  • Provide the query parameters to narrow your results. In our example, we are exporting tasks of a specific project. So, we need to specify a project’s ID as follows:
    • Key –  project
    • Value – {project-id} 
2.3 url query parameters

Note: You can learn the project ID in the URL when you open the project in Asana.

2.4 asana project id

For other data entities, you can use different query parameters to filter the exported results.

  • One more parameter to be configured is Path. Enter the following string:
data
16 path

Now you can jump to the configuration of BigQuery as your destination.

Set up destination

  • Connect your BigQuery project. For this, you’ll need to generate a Google Cloud JSON key file. Here are detailed instructions on how to do this.
  • Once connected, specify a dataset and a table to load data from Asana. You can create a new dataset and table by typing in their names.
2.5 bigquery destination setup

Proceed to the Schedule settings to export Asana to BigQuery automatically.

Set up schedule

With Coupler.io, you can connect Asana to BigQuery to export data at a custom frequency, for example, every day from Tuesday to Thursday at 7 am. For this, toggle on the Automatic data refresh and configure the desired schedule.

2.6 schedule asana bigquery

The last thing you need to do is click Save and Run to run your Asana to BigQuery integration. You can check out the results if you click View Results after the run. 

2.7 view results bigquery asana integration

There you go!

2.8 tasks exported from asana

What data you can export from Asana to BigQuery via the API

Above, we’ve set up the Asana to BigQuery integration to automate the export of tasks for a specific project. But you can do way more. Below, we introduce the endpoints for importing the most common data entities from Asana.

Export projects from Asana to BigQuery via the API

EndpointDescription
/projectsReturns the compact project records for a filtered set of projects.
/projects/{project-id}Returns the complete project record for a single project.
/tasks/{task_id}/projectsReturns a compact representation of all of the projects the task is in.
/teams/{team_id}/projectsReturns the compact project records for all projects in the team.
/workspaces/{workspace_id}/projectsReturns the compact project records for all projects in the workspace.

Export tasks from Asana to BigQuery via the API

EndpointDescription
/tasksReturns the compact task records for a filtered set of tasks.
/tasks/{task_id}Returns the complete task record for a single task.
/projects/{project_id}/tasksReturns the compact task records for all tasks within the given project, ordered by their priority within the project. 
/sections/{section_id}/tasksBoard view only: Returns the compact section records for all tasks within the given section.
/tags/{tag_id}/tasksReturns the compact task records for all tasks with the given tag.
/user_task_lists/{user_task_list_id}/tasksReturns the compact list of tasks in a user’s My Tasks list.
/tasks/{task_id}/subtasksReturns a compact representation of all of the subtasks of a task.
/tasks/{task_id}/dependenciesReturns the compact representations of all of the dependencies of a task.
/tasks/{task_id}/dependentsReturns the compact representations of all of the dependents of a task.
/workspaces/{workspace_id}/tasks/searchAllows you to build complex filters to find and retrieve the exact data on tasks.

Export sections from Asana to BigQuery via the API

EndpointDescription
/sections/{section-id}Returns the complete record for a single section.
/projects/{project_id}/sectionsReturns the compact records for all sections in the specified project.

Export stories from Asana to BigQuery via the API

EndpointDescription
/stories/{story-id}Returns the full record for a single story.
/tasks/{task_id}/storiesReturns the compact records for all stories on the task.

Export tags from Asana to BigQuery via the API

EndpointDescription
/tagsReturns the compact tag records for a filtered set of tags.
/tags/{tag-id}Returns the complete tag record for a single tag.
/tasks/{task_id}/tagsReturns a compact representation of all of the tags the task has.
/workspaces/{workspace_id}/tagsReturns the compact tag records for a filtered set of tags

Export teams from Asana to BigQuery via the API

EndpointDescription
/users/{user_id}/teamsReturns the compact records for all teams to which the given user is assigned.
/workspaces/{workspace_id}/teamsReturns the compact records for all teams in the workspace visible to the authorized user.
/teams/{team_id}Returns the full record for a single team.

Export users from Asana to BigQuery via the API

EndpointDescription
/usersReturns the user records for all users in all workspaces and organizations accessible to the authenticated user.
/users/{user_id}Returns the full user record for the single user with the provided ID.
/users/{user_id}/favoritesReturns all of a user’s favorites in the given workspace, of the given type.
/teams/{team_id}/usersReturns the compact records for all users that are members of the team.
/workspaces/{workspace_id}/usersReturns the compact records for all users in the specified workspace or organization.

Export workspaces from Asana to BigQuery via the API

EndpointDescription
/workspacesReturns the compact records for all workspaces visible to the authorized user.
/workspaces/{workspace_id}Returns the full workspace record for a single workspace.

Portfolios from Asana to BigQuery

Asana Business and Enterprise subscribers can manage their portfolios and export them directly to Google Sheets. Then you can import Google Sheets to BigQuery, but you can also connect Asana to BigQuery to export portfolio data directly. Here are the configurations for different cases.

EndpointRequired URL query stringDescription
/portfoliosworkspace={workspace-id}
owner={user-id}
Returns a list of the portfolios in compact representation that are owned by the current API user.
/portfolios/{portfolio_id}Returns the complete portfolio record for a single portfolio.
/portfolios/{portfolio_id}/itemsReturns a list of the items in a compact form in a portfolio.

Why is this way to export Asana to BigQuery better than the native one?

Some users may be scared of any technical stuff especially dealing with APIs. However, in this blog post, we demonstrated that using the right no-code tool lets you connect to the Asana API and export data to BigQuery with just a few clicks. 

Besides, we’d like to reveal one disclaimer. The Coupler.io team works on new integrations and it’s likely that you will have a ready-to-use Asana to BigQuery integration very soon. Meanwhile, you can play with the JSON integration to export Asana to BigQuery. Good luck with your data!

Back to Blog

Comments are closed.

Focus on your business
goals while we take care of your data!

Try Coupler.io