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:
- Get a personal access token in Asana
- 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
- Open the Developer App Console and click +Create new token.
- Name your token, and agree to the API terms and conditions, then click Create token.
- Copy your access token to a spreadsheet or a text editor because you won’t see it in Asana again.
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
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.
For this example, we use the following URL to return the tasks for the specified project:
- Leave GET as the HTTP method and add the following request header:
- Key –
- Value –
- Key –
You need to enter your access token instead of
- 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 –
- Value –
- Key –
Note: You can learn the project ID in the URL when you open the project in Asana.
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:
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.
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.
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.
There you go!
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
|Returns the compact project records for a filtered set of projects.|
|Returns the complete project record for a single project.|
|Returns a compact representation of all of the projects the task is in.|
|Returns the compact project records for all projects in the team.|
|Returns the compact project records for all projects in the workspace.|
Export tasks from Asana to BigQuery via the API
|Returns the compact task records for a filtered set of tasks.|
|Returns the complete task record for a single task.|
|Returns the compact task records for all tasks within the given project, ordered by their priority within the project.|
|Board view only: Returns the compact section records for all tasks within the given section.|
|Returns the compact task records for all tasks with the given tag.|
|Returns the compact list of tasks in a user’s My Tasks list.|
|Returns a compact representation of all of the subtasks of a task.|
|Returns the compact representations of all of the dependencies of a task.|
|Returns the compact representations of all of the dependents of a task.|
|Allows you to build complex filters to find and retrieve the exact data on tasks.|
Export sections from Asana to BigQuery via the API
|Returns the complete record for a single section.|
|Returns the compact records for all sections in the specified project.|
Export stories from Asana to BigQuery via the API
|Returns the full record for a single story.|
|Returns the compact records for all stories on the task.|
|Returns the compact tag records for a filtered set of tags.|
|Returns the complete tag record for a single tag.|
|Returns a compact representation of all of the tags the task has.|
|Returns the compact tag records for a filtered set of tags|
Export teams from Asana to BigQuery via the API
|Returns the compact records for all teams to which the given user is assigned.|
|Returns the compact records for all teams in the workspace visible to the authorized user.|
|Returns the full record for a single team.|
Export users from Asana to BigQuery via the API
|Returns the user records for all users in all workspaces and organizations accessible to the authenticated user.|
|Returns the full user record for the single user with the provided ID.|
|Returns all of a user’s favorites in the given workspace, of the given type.|
|Returns the compact records for all users that are members of the team.|
|Returns the compact records for all users in the specified workspace or organization.|
Export workspaces from Asana to BigQuery via the API
|Returns the compact records for all workspaces visible to the authorized user.|
|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.
|Endpoint||Required URL query string||Description|
|Returns a list of the portfolios in compact representation that are owned by the current API user.|
|Returns the complete portfolio record for a single portfolio.|
|Returns 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