Help
How to get your Asana projects into Google Sheets.
Getting started
- Install Rowsmith from the Google Workspace Marketplace (or from Extensions → Add-ons → Get add-ons in Google Sheets).
- Open a spreadsheet and choose Extensions → Rowsmith for Asana → Open Rowsmith.
- Click Connect Asana and approve read-only access in the tab that opens. Come back to your sheet when it says "Asana connected".
- Pick a workspace and a project, choose how often to refresh, and click Add to this sheet. A new tab appears with your tasks.
Adding your own columns
Add notes, formulas or formatting in the columns to the right of the synced data. Rowsmith keeps each task on its row and only rewrites its own columns, so your additions stay attached to the right task. If a new custom field appears in Asana, Rowsmith inserts a column for it and shifts your columns over — it never overwrites them.
Avoid editing the synced columns themselves: the next refresh replaces them with what's in Asana.
Refresh schedules
- Only when I click refresh — nothing runs in the background.
- Every hour / day / week — runs even while the sheet is closed. Google lets add-ons run at most once an hour.
Change a project's schedule any time under Settings on its card in the sidebar.
Snapshots and trend charts
Turn on Keep a daily snapshot and Rowsmith adds a history tab. Once a day it appends a copy of every task with the date in the first column. Build a pivot table or chart on that tab to see burndown (open tasks per day), throughput (tasks completed per day) or overdue trends.
To keep the spreadsheet under Google's 10 million cell limit, the history tab keeps every day for the last 90 days and one snapshot per week before that, and stays under about 3 million cells; past that, the oldest snapshots are removed as new ones are added (the card says so). Very big projects therefore keep fewer days. If you need the full history, copy the tab to another spreadsheet now and then.
Troubleshooting
When a refresh has a problem, the project's card in the sidebar says what happened. Here is what each message means.
- "Rowsmith is no longer signed in to Asana" — Asana access was revoked or expired. Click Reconnect Asana on the card, approve access, then refresh.
- "This Asana project was deleted or archived, or you lost access to it" — check the project in Asana. If it's gone for good, open Settings on the card and stop syncing it; the tab and its data stay in your sheet.
- Asana is busy or returned an error — usually temporary. Rowsmith tries again within the hour; you can also press Refresh.
- "This spreadsheet is full" — Google allows 10 million cells per spreadsheet (counting every tab's full grid, empty cells too). Rowsmith checks before it writes, so when a refresh wouldn't fit, nothing in the sheet is changed. The card names the biggest tabs. Delete unused tabs or old rows from a snapshot tab, turn off snapshots for that project (the card has a button), or move the project to a new spreadsheet.
- "Partial update" — the project is too big to fetch within Google's time limit for one run (about 6 minutes). Rows Rowsmith reached are updated; the others keep their last values. Scheduled refreshes keep catching up hourly, and snapshots wait for a complete run.
- "Stopped by Google's time limit" — Google ended the run before it finished. Rowsmith tries again within the hour.
- "Paused: the Free plan…" — the Free plan includes one project. The first project you added keeps working; upgrade to refresh the others. Nothing is deleted.
- "Something went wrong" — an unexpected error. Rowsmith tries again within the hour. If it keeps happening, email us the message shown on the card.
- Scheduled refresh didn't run — schedules run as the person who set them up, so they need access to both the sheet and the Asana project. Changes made only to subtasks, and deleted tasks, can take up to a day to show on hourly schedules; press Refresh to update now.
Contact
Email rowsmithhq@gmail.com. We read every message.