30 articles across 4 topics
Getting Started
8Asana to Sheets is a Google Workspace add-on that syncs data between Asana and Google Sheets. It lets you view, analyze, and (with two-way sync) edit Asana tasks directly in Google Sheets, so you stop exporting CSVs by hand.
Asana to Sheets offers a 7-day free trial with no credit card required. After the trial, you can choose from our Starter, Pro, or Business plans based on your needs. The Business plan is required for two-way sync and live sync.
Open Google Sheets, click on the "Extensions" menu, select "Add-ons", and then "Get add-ons". Search for "Asana to Sheets" and install it. Once installed, you can open it from the right panel sidebar.
Project managers, team leads, operations and finance people, and anyone who reports on Asana work in spreadsheets. It suits teams that already build their reports, budgets, or client updates in Google Sheets.
No. If you are comfortable in Google Sheets and Asana, you can use it. You sign in to Asana from the sidebar, pick a project, and choose how often it refreshes.
Disconnect your current Asana account from the menu in the top right corner of the add-on, then reconnect with any Asana account. Make sure you are signed in to the account you want in your browser before reconnecting.
Refresh the page and sign in again. If problems persist, use the "Reset Connection" option in the add-on settings to reestablish your Asana connection.
Email support@upsys-consulting.com with a short description and, if you can, a screenshot. Our team typically responds within 24 hours on business days.
Syncing
11Tasks from your projects (with sections, subtasks, assignee, followers, tags, dates, and notes), custom fields, time tracking entries, and the people in your workspace. What you see also depends on your Asana plan and your own access in Asana.
Choose a team, then a project, and the add-on syncs that project's tasks. Asana has no saved views the API can read, so each sync carries its own filters: section, assignee, completed state, or due date.
Portfolios are an optional source for people on an Asana plan that includes them. Asana only lists the portfolios you own, so a portfolio owned by a colleague will not show up in your picker.
Scheduled syncs run every 3 hours (Pro and Business). You can also trigger a sync manually at any time, and Business can turn on live sync so changes in Asana arrive in seconds. If Asana's rate limit is hit, the add-on waits and tries again.
Yes. Connect the workspace you need for each sync and send the data to different sheets or the same spreadsheet.
Two-way sync lets you edit Asana tasks in Google Sheets and send the changes back to Asana (Business plan). Edited rows are marked so you can review them before they sync. Asana has no checklists, multiple assignees, or task-level archive, so those cannot be edited from the sheet.
Asana tasks have a single assignee. Followers are a separate column, and a people custom field can hold additional names.
Asana tasks have no built-in status. The status column shows the task's section on your board, and completed tasks are marked as done. If your project has an Asana status field, you can sync that as well.
Asana has no built-in priority or points. Both are custom fields your team creates, so the add-on can only fill them when your project has such a field. Pick the number field you use for points in the sync settings.
For scheduled syncs, use the "Repair Scheduled Sync" option on the homepage. If Asana asks you to sign in again, use "Reconnect". You can also delete the sync and its sheet and create a new one.
Don't delete or rearrange columns in a synced sheet. You can safely resize and hide columns. If you need a different layout, create another sheet that reads the synced data with QUERY, FILTER, or other Google Sheets functions.
Time Tracking & Reports
3Asana only offers time tracking on Advanced and higher plans. On other plans the time entry sync has nothing to read, and the add-on tells you so.
The task, the project it is attributed to, the person, the date, the duration in minutes, and a description where your Asana setup records one. Asana's API returns a date and a duration only, so there are no start or end times.
Yes. Since your data is in Google Sheets, you can build charts, pivot tables, and dashboards with Sheets' built-in tools, or connect the sheet to a reporting tool such as Looker Studio.
Account & Billing
8Starter: up to 3 manual syncs. Pro: unlimited syncs, scheduled syncs, time entries, user syncs, and reports. Business: everything in Pro plus two-way sync and live sync.
Yes, at any time. An upgrade unlocks the extra features right away. A downgrade applies from the start of your next billing cycle.
You'll be prompted to select a plan to keep using Asana to Sheets. If you don't subscribe, your syncs stop working, but the data stays in your spreadsheets until you delete it.
Open the Stripe customer portal from the billing section in the add-on. There you can view invoices, update your payment method, add or remove seats, or cancel.
We offer a 30-day money-back guarantee. If Asana to Sheets isn't working for you within the first 30 days of a paid subscription, contact us for a full refund.
Manual and scheduled syncs run inside your Google account and send Asana data straight into your sheet, not through our servers. Live sync is the exception: it needs Asana to notify our server of changes, so we keep task IDs and an encrypted Asana and Google sign-in while it is on. We do not back up your data. Use Google Drive version history for sheets that matter.
It needs access to your Google Sheets and permission to make requests to the Asana API for you. You grant Asana access through Asana's own OAuth screen, and you can revoke it from your Asana account settings at any time.
No. Asana to Sheets is made by UpSys and is not affiliated with, endorsed by, or sponsored by Asana, Inc. Asana is a trademark of Asana, Inc.
Report a bug or ask for a feature
Submit a feature request or bug report and we'll review every one.
Can't find your answer?
Email us. We usually reply within 24 hours on business days.