With Sheetgo, you can connect your Zendesk account directly to Google Sheets to automatically import tickets, users, organizations, and satisfaction ratings. This integration allows support teams to centralize helpdesk analytics, track KPIs, and automate reporting in real time—without manually exporting data from Zendesk. Automating Zendesk data into Sheets helps improve service response tracking, performance monitoring, and overall customer support visibility.
Prerequisites
- A Zendesk account with API access enabled.
- Your Zendesk subdomain (e.g., yourcompany.zendesk.com).
- A valid Zendesk API Token or OAuth 2.0 credentials.
- Access to the Zendesk REST API documentation: https://developer.zendesk.com/api-reference/ticketing/introduction/.
- A Sheetgo account connected to your Google Workspace.
Step 1: Identify the Required API Endpoint
Navigate to the Zendesk API Reference linked above and find the GET endpoint for the dataset you want to pull. For example, to retrieve a list of tickets, use: https://yourcompany.zendesk.com/api/v2/tickets.json. Replace yourcompany with your Zendesk subdomain. Other available endpoints include /users.json, /organizations.json, and /ticket_metrics.json, depending on your data requirements.
Step 2: Generate API Credentials
To authenticate, you can either use an API token or OAuth 2.0. For API Token: In Zendesk, go to Admin Center → Apps and Integrations → APIs → Zendesk API. Enable Token Access and click Add API Token. Copy and securely store the generated token. When using a token, you’ll authenticate using your email address and the token in a Basic Auth format: Authorization: Basic BASE64ENCODE(email/token:API_TOKEN). For OAuth 2.0, create a Zendesk OAuth client to get your Client ID, Client Secret, and Refresh Token.
Step 3: Open the Sheetgo API Connector
Log in to Sheetgo and open an existing workflow or create a new one. Click on Connect and choose API Request under Data Source. Then select HTTP Request as the method type. You’ll be prompted to enter the API URL and configure authentication and headers.
Step 4: Configure the API Request in Sheetgo
Open Sheetgo, create a new workflow, and choose HTTP Request as your data source. Enter your Zendesk API endpoint, such as: https://yourcompany.zendesk.com/api/v2/tickets.json. Then, paste the following header JSON into the configuration field:
{
"Authorization": "Bearer YOUR_ACCESS_TOKEN",
"Content-Type": "application/json",
"@refresh_token": {
"auth_method": "oauth2",
"auth_type": "OAuth",
"refresh_url": "https://yourcompany.zendesk.com/oauth/tokens",
"refresh_params": {
"client_id": "YOUR_CLIENT_ID",
"client_secret": "YOUR_CLIENT_SECRET",
"refresh_token": "YOUR_REFRESH_TOKEN",
"grant_type": "refresh_token"
}
},
"@pagination": {
"type": "link",
"next_link_key": "next_page"
}
}This configuration ensures Sheetgo automatically retrieves all paginated ticket data and refreshes expired tokens without manual reauthorization.
Step 5: Choose the Destination Spreadsheet
Select an existing Google Sheet or create a new one where Zendesk data will be imported. Define how columns map to fields such as ticket ID, subject, requester email, status, and created_at. Configure the workflow to overwrite or append records during scheduled updates.
Step 6: Execute the Sheetgo Connection
Click Run to execute the workflow. Sheetgo will send a GET request to Zendesk and import the ticket data into your selected spreadsheet. Once confirmed, enable automatic refreshes to keep your Zendesk data synchronized daily or hourly, allowing your support dashboards to update continuously without manual intervention.