Send email campaigns with automatic follow-ups and reply tracking

Sends personalized email campaigns with staged follow-ups, then tracks replies and updates your contact list automatically.

How the work actually flows

It branches. Exactly one path is taken; runs once per each contact in the list.

Pattern: Exclusive Choice (4) · Simple Merge (5) · Multiple Instances with a priori Design-Time Knowledge (13)

flowchart TD trig(["every morning schedule"]):::trigtime s0[("check contact list")]:::store s1["determine follow-up stage"]:::task s2[["send stage email"]]:::mi s3[("update contact status")]:::store s4[("log replies to sheet")]:::store trig --> s0 s0 --> s1 s2 --> s3 s3 --> s4 gx{"× which follow-up stage applies"}:::gate s1 --> gx p00["send initial email"]:::task gx -->|"initial outreach"| p00 p10["send follow-up email"]:::task gx -->|"follow-up due"| p10 jn{"○ continue to next contact"}:::gate p00 --> jn p10 --> jn jn --> s2 out[/"always-current contact tracking sheet"/]:::out pay{{"saves hours of manual follow-up tracking"}}:::pay s4 --> 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
Starts itA stepRuns once per itemA record or sheetOne path onlyPaths rejoinResultPayoff
Build size
Advanced

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

Business functions
Email AutomationSpreadsheet & Database Ops
Connects
GmailGoogle Sheets

The problem it solves

Keeping track of who you've emailed, who needs a follow-up, and who has replied eats up your morning. It's easy to lose the thread when you're juggling dozens of contacts in a spreadsheet and an inbox at the same time.

Who it fits

A small business or sales team running outreach campaigns to a list of contacts.

How it works

  1. Every morning, the system checks your contact list in Google Sheets
  2. It figures out which follow-up stage each contact is at
  3. Gmail sends the right email automatically for that stage
  4. The sheet updates with the new status
  5. Any replies are logged back to the sheet so you can see who responded
What you get

Contacts who hear back from you

You keep personalized email campaigns and follow-ups flowing to your contact list, with replies tracked automatically.

What you get

An always-current spreadsheet showing who was emailed, when, and who replied.

What you need

A Google Workspace account for Gmail and Google Sheets.

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

Score and route new leads automatically with AI and Slack alerts

Reads new leads from email or web forms, scores them with AI, updates your CRM, and alerts your team on Slack.

Advanced

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.

Advanced

Read invoices from Gmail and log them to Google Sheets automatically

Pulls invoice attachments out of your inbox, reads the details with AI, and records them in a spreadsheet.

Advanced

Track invoices and automatically chase late payments by email

It logs invoices, emails reminders as they age, and alerts your team on Slack when accounts go to collections.

Advanced
Back to the AI Playbook