Weekly SMS Campaign Performance Digest for Slack and Google Sheets

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.

Additional information

What does this prompt do?

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 do I need to use this?

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

Frequently asked questions

Do I need a paid SimpleTexting plan to use this?

You need a SimpleTexting account with API access turned on. API access is approval-only, so if you do not see an API token in your SimpleTexting dashboard, email their support team and ask for it before connecting.

Can the digest cover a different time window than the last seven days?

Yes. The default is the past seven days ending on Monday morning, but you can ask Geni to use a different lookback, for example the past 14 days or the previous calendar week.

Where does the Google Sheets tracker need to live?

Anywhere in a Google Drive you can access. Share the sheet with the Google account you connect, and make sure the header row already has the columns you want filled, since rows are appended in that order.

What anomalies will it flag?

Things like an unusual spike in unsubscribes, a campaign with a noticeably low delivery rate, or a sudden drop in reply rate compared to recent sends. You can tune the thresholds when you set it up.

Can I post the digest to more than one Slack channel?

Yes. Tell Geni which channels you want it copied to, and it will send the same digest to each one.