How to Connect Asana with Google Sheets | Unito 2-Way Sync
Asana Google Sheets 2-way Sync
How to Connect Asana with Google Sheets
Asana Google Sheets 2-way Sync

How to Connect Asana with Google Sheets

This guide will walk you through the process of syncing Asana tasks to Google Sheets with Unito. The most important thing to keep in mind is that Unito will identify titles in the first row of each spreadsheet (the table header) as fields which can be mapped to Asana tasks. Put another way, your rows will become tasks and your columns will become fields.

Although this guide demonstrates how to sync Asana tasks with Google Sheets, the same principles apply to other spreadsheet software, including Microsoft Excel, Airtable or Smartsheet.

Watch this 2-way Asana Google Sheets integration in action:

Why connect Asana and Google Sheets with Unito?

Syncing tasks to spreadsheet rows is especially helpful when you want to speed up the process of reviewing tasks from the uniformity and flexibility of a spreadsheet. You can build reports for stakeholders quickly and efficiently through simple automation. It’s also handy for reviewing budgets and expenses; resource management; and collaborating with external contractors, clients, or other contacts.

It’s also useful for sharing specific information about a task or project with an external contact without giving them full access to your Asana organization or workspace. You can even allow your external contact’s changes in Google Sheets to be automatically reflected in your Asana tasks with a 2-way sync.

Connecting Asana with Google Sheets with Unito enables you to:

  • Create new rows in Google Sheets populated with details from your Asana tasks, including: title, assignee, due date, status, sections & columns, descriptions, tags, attachments, and custom fields.
  • Create new Asana tasks based on Google Sheets rows with specified fields.
Asana tasks synced to Google Sheets rows with Unito's two-way integration
Our Asana Project synced to Google Sheets with Unito

Contents

Feel free to skip ahead if you’re already in the middle of building your Asana – Google Sheets flow.

Before we build our connection between Asana and Google Sheets:

  • Make sure you have an account in each tool with the right permissions to access and modify data. If you aren’t sure, head to app.asana.com and docs.google.com/spreadsheets to check.
  • Install the Unito add-on for Google Sheets by following these steps (also detailed below).
  • Set up header rows in Google Sheets: the first row of each sheet needs to clearly identify the data you’ll sync from Asana tasks. 

Step 1. Prepare your table header in Google Sheets

Unito syncs fields in Asana to rows in Google Sheets based on the table header. So be sure to give each column a name that’s intuitive and relates to whatever field you’re syncing over from an Asana task. As an example, the Asana fields: Task Name or Status should probably be synced to a sheet column with the same, or similar names.

If you aren’t sure where to begin, we created this Google Sheets template you can use to get started. We also have a similar template for Microsoft Excel users.

Google Sheets Header Asana Sync
Each cell in the first row represents a field for Unito. 

Step 2. Install the Unito add-on to your Google Workspace

Go to docs.google.com, select Extensions > Add-ons > Get add-ons. Do a quick search for “Unito” and add the extension to your workspace using the on-screen instructions. 

GoogleSheet - Marketplace add-on
You can find more detailed steps on this process here if needed.

Select your Unito add-on, Get started with Unito > Insert the two columns in this sheet. Unito will automatically create a column named UnitoID at the beginning of your first row and one named Last Modified at the end of it.

Insert two columns
This step is necessary for your fields to sync properly. You can also add these columns manually.

Step 3. Connect Asana and Google Sheets to Unito

Open the Unito App and click +Create Flow. Then, Start Here to connect Asana and Google Sheets. In our demo, we’ll put Asana on the left-hand side, and Google Sheets on the right. You’ll need to specify which account for each tool you wish to connect with Unito, as well as the specific board and sheet you wish to sync.

Asana Google Sheets Tool Connection with Unito
Type the name of your Google Sheet file or Asana project in the search bar to add it. If you create the file or project with Unito’s flow builder open, you’ll have to close the tab and re-open it in order for it to appear in the search bar.

When you’re ready, click Confirm.

Step 4. Set a flow direction between Asana and Google Sheets

