Import and analyze Zendesk data with Google Sheets

Want to get more out of Google Docs for work or school? Sign up for a Google Workspace trial at no charge.

Important: 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 Extensions and then 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  Extensions 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  Extensions 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  Extensions 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?
true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu
Search Help Center
true
35
false
false