Google Sheets & Asana

When you’re handling many projects, understanding how well they’re going can be a challenge. With reporting in Google Sheets, you can use project data to create custom reports and visualizations to see what’s on track and what needs attention.

Google Sheet reporting is available with Portfolios.

Preparing to use Google Sheet reporting

Before opening a Google Sheet from your Portfolio, you should make sure you have the appropriate projectsprojects Projects are lists of tasks. Read more in your Portfolio.

If you haven’t used Google Sheets before, we recommend consulting Google’s Help Center and Google Sheets Help Forum. This particular article will explain how to run some basic reports with your Asana Portfolio data, but is not intended to explain all the ways you can use Google Sheets.

Reporting with Google Sheets gives you countless ways to sort and visualize the work you track in Asana. This article will help you get started and provide some inspiration for reports you might want to create.

Getting started with Portfolio reporting

Once you have the projects you need on your Portfolio, simply click Export to Google Sheets from the drop down menu next to your project header. Your Google Sheet will open in a new tab. First time users will need to authorize Asana to connect with their Google account.

Once created, the data in your Google Sheet will automatically update every hour.

What’s in the report

Out of the box, the Google Sheet includes three tabs:

  1. Overview—serves as a reference on how to use the Sheet, and contains two example charts created from your data.
  2. Asana project data—shows the most important data from each project. Explore this data by sorting or filtering by the columns.
  3. Live source data—pulls live data directly from Asana. This tab is locked to protect the connection to Asana.

You can hover over column headers to learn more about the data in the column.

Building custom reports

The Sheet comes standard with two example reports and two data tabs, but you will likely want to create custom reports for your team’s projects. With the data supplied in the Sheet, and by reading through the examples below, you should be able to achieve many of your reporting needs.

Reports you create are saved into the Sheet automatically, and they will appear the next time you open the Sheet from Asana.

Here are some examples of the kinds of reports you could create in your Google Sheet. We’ll dive into two of these below to show you how.

  • Which projects are at risk and due soon? A scatter chart of due date and status color (example below)
  • Which project owners are pushing work forward quickly? A bar chart of recent tasks completed by project owner (example below)
  • What portion of your projects are on track? A pie chart of status colors
  • Is work focused or spread across projects? A histogram of tasks completed in the past week in each project
  • Which teams have projects that are close to completion? A stacked bar chart of projects at % completion, by team

Example 1: A scatter chart of due date and status color

This example shows some of the techniques you’ll use to build a report to find the individual projects that most need your attention. We’ll build a report to identify projects that are due soon where the last status update is red, since those projects probably need the most urgent attention.

Create a new tab

Click the + on the bottom left of your sheet to create a new tab, and choose a name for your report.

Add columns to your report by referencing the Live source data tab

  1. Select the top left cell of your new blank tab
  2. Type =
  3. Navigate to the Live source data tab. Click the header of the column you want to copy into the other tab. In this case, we will reference the Name column. Press Enter.

  4. After pressing enter, you’ll be taken back to your report tab.
  5. Select the next cell to the right, and repeat steps 2 to 4 for the Due Date and Status Color columns.
  6. Now that we’ve referenced the header cell of each column, we need to copy across the data itself. Select all three headers, and use the autofill handle on the bottom right corner of your selection to drag down.

We’ve referenced the data in the Live source data tab, rather than just copying it. That means when the data in the Live source data tab automatically updates every hour, your report will also automatically update.

Calculate how long until each project is due, using a formula

  1. Type DAYS TILL DUE as a header in the fourth column
  2. Under it, enter the formula =DATEDIF(NOW(), B2, "D"), which calculates the number of days between now and the value in the Due Date column.

  3. Drag the autofill handle to populate the rest of your new column.

