Sparrow Import for Asana
Import Asana tasks into Google Sheets and keep them fresh.
What it imports
Pick a workspace, a project and, if you like, one section, then import its tasks into Google Sheets™: name, notes, assignee, section, tags, due dates, completion, links and your custom fields.
Connect your Asana account
- In Asana, open https://app.asana.com/0/my-apps, click Create new token, give it any name and copy it. Paste it in Connect.
- In Google Sheets, open Extensions, then Sparrow Import for Asana, then Open.
- In Connect, paste what you copied and press Test connection.
Free and Pro
| Free | Pro | |
|---|---|---|
| Saved imports | 1 | Unlimited |
| Rows per import | The first 500 | Every row, up to the Google Sheets limit of 10 million cells |
| Refresh | By hand, one click | By hand, or every hour or every day |
| Fields | The standard set, chosen for you | Pick any fields |
| Price | Free | USD 12 a month or USD 119 a year, per add-on and Google account, plus tax where it applies |
Price
After you buy, Freemius emails you a licence key. Paste it under "Have a licence key?" in the sidebar.
Questions
Where is my Asana token stored?
In your own Google account, in the add-on's user storage (Apps Script user properties). It is never written into the sheet and never sent to us, so people you share the sheet with can't see it. Click Disconnect in the sidebar to remove it.
Does it change anything in Asana?
No. The add-on only reads from Asana. It never creates, edits or deletes anything there. It writes only to the sheet tab you pick in the spreadsheet you opened it in.
How often does it refresh?
Free imports refresh when you press Refresh in the sidebar or use Extensions, Sparrow Import for Asana, Refresh all imports. Pro refreshes each import every hour or every day (hourly is the fastest Google allows for add-ons). If a scheduled run can't open the sheet, it refreshes the next time you open it. Big imports finish over several runs.
Can people I share the sheet with use it?
Yes. Saved imports live in the spreadsheet. Each person connects with their own Asana token, and Pro is per Google account.
How do I cancel, and can I get a refund?
Cancel any time from the link in your Freemius emails, or write to us and we'll do it. Pro stays on until the end of the period you paid for. You can get a full refund within 14 days of a purchase: email sheets-help@sparrowplugins.com from the address you bought with.