Importe e analise dados do Zendesk com o Google Sheets

Pretende tirar maior partido do Google Docs para o trabalho ou para a escola? Inscreva-se numa avaliação gratuita do G Suite.

Importante: este suplemento só está disponível em inglês.

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 e, em seguida, 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 e, em seguida, Data connector for Zendesk e, em seguida, 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 e, em seguida, Data connector for Zendesk e, em seguida, 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 e, em seguida, Data connector for Zendesk e, em seguida, 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.

Saiba mais sobre scripts e suplementos

Os suplementos estão abrangidos pelos Termos Adicionais do Google Apps Script.

A informação foi útil?
Como podemos melhorá-la?