Create a scatter chart

  1. First we need to sort the report by Status Color. The easiest way is to open the Data menu and choose Filter. Then, use the menu on the Status Color column header to Sort A → Z.

  2. Select the Status Color, Days Till Due, and Name columns, in that order, by holding (on Mac) or CTRL (on PC) and clicking the letter above each column (C, D and A). These are the three columns we need in the scatter chart, and the Name column must be chosen last because it will be the label for each datapoint.

  3. Create a chart, by opening the Insert menu and choosing Chart.
  4. Choose a Scatter chart and uncheck Aggregate column C.

With this chart, you can visualize which of the near-due projects are in trouble. In the screenshot below, we’ve marked that “danger zone”, projects that are both red and due in less than 60 days. As the data is updated hourly from Asana, you can always check this chart to understand where to focus team efforts.

Example 2: Task completion rate by project owner

This example shows some of the techniques you’ll use to build a report where projects are grouped according to some property, in this case by project owner. We’ll build a report to find out how many tasks were completed this week in projects driven by each project owner. We can identify high-throughput teams, or a project ownerproject owner Every project can have one Project Owner. They are able to set status updates for the project. Read more who is encouraging their team to capture all tasks in Asana.

Create a pivot table to group the projects by owner

  1. Navigate to the Live source data tab.
  2. Select rows from row 2 onwards. We skip row 1 because a pivot table works best when the first row contains the headers.

  3. Open the Data menu and choose Pivot table. A new tab will open titled Pivot table.
  4. From the Pivot table tab, in the Report Editor sidebar, under Rows, choose Add field. Select the column you’d like to group your projects by, in this case Owner. Uncheck Show totals, since we don’t need that data in this example.

  5. Under Values, choose Add field. Select the column you’d like to understand for each group of projects—in this case, Tasks Completed.

  6. Check that the values for the group are summarized in the way you need. In this example, we want to see the total task completion rate for each group of projects, so we choose Sum.

Visualize the data

In many cases, an easier alternative to manually creating a chart is to use the Explore sidebar of Google Sheets, which generates relevant charts using artificial intelligence.

  1. Click Explore in the bottom right hand of the Sheet. In this example, a bar chart is a useful visualization of the task completion rate.
  2. To see a larger version of the chart, you can drag it into the main area of the Sheet. Right click the chart to customize it.

Create your own custom reports in Google Sheets

Managing multiple projects at once is never easy, but reporting with Google Sheets gives you the flexibility to visualize information and create the reports you need with ease. Use project data from your Portfolio to build reports and visualizations to see what’s on track, and what needs your attention.

Log in


Forgot password?

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Sign up

Please use your work email address, so we can connect you with your team in Asana.

Try Asana for free

Please use your work email address, so we can connect you with your team in Asana.

Start your free trial

Please use your work email address so we can connect you with your team in Asana.

Start your free trial

Please use your work email address so we can connect you with your team in Asana.

Get Asana Premium

Please use your work email address, so we can connect you with your team in Asana.

Get Asana Business

Please use your work email address, so we can connect you with your team in Asana.

Oops, we couldn’t sign you up!

We tried, but there was a problem creating your account. Please close this window and try again!

Hey there, we’ve already met!

Sorry, we don’t support this browser

Asana doesn’t work with the internet browser you are currently using. Please sign up using one of these supported browsers instead.

Please login or sign up for Asana to calculate your price


Forgot password?

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Hi, it looks like we haven’t met before.

Continue to sign up with .

Choose your language

Selecting a language changes the language and/or content on

Asana Lessons

Learn the Asana basics in less than 15 minutes with these quick lessons


Tasks Lessons

Track all of your work

3 Minutes

My Tasks

My Tasks Lessons

Always know what to do next

3 Minutes


Projects Lessons

Work with teammates

3 Minutes


Inbox Lessons

Communicate even faster

3 Minutes

You can use tasks to track, collaborate on, and organize all your work.

Tasks can be to-dos, ideas, notes, or reminders.

Assign a task to yourself or a teammate.

Press Tab+M to quickly assign a task to yourself.

Add a due date so your deadline is clear.

Add instructions and expectations in the task description field.

Type @ to link to other tasks, people, conversations, or projects.

When you @mention someone, they’ll be added to your task as a follower.

