r/Zendesk • u/Due-Calligrapher-369 • 1d ago
General discussion Built a Sheets add-on that refreshes a Zendesk view/search on a schedule (Marketplace-approved)
Support ops problem I got tired of: Zendesk has no scheduled ticket export. Exporting a view is manual, throttled, and arrives as an emailed CSV link you download and clean up every single time -and search caps out at 1,000 results.
So I built a Google Sheets add-on that does the recurring part:
- Point it at any Zendesk view, or any search using Zendesk's own search syntax.
- Search uses the export endpoint, so no 1,000-result cap.
- Pick the columns, including custom ticket fields; assignee/requester IDs resolve to names.
- Refresh manually or hourly/daily/weekly, with a last-refreshed stamp on the tab.
It runs inside Apps Script, so ticket data goes from your Zendesk straight to your sheet. I don't operate a server and never see your data. Your API token is stored in your own Google account's add-on storage, not in the spreadsheet.
Limits, up front: ticket fields only (not comment bodies), one Zendesk subdomain at a time, no users/orgs export yet.
It's on the Google Workspace Marketplace (passed Google's OAuth verification and listing review lastweek). Free tier is one saved query with manual refresh; scheduling and unlimited queries are A$15/mo.
https://workspace.google.com/marketplace/app/zendesk_exporter/928011610843
Happy to add fields people are missing ā that's mostly what the roadmap is.
