Generate three personalized cold emails from your lead research sheet

Reads company research from Google Sheets and drafts three ready-to-send personalized cold emails for each lead.

How the work actually flows

It branches. Every path runs; runs once per each lead in the sheet.

Pattern: Parallel Split (2) ยท Multiple Instances without Synchronization (12)

flowchart TD trig(("you launch the outreach run")):::human s0[["read lead research per lead"]]:::mi s1["generate three email drafts"]:::task s2[("save drafts for review")]:::store trig --> s0 s0 --> s1 gx{"+ which draft angles to write"}:::gate s1 --> gx p00["write email variant"]:::task gx -->|"draft one"| p00 p10["write email variant"]:::task gx -->|"draft two"| p10 p00 --> s2 p10 --> s2 out[/"three email drafts per lead"/]:::out pay{{"outbound emails ready without manual writing"}}:::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
A stepRuns once per itemA personA record or sheetEvery pathResultPayoff
Build size
Standard

A mid-size build with several tools working together.

Business functions
Spreadsheet & Database Ops
Connects
Google SheetsGoogle Gemini

The problem it solves

You know generic cold emails get ignored, but writing a personalized one for every lead takes forever once you've already spent time researching the company. Doing this by hand for a full list of prospects just doesn't scale.

Who it fits

Sales reps or founders doing outbound outreach who want personalized emails without writing each one by hand.

How it works

  1. You run the automation once company research has been added to Google Sheets
  2. It reads the research for each lead in batches
  3. Google Gemini writes three different personalized email drafts using that research
  4. The drafts are saved back so you can review and send them
What you get

Cold email drafts ready for you to send

You get three personalized cold email drafts written for each lead the moment their research lands in your sheet.

What you get

Three personalized cold email drafts per lead, ready to review and send.

What you need

A Google account with Sheets access and 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

Find matching job listings and draft AI cover letters daily

Searches for jobs matching your skills each morning and writes a tailored cover letter for each one.

Advanced

Extract document data with AI and log it to Google Sheets

It reads uploaded documents, uses AI to pull out the key details, and adds them as structured rows in Google Sheets.

Advanced

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

Turn a Telegram message into a designed resume image

Chats with you on Telegram and turns your resume details into a professionally designed image.

Advanced
Back to the AI Playbook