Daily Help Scout conversation log in Google Sheets
Every morning, add yesterday's support conversations to a Google Sheet so your dashboards and reports always have clean, up-to-date history to work from.
Integrations
Help Scout
Google Sheets
Type
Categories
- Customer Support
- Operations
Every day at 6am, sync yesterday's Help Scout conversations into a Google Sheet so my BI tools and dashboards have a clean, append-only history to read from. Build this as a deterministic code workflow with a fixed field-to-column mapping and no reasoning required.
On each run, compute the previous calendar day (from the start to the end of yesterday in my account's timezone) and call Help Scout List Conversations filtered to conversations created during that window, across all inboxes. Paginate through every page using 1-based page numbers (the default page size is 50) until you have collected every conversation created yesterday. Do not stop after the first page.
For each conversation, append one row to a dedicated tab in my Google Sheet using Google Sheets Append Values, so rows land after the last row of the table. Map the fields to fixed columns in this exact order: conversation id, subject, customer email, inbox (mailbox name), current status, assignee, tags (joined into a single cell), created timestamp, and a link back to the conversation in Help Scout (for example https://secure.helpscout.net/conversation/<id>). Keep the column order stable so downstream reporting never breaks.
Keep the sheet append-only: never update or overwrite existing rows, only add new ones after the last row, and always target the same dedicated tab. Respect Help Scout's 400 requests per minute rate limit by honoring the Retry-After header on any 429 response and paginating politely rather than hammering the API. If a run finds no conversations from yesterday, do nothing and leave the sheet unchanged.
What it does
- Automatically adds every support conversation from the previous day into a dedicated tab in your Google Sheet.
- Captures the key details for each one: subject, customer email, inbox, status, assignee, tags, when it was created, and a link straight back to it.
- Only ever adds new rows, so your existing history and any reports built on top of it stay stable.
- Runs on its own every morning, giving your BI tools and dashboards a reliable source to read from.
What you’ll need
- A Help Scout account with access to the inboxes you want to track.
- A Google account and a Google Sheet with a dedicated tab set aside for this history.
How to customize it
- Change what time it runs each day, or how often it runs.
- Add, remove, or reorder the columns captured for each conversation.
- Point it at a different spreadsheet or tab.
Use cases
- Data Sync