Followers get notified when new comments or attachments are added.

Add anyone who needs to stay up to date on your task as a follower.

They can always unfollow to stop getting notifications on your task.

Add comments to ask questions or give followers updates.

Heart a comment to let followers know you’ve seen it.

Add relevant files or irrelevant GIFs as attachments.

You can also attach directly from Dropbox, Google Drive, or Box.

Create subtasks to break your task into smaller steps.

When you’ve added a subtask, press enter to add another.

Subtasks can contain all the same details as regular tasks.

Click the comment bubble to add comments or attachments to a subtask.

You can create tasks from any screen using your top bar.

Every Task has a unique URL to easily copy and share.

Congrats! Looks like you’re up to the task.

On to the next lesson!

Always know what to do next with My Tasks.

My Tasks is a list of every task assigned to you.

It makes managing your work simple.

Click on your My Tasks list and start typing to add tasks.

Like a text document, add a new line for each new task or paste in any list.

Forward to to turn your emails into tasks.

Asana will translate your email into a task, including your attachments.

New tasks will appear at the top of your list in Recently Assigned.

Tasks you add to My Tasks are private to you.

Click Make Public to share them with your team.

Prioritize tasks as Today, Upcoming, or Later.

Click on the blue dot next to the task, to quickly sort it.

Mark the tasks you’ll have time for Today.

Teammates can view your My Tasks list to see what you’re up to.

They’ll only see tasks you’ve made public or shared in a project (more on projects later).

Mark tasks due within a week as Upcoming so you can see what will be due soon.

On its due date, your task will move from Upcoming to Today.

Just like magic.

Mark tasks due in more than a week for Later.

They’ll be out of your way until their due date approaches.

Your tasks will move from Later to Upcoming a week before they’re due.

Keep My Tasks prioritized to always know what to work on and what’s coming next.

Now you know how to track and plan your work!

Next, learn how to work with your team in Asana.

Work together on groups of tasks with projects.

Projects help you track and organize the steps in a process or initiative.

Like an event plan, product launch, or editorial calendar.

Like My Tasks, simply click and type to add tasks to your project.

If you have your steps in a document or email already, paste in that list.

Add tasks to your project from email.

View your project’s unique email address from the project dropdown menu.

Add your tasks to other related projects.

Tasks can be included in multiple projects.

Add sections to organize tasks in a list project.

Type Tab+N in any task row to create a new section.

Or, add columns to organize tasks in a boards project.

Drag and drop tasks between or within columns to reorder.

Assign your tasks and set due dates.

Never miss a deadline with your project calendar.

Drag and drop tasks on your calendar to change their due dates.

Add everyone who needs to stay updated on your project as members.

Project members will get notified of new conversations, statuses, and tasks.

Post conversations to make announcements or start discussions.

Your post will be sent to all project members.

Use Progress to see how your project is moving forward.

Set a project status to update your team on how it’s going.

The Project Owner will be reminded to set a status once a week.

Open and organize projects from your sidebar.

Favorite projects to pin them to the top of your sidebar.

Click the star button on the left of your project name to favorite it.

Create new projects from any screen using your top bar.

Now you can move projects forward with your team.

Just one more lesson before you dive in.

Communicate and coordinate faster with Inbox.

Check Inbox to quickly read and respond to your latest updates.

Inbox will notify you when you have a task due…

and when teammates update tasks, conversations, and projects you follow.

Open and respond to updates without leaving Inbox.

Click an update and you’ll have all the context you need to respond.

Archive updates you’re ready to dismiss.

Click the X that appears on the right of an update to archive it.

Open Archive to move dismissed updates back to your Inbox.

Click the arrow that appears on the right of an archived update to move it back to Inbox.

Unfollow tasks or projects to stop receiving updates about them.

In the end, you have control over the updates you receive (or choose not to receive)

When you’re ready, you can turn Asana’s Email notifications off.

Most communication with your team can be more easily managed from Inbox. Just remember to check it often.

Congratulations! Now you’re ready to have a great work day with Asana.