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.
The prompt
Paste it into a new chat in General Input, and a specialist builds it with you.
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 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.
Make it yours
- 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.