Import and analyze Zendesk data with Google Sheets

 Note: This add-on is in English only.

Get the add-on

Before you can import or analyze Zendesk data with Google Sheets, download the add-on.

Step 1: Download add-on

  1. Open a sheet in Google Sheets.
  2. At the top, click Add-ons and then Get add-ons.
  3. In the top right search bar, search for "Data connector for Zendesk"
  4. Choose the add-on and click Install.

Step 2: Connect to Zendesk

  1. Open a sheet in Google Sheets.
  2. At the top, click Add-ons and then Data connector for Zendesk and then Open.
  3. Enter your Zendesk subdomain (eg. "myCompany" in myCompany.zendesk.com).
  4. Click Authorize.
  5. Sign into your Zendesk account (email and password) and click Sign in.
  6. Review access details, click Allow.
  7. Return to your spreadsheet.

Import data from Zendesk

Import data

Retrieve data from Zendesk in a Google spreadsheet.

  1. Open a sheet in Google Sheets.
  2. At the top, click Add-ons and then Data connector for Zendesk and then Open.
  3. At the right, choose an option:
    • Search: Build a query against Zendesk resources, selecting fields and filter conditions
    • Tickets: List tickets
    • Metrics: List metrics data

Update data

  1. Open a sheet in Google Sheets.
  2. At the top, click Add-ons and then Data connector for Zendesk and then Open.
  3. At the right, choose an option:
    • Load: Rerun a previously saved search
    • Refresh: Update query results already in your spreadsheet

Important: If you change data in your Google Sheet, it will not change data stored in Zendesk.

Learn about scripts and add-ons

Add-ons are covered by the Google Terms of Service and Privacy Policy, as well as the End Users Using Scripts or Add-ons.

Learn about scripts and add-ons

Add-ons are covered by Google Apps Script Additional Terms.

Was this helpful?
How can we improve it?