Send the right follow-up email automatically based on lead status

Leads in Google Sheets get the right follow-up email for their status, sent once and never duplicated.

How the work actually flows

It branches. Exactly one path is taken; runs once per each lead row.

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

flowchart TD trig[\"lead row added or updated"\]:::trigdata s0[["check each lead's status"]]:::mi s1["determine current status"]:::task s2["mark lead as emailed"]:::task trig --> s0 s0 --> s1 gx{"× what is the lead's status"}:::gate s1 --> gx p00["send registration email"]:::task gx -->|"Register stage"| p00 p10["send proposal email"]:::task gx -->|"Proposal stage"| p10 p20["send approval email"]:::task gx -->|"Approved stage"| p20 jn{"○ mark lead emailed"}:::gate p00 --> jn p10 --> jn p20 --> jn jn --> s2 out[/"right follow-up sent once"/]:::out pay{{"no missed or duplicate emails"}}:::pay s2 --> 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 itemOne path onlyPaths rejoinResultPayoff
Build size
Advanced

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

Business functions
Lead Generation & ProspectingEmail AutomationSpreadsheet & Database OpsAPI & Webhook Integration
Connects
Google SheetsGmail
Featured in

The problem it solves

You're tracking leads in a spreadsheet, but remembering to send the right message at the right stage, and only once, is easy to mess up. A missed follow-up or a duplicate email can cost you a deal or make you look disorganized.

Who it fits

Coaches, agencies, and founders using Google Sheets as a simple CRM for lead follow-up.

How it works

  1. New or updated leads in Google Sheets are checked one at a time
  2. The system reads each lead's current status, such as Register, Proposal, or Approved
  3. It sends the matching email for that status
  4. A flag on the row is set so the same lead never gets emailed twice
What you get

Leads followed up at the right stage

You get the right follow-up email sent automatically to every lead based on their current stage, never duplicated or missed.

What you get

A personalized email sent to each lead at the right stage, with the spreadsheet kept accurately updated.

What you need

A Google Workspace account for Sheets and email sending.

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

Turn a lead list into personalized cold emails automatically

Reads leads from a spreadsheet, writes a custom email for each one with AI, and sends it through Gmail.

Standard

Send AI-personalized outreach emails from your contact spreadsheet

Pulls contacts from a spreadsheet, writes a personalized email for each one with AI, and sends it through Gmail.

Standard

Find and reach out to relevant TikTok influencers automatically

Finds TikTok creators by keyword, scores their fit with AI, and emails a personalized pitch to the best matches.

Advanced

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
Back to the AI Playbook