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
- Navigate to your desired Portfolio in Asana
- Click on the drop-down arrow next to your Portfolio header
- Click Export and then Google Sheets
Portfolios are available to all Business and Enterprise customers.
Learn More
- Learn more about Google Sheets
- Did you know that you can turn emails into tasks from within Gmail, all without leaving your inbox? 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.