Sparrow Import for Trello
Import Trello cards into Google Sheets and keep them fresh.
What it imports
Pick a board and, if you like, one list, choose the fields, and import the cards into a sheet: name, description, list, labels, members, due date, checklist progress, link, last activity and your custom fields.
Connect your Trello account
- Open https://trello.com/power-ups/admin, create a Power-Up (any name), then open its API key tab and generate a key. On the same page, click the Token link next to your API key, allow access, and copy the token. Paste both in Connect.
- In Google Sheets, open Extensions, then Sparrow Import for Trello, 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 Trello API key and 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 Trello?
No. The add-on only reads from Trello. 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 Trello, 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 Trello API key and 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.