Sparrow Import for Harvest
Import Harvest time, projects and invoices into Google Sheets.
What it imports
Pick what to import from Harvest: time entries, projects, clients, invoices or expenses. For time, invoices and expenses you can pick a date range such as this month or last year. Each record becomes a row in Google Sheets™ with names instead of ids, hours and amounts as numbers, and dates as dates.
Connect your Harvest account
- Open https://id.getharvest.com/developers, click Create new personal access token, give it any name, and copy the token and the Account ID shown under it. Paste both in Connect.
- In Google Sheets, open Extensions, then Sparrow Import for Harvest, 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 Harvest token and account ID 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 Harvest?
No. The add-on only reads from Harvest. 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 Harvest, 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 Harvest token and account ID, 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.