Send personalized cold outreach emails and track who's been contacted

Leads from a spreadsheet get a personalized email automatically, and the sheet updates so no one is emailed twice.

How the work actually flows

It repeats. Repeats process next batch of leads; runs once per leads in the batch.

Pattern: Multiple Instances with a priori Run-Time Knowledge (14) ยท Structured Loop (21)

flowchart TD trig(["daily schedule"]):::trigtime s0[("read unsent leads from sheet")]:::store s1[["send personalized email"]]:::mi s2[("mark leads as sent")]:::store trig --> s0 s0 -->|"one per leads in the batch"| s1 s1 --> s2 lp{"no unsent leads remain"}:::gate s2 --> lp lp -. "process next batch of leads" .-> s0 lp -->|"finished"| out out[/"daily personalized outreach with tracking"/]:::out pay{{"consistent outreach with no duplicates"}}:::pay 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 itRuns once per itemA record or sheetRepeat or finishResultPayoff
Build size
Standard

A mid-size build with several tools working together.

Business functions
Lead Generation & ProspectingEmail AutomationSpreadsheet & Database OpsScheduling & Calendar
Connects
GmailGoogle Sheets

The problem it solves

You've got a list of leads to reach out to, but sending each email by hand and remembering who you've already contacted takes forever. It's easy to accidentally email the same person twice or miss someone entirely.

Who it fits

A sales or business development person running cold outreach campaigns.

How it works

  1. The system runs on a daily schedule
  2. It reads a spreadsheet for leads that haven't been emailed yet
  3. It sends each lead a personalized email through Gmail
  4. It processes leads in small batches
  5. It marks each row as sent so no lead is contacted twice
What you get

Prospects who reply to your outreach

You get personalized outreach emails sent automatically to every lead on your list, and your sheet always shows who's already been reached.

What you get

Personalized outreach emails sent daily, with an up-to-date record of who's been contacted.

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

Turn WhatsApp into an AI assistant that books calls and captures leads

Answers customer messages on WhatsApp with AI, books appointments, and saves every lead to your records automatically.

Advanced

Send personalized cold emails with automatic AI follow-ups

Researches each prospect's company, writes a tailored cold email with AI, sends it, then follows up automatically until they reply.

Advanced

Automatically capture, classify, and schedule HVAC leads

Classifies incoming HVAC leads with AI, notifies your team, confirms with the customer, and books the appointment.

Advanced

Handle vet clinic bookings and client lookups with an AI assistant

An AI assistant answers client chats, checks if they're new or returning, and books vet appointments automatically.

Advanced
Back to the AI Playbook