Your data can sync either from only one app to the other, or bidirectionally. Flow direction determines how new rows are created but not modified in your spreadsheets. So if we choose a 1-way flow to Excel, that would mean adding any new rows in Google Sheets would add identical rows to your Excel spreadsheet, but not the other way around.`

Asana Google Sheets Flow Direction

NOTE: Here’s a breakdown of each option:

  • One-way from Asana to Google Sheets: tasks created in your Asana project will appear as new rows in the connected sheet, but not vice versa. This is a great option for building reports on work performed in Asana from the flexibility of a Google Sheet.
  • One-way from Google Sheets to Asana: Rows created in your connected sheet will appear as new Asana tasks, but not vice versa. This could be useful if you wanted to assign work from Google Sheets to users in Asana.
  • Two-way sync: Any new sheet rows or tasks created in their respective tools will appear in the other (rows as tasks, and tasks as rows).

Click Confirm when you’ve chosen a flow direction. 

Step 5. Set up rules to filter data between Asana and Google Sheets

Now we can choose rules that tell Unito when and which triggers will create new tasks in Asana and/or rows in Google Sheets. This step is only for row and task creation; if you choose a one-way flow here, you can still create a two-way sync for individual fields later on.

These triggers are intended to help you keep only the most relevant information in sync to avoid oversharing unnecessary details. There can be a lot of variability here that will depend on your particular needs and tool setup. By customizing your Asana tags, you can be even more precise about what kind of data is shared with Google Sheets.

Asana Google Sheets Rules Unito 2-way Sync

For this demo, we’ve told the system to create a matching row in Google Sheets for every task in our Asana project with the tags: “Demo Tag 1” and “Demo Tag 2.” If you’re syncing tasks, you consider filtering rules by progress, opting for tag names such as: in progress, blocked, done, etc.

Google Sheets Asana Rules Unito 2-way sync

In order to sync new rows back to Asana, you’ll have to add a column in your spreadsheet. In our case, we named it “sync” but you can pick any name that’s intuitive to your use case. Then, simply add that field as a trigger with the option: “any value”. This mean that if you fill in that cell, a new task will appear in Asana.

Find out more about setting rules.

Step 6. Set up field mappings between Asana and Google Sheets

At this stage, you’ll be presented with two options: if you choose Auto-map, Unito will pre-populate a list of suggested field mappings which you can then adjust. If you prefer a DIY approach, Start from scratch. We recommend mapping fields from scratch for this particular flow.

This image has an empty alt attribute; its file name is Asana-master-project-mappings-method-selection.png
Your fields will be automatically mapped for two-way updates, but you can adjust them as needed. With a one-way sync between fields, only the destination field will update automatically when you make changes in the source field.

When selecting your fields, you can break down the precise information you wish to sync by mapping them here. As mentioned above, each cell in your table header becomes a custom field that Unito can sync. You can then map those fields one-way or bi-directionally. In each case the flow direction functions as you might imagine:

  • In a one-way field mapping, changes in the source tool affect the other but not vice versa.
  • In a two-way field mapping, any change in Google Sheets or Asana will appear in the other.
If you realize halfway through your mappings that you’ve missed a few fields you want to sync from Asana, you’ll have to close the flow builder and re-open after you’ve added all the new columns to your Google Sheet table header.

After you’ve chosen a field in one tool, Unito will suggest compatible matches in the second tool when you click on the other drop-down menu. We recommend starting with Google Sheets, since there will be fewer fields to choose from.

Click Confirm when you’re satisfied with your field mappings to proceed.

Find out more about setting field mappings.

Step 7. Save, close, and launch your Asana – Google Sheets Flow!

And that’s it! Follow the remaining instructions to complete your flow and it should start syncing momentarily. Congratulations!

If you’ve followed the steps above, your flow will now create a row in Google Sheets whenever a new task is added in Asana based on the rules we set in Step 3.

Here is our Google Sheet synced to Asana with Unito
And the associated Asana project synced to Google Sheets.

If you have any questions, don’t hesitate to reach out and let us know.

What’s next after syncing Asana tasks to Google Sheets rows?