# 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.

- Workflow type: code
- Services: Help Scout, Google Sheets
- Categories: Customer Support, Operations
- Published: 2026-07-17

## 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.

## Prompt

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.

## How to customize

- 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.

## FAQ

### Which conversations get added?

Every conversation created in Help Scout the previous day, across all of your inboxes. The workflow pages through all of them so nothing is missed.

### Will it change or delete rows I already have?

No. It only ever adds new rows to the bottom of your chosen tab, so your existing history and any dashboards built on it stay intact.

### What happens if there were no conversations yesterday?

The workflow simply does nothing that day and leaves your sheet untouched.

### Can I use this with my existing reporting tools?

Yes. Because everything lands in a clean Google Sheet, any BI or dashboard tool that can read a spreadsheet can build on top of it.

### Can I choose which details are recorded?

Yes. The columns are a simple, fixed mapping you can adjust, so you can add, remove, or reorder fields like status, assignee, or tags to match how your team reports.

Use this prompt in General Input: https://www.generalinput.com/prompts/daily-help-scout-conversation-log-in-google-sheets