Run a cold email follow-up sequence from a Google Sheet

Automatically sends the right follow-up email to each lead in your spreadsheet and updates their status.

How the work actually flows

It branches. Exactly one path is taken; runs once per one per lead in sheet.

Pattern: Exclusive Choice (4) · Multiple Instances without Synchronization (12)

flowchart TD trig(["scheduled check of leads"]):::trigtime s0[["determine follow-up stage"]]:::mi s1["send templated email"]:::svc s2[("update lead status")]:::store trig --> s0 s1 --> s2 gx{"× which stage is lead in"}:::gate s0 --> gx p00["send intro follow-up email"]:::task gx -->|"early stage lead"| p00 p10["send closing follow-up email"]:::task gx -->|"later stage lead"| p10 jn{"○ continue to update status"}:::gate p00 --> jn p10 --> jn jn --> s1 out[/"leads receive right follow-up"/]:::out pay{{"consistent outreach without manual tracking"}}:::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 itAn outside serviceRuns 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
CRM & Sales PipelineEmail AutomationSpreadsheet & Database Ops
Connects
GmailGoogle Sheets
Featured in

The problem it solves

You know follow-up is what actually closes deals, but tracking who's at what stage in your outreach and manually sending the next email is tedious. Leads slip through the cracks because nobody remembered to send email three.

Who it fits

Sales reps, founders, or small teams running cold outreach who track leads in a spreadsheet instead of a full CRM.

How it works

  1. On a set schedule, the system checks your Google Sheet of leads
  2. Each lead's current follow-up stage determines which email template gets used
  3. A personalized email is sent from Gmail to that lead
  4. The lead's status in the sheet is updated to the next stage
What you get

Leads who keep hearing from you until they respond

Keep every cold lead moving through the right follow-up message automatically, based on where they are in your outreach sequence.

What you get

Follow-up emails sent automatically to every lead, with the spreadsheet always showing an accurate, up-to-date status.

What you need

A Gmail account and a Google Sheets spreadsheet.

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

Automatically analyze and reply to customer feedback with AI

Reads incoming customer feedback, drafts a personalized reply, and flags anything urgent for your team.

Advanced

Get AI revenue forecasts the moment a new deal hits HubSpot

Whenever a deal is created in HubSpot, AI forecasts best, likely, and worst-case revenue and flags risky deals.

Advanced

Confirm and reschedule meetings automatically after they're booked

Automatically confirms new calendar meetings by email and reschedules them if the client can't make it.

Advanced
Back to the AI Playbook