Run A/B tested email campaigns tracked in Google Sheets

Sends A/B tested email campaigns from Gmail, tracks results in Google Sheets, and reports progress in Slack.

How the work actually flows

A straight line. Runs once per one per contact.

Pattern: Sequence (1) ยท Multiple Instances with a priori Run-Time Knowledge (14)

flowchart TD trig(("campaign started manually or scheduled")):::human s0[("Load contact list")]:::store s1["Split into test groups"]:::task s2[["Send personalized emails"]]:::mi s3[("Log results and report")]:::store trig --> s0 s0 --> s1 s1 -->|"one per one per contact"| s2 s2 --> s3 out[/"completed A/B tested campaign"/]:::out pay{{"data backed messaging insights"}}:::pay s3 --> out out --> pay classDef task fill:#e7f6fe,stroke:#34b8f0,color:#2c2a29 classDef svc fill:#f6f8fa,stroke:#7c8795,color:#2c2a29 classDef mi fill:#e7f6fe,stroke:#0079a8,color:#2c2a29,stroke-width:2px classDef human fill:#fff,stroke:#0079a8,color:#0079a8 classDef store fill:#f6f8fa,stroke:#0079a8,color:#2c2a29 classDef trig fill:#00a4eb,stroke:#0079a8,color:#fff,font-weight:bold classDef trigtime fill:#00a4eb,stroke:#0079a8,color:#fff,font-weight:bold classDef trigdata fill:#8ad4f5,stroke:#0079a8,color:#06314c,font-weight:bold classDef gate fill:#fff,stroke:#e8a23d,color:#6b4708,font-weight:bold classDef out fill:#1f9d6b,stroke:#167a53,color:#fff,font-weight:bold classDef pay fill:#06314c,stroke:#021f33,color:#fff
A stepRuns once per itemA personA record or sheetResultPayoff
Build size
Advanced

A larger build with multiple systems, AI reasoning, and custom rules.

Business functions
Email AutomationMessaging & NotificationsSpreadsheet & Database OpsReporting & Analytics
Connects
GmailGoogle SheetsSlack
Featured in

The problem it solves

Running an email campaign by hand means juggling contact lists, remembering who already got an email, and manually splitting your audience to test different subject lines. Without a system, it's easy to send duplicates, miss unsubscribes, or lose track of what's working.

Who it fits

Best for marketing teams sending newsletters or campaign emails who want to test messaging without extra tools.

How it works

  1. You start the campaign manually or on a set schedule
  2. The system reads your contact list from Google Sheets and checks for duplicates or unsubscribes
  3. Contacts are split automatically into two groups for an A/B test
  4. Personalized emails are sent through Gmail in small batches
  5. Results are logged in Google Sheets and progress is posted to Slack
What you get

Campaigns that show you which message wins

Your email campaigns get split automatically for testing, sent through Gmail in batches, and tracked in Google Sheets with progress posted to Slack.

What you get

A completed email campaign with full send logs and A/B results tracked in Google Sheets.

What you need

A Google Workspace account for Gmail and Sheets, and a Slack workspace.

We can build this. But should you?

The hard question is not how to build it. It is whether this is the right thing to build first.

That is what a Fractional Chief AI Officer figures out with you, before anyone writes a line of code.

Let's Talk Strategy

Related automations

Automatically flag privacy risks and generate compliance reports

AI reviews data usage events for privacy risk, alerts your team, and logs the findings for audits.

Advanced

Classify, route, and track support tickets before SLAs slip

Reads incoming support emails, classifies urgency and routes them, then alerts your team before tickets miss their deadline.

Advanced

Coordinate move-out cleaning and repairs automatically

Before a lease ends, AI builds move-out checklists, notifies vendors and staff, and tracks task completion.

Advanced

Analyze meeting sentiment automatically and track it in Google Sheets

Reads meeting transcripts with AI and logs team sentiment, engagement, and morale risk straight into a spreadsheet.

Advanced
Back to the AI Playbook