Planned · on the roadmap

Live spreadsheets for Help Scout

Sheets is coming to Help Scout: your tickets and agents as live tables that formulas, pivot tables and charts read directly, without exports.

  • Spreadsheet formulas
  • Pivot tables and charts
  • Scheduled e-mail reports
Planned reports

What you will build on Help Scout

Each is one formula on live data. These are examples of the syntax: the column names will follow Help Scout'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 Help Scout

Tickets · Agents · Groups · Satisfaction ratings

How it will run

Your data stays in Help Scout

You will sign in with your Help Scout account and give Sheets read access. Sheets runs on our servers in the EU and reads your data through Help Scout's API when a sheet opens or refreshes.

Want it?

Vote for Sheets for Help Scout

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

We use your details only to answer you. Privacy policy

FAQ

Questions

Is Sheets for Help Scout available?

Not yet. Help Scout 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 Help Scout?

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 Help Scout?

It is planned read-only: Sheets reads your Help Scout 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 Help Scout?

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

85 tools on the integrations page