Zendesk reporting in a live spreadsheet (planned)

Planned reports

What you will build on Zendesk

Each is one formula on live data. These are examples of the syntax: the column names will follow Zendesk's own fields once the integration ships.

=data.tickets.count(id, group, A2, status, "open")

Backlog by group. Open tickets per group and priority.

=data.ratings.count(id, score, "good")/data.ratings.count(id)

Satisfaction trend. Good ratings as a share of all ratings, by month.

=data.tickets.avg(first_reply_hours, agent, A2)

Response time. Median first-response time per agent.

The data

Tables from Zendesk

Tickets · Agents · Groups · Satisfaction ratings

How it will run

Your data stays in Zendesk

Sheets will open inside Zendesk, as an app in its own interface, and read your data through Zendesk's API with your permission. We plan to list it in the Zendesk Marketplace.

Want it?

Vote for Sheets for Zendesk

A thumbs up moves Zendesk up the roadmap. Leave your e-mail address too and we write once, when it ships.

Customer support: also planned

Intercomplanned

Gorgiasplanned

ServiceNowplanned

tickets and agents

Help Scoutplanned

tickets and agents

FAQ

Questions

Is Sheets for Zendesk available?

Not yet. Zendesk is on the Sheets roadmap. Give it a thumbs up and leave your e-mail address on this page: we tell you when it is ready, and the votes decide what we build next.

What will Sheets read from Zendesk?

Your tickets and agents, as tables: Tickets, Agents, Groups, and Satisfaction ratings. Each table becomes a data source that formulas, pivot tables and charts read live.

Will Sheets change anything in Zendesk?

It is planned read-only: Sheets reads your Zendesk data and does not change it.

What works today?

Sheets works today with QuickBooks Online, Xero, Shopify, WooCommerce, BigCommerce, HubSpot, FreshBooks, monday.com, and Asana.

Want Sheets for Zendesk?

Requests decide what we build next. We write once, when it is ready.

Tell me when it's ready

85 tools on the integrations page