Sparrow Import for Freshdesk
Import Freshdesk tickets, contacts and companies into Google Sheets.
What it imports
Pick tickets, contacts or companies. For tickets you can keep all of them or only open, pending, resolved, closed or recently updated ones. Each ticket becomes a row in Google Sheets™ with status, priority and source as words, the requester's name and email, agent and group IDs, tags, dates and your custom fields.
Connect your Freshdesk account
- In Freshdesk, click your profile picture, open Profile settings and click View API key. Paste it in Connect with your helpdesk address, such as yourcompany.freshdesk.com. Help: https://support.freshdesk.com/support/solutions/articles/215517-how-to-find-your-api-key
- In Google Sheets, open Extensions, then Sparrow Import for Freshdesk, 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 Freshdesk API key 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 Freshdesk?
No. The add-on only reads from Freshdesk. 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 Freshdesk, 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 Freshdesk API key, 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.