Search API Connector Documentation
Import Freshdesk Data to Google Sheets
In this article we'll be connecting to the Freshdesk API from Google Sheets, using the API Connector add-on for Sheets.
Freshdesk is a cloud-based customer support platform with a rich collection of API endpoints that allow you to easily collect data from just about anywhere within your customer support pipeline. So let's jump in and see what we can fetch!
- Before You Begin
- Part 1: Get your Freshdesk API Key
- Part 2: Pull Data from the Freshdesk API into Sheets
- Part 3: Create a Custom Request
- Part 4: Handle Pagination
- Part 5: API Documentation
Before You Begin
Click here to install the API Connector add-on from the Google Marketplace.
Part 1: Get your Freshdesk API Key
- Log in to Freshdesk to gain access to your API key. Once logged in, navigate to the main dashboard, click on your profile pic in the top right corner and click Profile Settings.
- Your API key will be on the right side, ready to go! Copy that down as we'll need it shortly.
- One last step. Freshdesk uses Basic Authentication, so you need to encode your API key. To encode your credentials, type your API key into this form, using the format
APIkey:X(your API key, a colon, and then the capital letter X). Your encoded credentials will appear underneath.
The encoding script runs in your browser, and none of your credentials are seen or stored by this site.
Part 2: Pull Data from the Freshdesk API into Sheets
The easiest way to get started with the Freshdesk API is through API Connector’s built-in integration.
- In Sheets, open API Connector and create a new request (Extensions > API Connector > Open > Create request)
- Select Freshdesk from the drop-down list of applications
- Under Authorization, enter your encoded API key with the word Basic in front.
- Choose an endpoint, for example
- Enter your Freshdesk domain in the path parameters section.
- Choose a destination sheet, name your request, and hit Run to see the response data in your sheet.
Part 3: Create a Custom API Request
Alternatively, you can run your own custom requests instead of using API Connector’s pre-built integration, using any of the endpoints and parameters shown in the API documentation. Here's a sample request setup. Substitute in your own sitename where it says
site, and your own encoded API key where it says
- Request URL:
Part 4: Handle Pagination
By default, Freshdesk limits the number of records returned at one time to 30, as described here.
You can loop through pages automatically with pagination handling (paid feature). Freshdesk’s documentation shows that next page URLs are provided in a field called “Link”, so you would loop through your records like this:
- Pagination: next page URL
- Next page path: Link
- Run until: choose when to stop fetching data
Part 5: API Documentation
Official API documentation: https://developers.freshdesk.com/api/