Weekly SimpleTexting campaign digest in Slack
Every Monday at 9am ET, get a one-page narrative of last week's SimpleTexting campaigns in Slack, plus a Google Sheets row for trend tracking.
Integrations
SimpleTexting
Slack
Google Sheets
Type
Categories
- Marketing
- Operations
Build an agent workflow that runs every Monday at 9am ET on a cron trigger and produces a weekly SimpleTexting campaign performance digest.
Step 1. Use SimpleTexting List Campaigns with state SENT and a date range covering the past 7 days (Monday through Sunday of the prior week) to get every campaign that went out.
Step 2. For each campaign returned, call SimpleTexting Get Campaign for full metadata and SimpleTexting List Messages to roll up per-campaign totals: messages sent, delivered, delivery rate, replies, and unsubscribes.
Step 3. Have the agent write a one-page narrative digest. It should highlight the top performing campaign and the worst performing campaign for the week, call out anomalies (for example an unusual opt-out spike, a noticeably low delivery rate, or a sharp drop in reply rate versus recent sends), and propose 2 to 3 concrete recommendations for what to send the following week, covering audience, timing, and copy angle.
Step 4. Post the digest into the marketing Slack channel using Slack Send a Message. Format it with clear sections: a short headline summary at the top, a Top performer section, a Worst performer section, an Anomalies section, and a Recommendations for next week section. Keep it scannable.
Step 5. Append one row per campaign to a Google Sheets tracker using Google Sheets Append Values, so week-over-week trends accumulate in a single sheet. The row order must match the existing header row in the tracker (typical columns: week ending date, campaign name, list or segment, messages sent, delivered, delivery rate, replies, reply rate, unsubscribes, unsubscribe rate, notes).
At setup time, ask me for: the Slack channel to post in, the Google Sheets spreadsheet ID and tab name for the tracker, and any anomaly thresholds I want to override (for example flag any campaign whose unsubscribe rate is more than 2x the trailing 4-week average).
If there are no SENT campaigns in the past 7 days, post a short Slack note saying so instead of sending an empty digest, and skip the Google Sheets append.
What it does
- Pulls every SimpleTexting campaign sent in the last seven days and rolls up totals for messages sent, delivery rate, replies, and unsubscribes.
- Writes a clear, sectioned narrative that highlights the top and worst performing campaigns and flags anomalies like an opt-out spike or low delivery rate.
- Proposes two or three concrete suggestions for next week's sends, covering audience, timing, and copy angle.
- Posts the digest into a marketing Slack channel and appends one row per campaign to a Google Sheets tracker so week-over-week trends accumulate in a single place.
What you’ll need
- A SimpleTexting account with API access enabled (request access from SimpleTexting support if you do not see a token in your dashboard).
- A Slack workspace with permission to post in the marketing channel you want the digest to land in.
- A Google account and an existing Google Sheets tracker with header row matching the columns you want to track.
How to customize it
- Change the day and time of the recap, for example shift it to Sunday night so it is ready before Monday morning.
- Swap the Slack channel, or send the digest as a direct message to the marketing lead instead.
- Adjust the lookback window, the anomaly thresholds, or the column order in the Google Sheets tracker to match how your team already reports.
Use cases
- AI Reports
- Daily Digests
- Notifications & Alerts
