# Weekly GetResponse email recap in Slack and Google Sheets

> Every Monday morning, get a written review of last week's newsletters in Slack plus a running Google Sheet of the numbers.

- Workflow type: agent
- Services: GetResponse, Slack, Google Sheets
- Categories: Marketing, Operations
- Published: 2026-07-11

## What it does

- Pulls every newsletter your GetResponse account sent in the last seven days, along with open, click, and unsubscribe stats for each one.
- Writes a short narrative that names your best and worst subject lines, calls out sends that missed your usual baseline, and flags engagement patterns across the week.
- Posts the recap to your marketing Slack channel with two or three concrete recommendations for next week's calendar.
- Appends one row per newsletter to a Google Sheet so the team can see week over week trends without opening GetResponse.

## What you'll need

- A GetResponse account with newsletter sending history and permission to read newsletter stats.
- A Slack workspace and a marketing channel you want the recap posted to.
- A Google account with edit access to the tracking sheet you want the numbers logged in.

## Prompt

Build an agent workflow that runs on a cron trigger every Monday at 8am in the account's local timezone and produces a written recap of last week's email performance from GetResponse, posts it to Slack, and logs the raw numbers to a Google Sheet.

Data collection. Call GetResponse List Newsletters filtered to sends from the last seven days (Monday through Sunday of the prior week). For each newsletter returned, call GetResponse Get Newsletter to pull the subject line, send time, recipient count, opens, clicks, unsubscribes, and any per-message stats the API exposes. If a specific stat is missing, fall back to GetResponse Get Contact Activities to reconstruct engagement counts. If zero newsletters went out in the window, skip straight to a short 'no sends last week' Slack note and stop.

Analysis. Compute per-newsletter open rate, click rate, and unsubscribe rate. Compare each send against the account's rolling baseline (use the trailing 30 days of newsletters as the baseline; if fewer exist, use whatever history is available). Identify: which subject lines drove the highest open rates, which sends underperformed the baseline, and engagement patterns across the week (which day and time performed best, whether shorter or longer subject lines won, any segment that stood out). Produce two or three concrete recommendations for next week's calendar covering subject-line style, send day, and one segment to try.

Slack output. Use Slack Send a Message to post the recap to the marketing channel the user picks during setup. Format the message with a short header (e.g. 'Weekly email recap: <date range>'), a two or three sentence narrative summary, a bulleted list of top performers and underperformers with their open and click rates, and a 'Recommendations for next week' section with the two or three suggestions. Keep it scannable; no raw JSON.

Google Sheets output. Use Google Sheets Append Values to add one row per newsletter to a tracking tab the user picks during setup. Columns, in order: send date, subject line, recipients, opens, open rate, clicks, click rate, unsubscribes, unsubscribe rate. Append after the last existing row so history builds up over time.

Configuration surface the workflow should ask the user for on setup: the Slack channel to post to, the Google Sheet spreadsheet ID and tab name, and the local timezone for the Monday 8am schedule. Everything else can be sensible defaults.

Tone of the write-up: like a helpful marketing analyst, not a data dump. Prose first, numbers in support. No em dashes.

## How to customize

- Change the schedule if Monday morning is not when your team reviews performance, for example move it to Friday afternoon or make it run twice a month.
- Point it at a different Slack channel, a private DM, or add a second channel for leadership.
- Swap the Google Sheet tab, adjust which columns get logged, or add fields like segment name and template used.
- Adjust the baseline the agent compares against, for example your 30 day rolling average versus a fixed open rate target.

## FAQ

### How far back does the recap look?

The default window is the last seven days, so a Monday run covers the previous Monday through Sunday. You can widen or shrink that window when you set up the workflow.

### What does the Slack post actually look like?

A short written summary with the top performing subject lines, sends that came in under your baseline, engagement patterns across the week, and two or three suggestions for the coming week. It reads like a note from a marketing manager, not a raw data dump.

### Will it work if I only send occasional newsletters?

Yes. If no newsletters went out in the window, the agent posts a brief note saying so instead of forcing a report.

### Do I need a paid GetResponse plan?

You need a plan that lets you read newsletter statistics through GetResponse. Most standard marketing plans include this. If your plan does not, the workflow will let you know when it runs.

### Can I add more people to the review, like a manager or an agency?

Yes. Point it at a shared Slack channel, or ask the workflow to also drop a copy into a second channel or DM. The Google Sheet is a natural home for external collaborators who do not use Slack.

Use this prompt in General Input: https://www.generalinput.com/prompts/weekly-getresponse-email-recap-in-slack-and-google-sheets