Weekly GetResponse email recap in Slack and Google Sheets

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.