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?

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

Portfolios in Asana help you monitor the progress of key initiatives. The Asana and Google Sheets integration lets you use your Asana portfolio data to build custom reports — tables, charts, scatterplots, and more — in Google Sheets.

Get insights on the rate at which initiatives are progressing, who on your team is completing work the fastest, and more.

How to create Asana reports using Google Sheets

  1. In Asana, navigate to Portfolios.
  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 your portfolio 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

Start Free Trial