Export Freshdesk tickets, contacts and companies into Google Sheets™ on a schedule. Push bulk creates and updates back, but only after a dry run shows exactly what will change.
Coming soon
Not yet availableFreshdesk Bulk Importer & Exporter is a Google Sheets™ add-on published by Cody Labs. I'm the developer. It connects to your Freshdesk account with your subdomain and a personal API key, so there is no OAuth app and no partner review. It exports tickets, contacts, companies, agents, groups, satisfaction ratings and time entries, with custom fields flattened to one column each. It also creates and updates contacts, companies and tickets from a template, and it writes nothing until a dry run has passed on the exact rows you are about to apply. Your data flows between your Freshdesk account and your spreadsheet. Cody Labs runs no servers and never receives it. See the privacy policy.
Pull tickets by a Freshdesk filter query or by "updated since". Large exports are split by date so they get past Freshdesk's paging caps, with no gaps and no duplicates.
Hourly, daily or weekly, incremental by updated date. Changed rows are updated by ID, new rows are appended.
Required fields, dropdown and custom field values, agents, groups, companies and email format are checked against your live Freshdesk setup. Every row gets a plain status and message.
The Freshdesk ID is written back to the row after each create. Run it again and nothing is duplicated. Prior values are logged before any update. Nothing is ever deleted.
Enter your Freshdesk subdomain and API key. The add-on tests the key before storing it in your Google account's private add-on storage.
Choose tickets, contacts, companies, agents, groups, ratings or time entries, pick the columns, and run it. Add a schedule if you are on Pro.
Create a template tab, fill in rows, and click Dry run. Nothing is written to Freshdesk. Each row shows Ready, Unchanged or the reason it will be skipped.
Click Apply. If any row changed after the dry run, the add-on refuses and asks for a new dry run. Results and Freshdesk IDs are written back row by row.
No. It uses your own API key. There is nothing to register.
No. Version 1 has no delete action. It also does not merge records, send replies or handle attachments.
The add-on reads Freshdesk's rate-limit headers and honours Retry-After. Long jobs pause and continue by trigger, so they finish instead of timing out.
The prior value of every updated field is written to an undo log tab in your spreadsheet before the change is made.