Google Sheets icon

Google Sheets + Asana

Turn Asana projects or tasks into spreadsheets in Google Sheets to create powerful reports. Edit and collaborate wherever you are–for free.

What is Google Sheets?

Google Sheets is a web-based spreadsheet application and part of Google Drive. It’s used for any function you’d normally use an excel spreadsheet for: tracking data, calculating expenses, creating reports, and more.

Google Sheets is especially powerful when linked with other commonly used applications and tools such as Asana, so you can get automated analytics on your application data.

Why use the Google Sheets and Asana integration?

Dashboard reporting in Google Sheets pulls data from Asana projects in My Dashboard so you can create custom reports and visualizations.

Asana Dashboards allow you to see progress across your projects at a glance, but you might need to do a deeper comparison across projects. The Asana and Google Sheets integration lets you use your Asana project data to build custom reports — tables, charts, scatterplots, and more — in Google Sheets.

Get insights on the projects that need attention, the rate at which initiatives are progressing, or who on your team is completing work the fastest.

How to create Asana reports using Google Sheets

  1. In Asana navigate to My Dashboard.
  2. Click Open Report in Google Sheets. (You’ll see this prompt in small type in the upper left).
  3. Allow Asana to view and manage your spreadsheets in Google Drive.
  4. Data from My Dashboard will then open in an organized Google Sheet in a new browser tab.

Learn More

What is Asana?

Asana is the easiest way for teams to plan, manage, and track their work—so you know who’s doing what by when. It’s free to get started and simple to use and powerful enough to run your entire business. Asana empowers teams to get great results. Learn more about Asana.

Asana works with the tools you already use