Draft personalized cold outreach emails from your lead spreadsheet

Turns your lead list into ready-to-review cold email drafts with subject lines, saved right in Gmail.

How the work actually flows

A straight line. Runs once per each remaining lead.

Pattern: Sequence (1) ยท Multiple Instances with a priori Run-Time Knowledge (14)

flowchart TD trig(("user starts from lead spreadsheet")):::human s0["skip leads already emailed"]:::task s1[["write personalized email"]]:::mi s2["create Gmail draft"]:::task s3[("update sheet status")]:::store trig --> s0 s0 -->|"one per each remaining lead"| s1 s1 --> s2 s2 --> s3 out[/"personalized draft per lead"/]:::out pay{{"tailored outreach without manual drafting"}}:::pay s3 --> 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 sheetResultPayoff
Build size
Advanced

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

Business functions
Lead Generation & ProspectingEmail AutomationSpreadsheet & Database Ops
Connects
Google SheetsGmailOpenAI

The problem it solves

Writing a personalized cold email for every lead on your list takes real time, and copy-paste templates feel generic and get ignored. You want outreach that sounds tailored without spending your whole morning drafting it.

Who it fits

Sales reps or small business owners doing outbound outreach from a lead list.

How it works

  1. You start the process from your lead spreadsheet
  2. The system skips any leads that already have an email sent
  3. AI writes a personalized email body and subject line for each remaining lead
  4. A Gmail draft is created so you can review before sending
  5. The spreadsheet is updated to show which leads have been drafted
What you get

Cold email drafts personalized for every lead

You get a personalized cold email drafted and ready in Gmail for every lead on your list, waiting for your review.

What you get

A Gmail draft with a personalized subject line and message for every lead, ready for you to review and send.

What you need

A Google Workspace account with Gmail and Sheets, plus an OpenAI 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

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

Automatically capture, score, and route new leads from any source

Captures every new lead, uses AI to score and qualify it, then routes it to your CRM or email list and alerts your team.

Advanced

Automatically research leads and send personalized cold emails

Finds verified leads, researches each one with AI, and sends personalized cold emails for you to approve first.

Advanced

Turn new form leads into a personalized email and team task

When someone fills out your form, AI checks if they're new, sends a personal follow-up email, and creates a task for your team.

Advanced
Back to the AI Playbook