Rowsmith

Help

How to get your Asana projects into Google Sheets.

Getting started

  1. Install Rowsmith from the Google Workspace Marketplace (or from Extensions → Add-ons → Get add-ons in Google Sheets).
  2. Open a spreadsheet and choose Extensions → Rowsmith for Asana → Open Rowsmith.
  3. Click Connect Asana and approve read-only access in the tab that opens. Come back to your sheet when it says "Asana connected".
  4. 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

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.

Contact

Email rowsmithhq@gmail.com. We read every message.