Search API Connector Documentation
Import Zendesk Data to Google Sheets
In this guide, we’ll walk through how to pull data from the Zendesk API directly into Google Sheets, using the API Connector add-on.
We’ll first get an API key from Zendesk, and then set up a request to pull in Zendesk data to your spreadsheet.
- Before You Begin
- Part 1: Get your Zendesk API Token
- Part 2: Pull Data from Zendesk to Sheets
- Part 3: Create a Custom API 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 Zendesk API Token
- While logged into your Zendesk account, click Channels > API from the main dashboard.
- Tick the checkbox to agree to the terms of service, and click Get Started.
- Enable the setting for Token Access, and then click the plus (+) sign to add a new token.
- You will now see a token. Copy this and keep it secure as it won’t be displayed again.
- One last step: Because the Zendesk API requires Basic Authentication, we need to encode our authentication info to base 64. You can do this by entering your your credentials in the format
your_email_address/token:your_api_tokeninto this form, e.g.
[email protected]/token:6wiIBWbGkBMo1mRDMuVwkw1EPsNkeUj95PIz2akv. 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 Zendesk to Sheets
The easiest way to get started with the Zendesk API is through API Connector’s built-in integration.
- Select Zendesk from the drop-down list of applications
- Under Authorization, enter your encoded API token, with the word Basic in front.
- Choose an endpoint, for example
- Enter any required parameters. In this case, that’s just the subdomain of your site.
- 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. When you create a custom request, you add your complete URL into the request URL field and enter a Header where Key =
Authorization, Value =
To easily convert from a preset request to a custom API URL, tick the Add request URL box before running your preset request (under Output options). This will print out your complete API URL, which you can then copy/paste into the request URL field.
Part 4: Handle Pagination
Zendesk limits the number of records returned in each request. By default, only 100 records will be returned unless you use the ‘page’ parameter as described in their documentation.
With API Connector, you can cycle through their “next_page” links automatically with pagination handling (paid feature), like this:
next page URL
- Next page path:
- Run until: choose when to stop fetching data
Part 5: API Documentation
Official API documentation: https://developer.zendesk.com/rest_api/docs/support/introduction