About
Export Zendesk inquiry data to a spreadsheet using the Zendesk API.
Environment
- Google Apps Script (Installable triggers with Google Spreadsheet)
Installation
- Select Make a copy
- Tools > Script editor (Then it opens Google Apps Script editor)
- File > Project properties
- Script properties > Add rows
- API_TOKEN: Zendesk API token (You can get token: https://[subdomain].zendesk.com/agent/admin/api/settings)
- MAIL_ADDRESS: Zendesk login mail address (admin user)
- SUB_DOMAIN: Zendesk subdomain
- Save
- Select function
- select fetchTickets function
- Select play button
- Edit > Current project's triggers
- Add Trigger
- Trigger setting
- Choose which function to run: fetchTickets
- Select event source: Time-driven
- Select type of time based trigger: Day timer daily
- Save
- Done!
Limitations
When you use it, you should consider the following limitations.
- Spreadsheet limitation: https://support.google.com/drive/answer/37603?hl=en
- Apps Script Quotas (Script runtime) : https://developers.google.com/apps-script/guides/services/quotas
- Zendesk API Rate limits: https://developer.zendesk.com/rest_api/docs/support/introduction#rate-limits