Export Asana tasks to Google Sheets™ once, then keep them in sync. Pick a project, portfolio or filtered view, choose your fields, and the spreadsheet fills in one row per task. On Business, edit a task in the sheet and push the change back to Asana.

It replaces the weekly Asana CSV export, and a Zapier zap per task event, for teams who report in spreadsheets. From the makers of ClickUp to Sheets.

▶ WHAT IT DOES

- Exports tasks, subtasks, custom fields, time entries and users from Asana into Google Sheets™
- Scheduled sync every 3 hours on Pro and Business runs with the sheet closed
- Live sync brings Asana changes in within seconds (Business)
- Two-way sync pushes your sheet edits back to Asana (Business)
- Filters a sync by section, assignee, completed state or due date
- Syncs the projects of a portfolio you own into one tab

▶ FIELDS THAT SYNC

- Name, ID, link, project, section, notes, assignee, followers, tags
- Start and due dates, the creation, modification and completion dates, the creator and the parent task
- Subtasks with their parent's name and progress ("2/6 done")
- Asana custom fields with their type kept: text, number, currency, percentage, single-select, multi-select, date, people. Formula fields come across read-only.
- Field renames don't break the sync, because each column is tied to the Asana field ID

▶ TWO-WAY SYNC (Business)

- Edit names, notes, dates, sections, completion, tags and custom fields in Google Sheets™
- It sends Asana only the cells you changed
- It marks each edited row so you can check it before it syncs

▶ REPORTS, TIME AND PEOPLE (Pro, Business)

- Reports and a subtask matrix built from your synced tasks
- Time tracking entries with task, project, person, date and duration (needs Asana Advanced or higher)
- Workspace members with their role: admin, member, guest or view-only

▶ HOW ASANA DIFFERS FROM OTHER TOOLS

- Asana tasks have one assignee, so the sheet shows one. Followers get their own column.
- Asana has no built-in status. The task's section plays that role, and a project's own Status field syncs as a column.
- Asana time entries carry a date and a duration, with no start or end time.

▶ SECURITY

- Signs in with Asana's own OAuth, so there's no API token to copy or paste
- Manual and scheduled syncs send data straight from Asana to your spreadsheet, not through our servers
- Live sync is the exception: Asana sends change events to our backend, which keeps the IDs of changed tasks, short-lived copies of values you wrote from the sheet so they aren't echoed back, and your encrypted Asana and Google™ sign-ins. We don't sell your data or use it for ads.

▶ PLANS (7-day free trial, no credit card)

- Starter at $9 a month: manual sync of up to 3 projects
- Pro at $19 a month: unlimited projects and scheduled sync, plus time entries, users and reports
- Business at $39 a month: everything in Pro, plus two-way sync and live sync

Yearly billing saves 2 months. 30-day money-back guarantee.

▶ WHO USES IT

- Project managers who build Asana reports and dashboards in Google Sheets™
- Ops teams feeding Looker Studio or pivot tables with Asana data
- Finance teams tracking budgets and hours across Asana projects
- Anyone sharing Asana data with people who don't have an Asana seat
- Anyone tired of exporting a CSV from Asana every week

▶ SUPPORT

Email support from the people who build it, and a setup guide at asanatosheets.com/support.

Install it, connect Asana and pick a project. Your first sync runs in under a minute.

▶ TRADEMARKS

Google Sheets™, Google Workspace™ and Google™ are trademarks of Google LLC. Asana® is a registered trademark of Asana, Inc. Asana to Sheets™ is an independent integration from UpSys Consulting, not endorsed by or affiliated with Google LLC or Asana, Inc.