Run a 3-step email outreach sequence with automatic reply tracking

Sends a scheduled 3-email outreach sequence, stops automatically when someone replies, and logs it in a spreadsheet.

How the work actually flows

It repeats. Repeats no reply yet so follow up sent; runs once per each contact in the list.

Pattern: Multiple Instances without Synchronization (12) ยท Structured Loop (21)

flowchart TD trig(["scheduled outreach run"]):::trigtime s0[["read contact list"]]:::mi s1["send outreach email"]:::task s2["check for reply"]:::task s3["send follow up email"]:::task s4[("update spreadsheet and notify team")]:::store trig --> s0 s0 --> s1 s1 --> s2 s2 --> s3 lp{"reply received or three emails sent"}:::gate s3 --> lp lp -. "no reply yet so follow up sent" .-> s2 lp -->|"finished"| s4 out[/"outreach sequence completed automatically"/]:::out pay{{"consistent follow up without manual 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 sheetRepeat or finishResultPayoff
Build size
Advanced

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

Business functions
Lead Generation & ProspectingEmail AutomationMessaging & NotificationsSpreadsheet & Database Ops
Connects
GmailGoogle SheetsSlack

The problem it solves

Following up with leads takes discipline you don't always have time for, and it's easy to lose track of who you've emailed and who's replied. Manually checking a spreadsheet and sending each follow-up eats into time you could spend selling.

Who it fits

Sales teams and business owners doing outbound email outreach to prospects.

How it works

  1. On a schedule, the system reads your contact list from a spreadsheet
  2. It sends the first outreach email to each new contact
  3. It checks for replies and automatically stops the sequence for anyone who responds
  4. If there's no reply, it sends follow-up emails on schedule
  5. The spreadsheet is updated with each contact's status, and your team is notified along the way
What you get

Prospects who reply instead of going quiet

Your outreach keeps working in the background, sending timely follow-ups and stopping the moment someone responds.

What you get

A running outreach campaign with an up-to-date spreadsheet showing who's been contacted, followed up, and replied.

What you need

A Gmail account, a Google Sheets account, 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

Ten ready-made automations for leads, invoices and alerts

A bundle of ready-to-run automations that handle leads, invoicing reminders, alerts, and reporting for you.

Advanced

Automatically capture, score, and route new leads from any source

Captures every new lead, uses AI to score and qualify it, then routes it to your CRM or email list and alerts your team.

Advanced

Find new real estate agent leads from Google Maps by city

Enter a city and get a deduplicated list of real estate agents saved to Google Sheets, with alerts in Gmail and Slack.

Advanced

Find plastic surgery clinic leads from Google Maps by city

Enter a city and get a deduplicated list of plastic surgery clinics saved to Google Sheets, with alerts in Gmail and Slack.

Advanced
Back to the AI Playbook