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.

How the work actually flows

A straight line.

Pattern: Sequence (1)

flowchart TD trig(["scheduled outreach check"]):::trigtime s0[("find next uncontacted lead")]:::store s1["read lead details"]:::task s2["write personalized email with AI"]:::svc s3["send email via Gmail"]:::task s4[("mark lead as contacted")]:::store trig --> s0 s0 --> s1 s1 --> s2 s2 --> s3 s3 --> s4 out[/"personalized cold email sent"/]:::out pay{{"personal outreach at scale without manual writing"}}:::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 stepAn outside serviceA record or sheetResultPayoff
Build size
Standard

A mid-size build with several tools working together.

Business functions
AI Agents & Autonomous SystemsLead Generation & ProspectingEmail AutomationSpreadsheet & Database OpsReal Estate & Property
Connects
Google SheetsGmailGoogle Gemini

The problem it solves

Writing a personal-sounding email to every new lead takes forever, so outreach either stalls or turns into generic copy-paste blasts that get ignored. You end up choosing between speed and personalization, and prospects can tell the difference.

Who it fits

Sales teams, agencies, or business owners running cold outreach to a lead list.

How it works

  1. On a set schedule, the system checks your spreadsheet for the next lead who hasn't been contacted
  2. Google Gemini reads that lead's name, business, website, and notes
  3. It writes a short, personalized subject line and email body
  4. Gmail sends the email directly to the lead's address
  5. The spreadsheet is updated so that lead won't be emailed twice
What you get

Personalized outreach emails sent while you focus elsewhere

You get a personalized cold email written and sent to each new lead on your list automatically, with your spreadsheet updated so nobody is emailed twice.

What you get

A personalized cold email sent to each lead and an updated spreadsheet showing who's been contacted.

What you need

A Google account with Sheets and Gmail, plus a Google Gemini API key.

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

Score and route new leads automatically with AI

New leads from your form are scored by AI, and the hot ones get sent straight to your sales team in Slack.

Advanced

Find LinkedIn leads and send personalized outreach emails

Searches for LinkedIn profiles matching a role and location, then sends each lead a personalized AI-written email.

Advanced

Send AI-personalized cold emails to leads from a spreadsheet

Reads each lead's website, writes a tailored email, sends it through Gmail, and marks the lead as contacted.

Advanced
Back to the AI Playbook