Generate personalized cold outreach emails from lead data

The system scrapes lead and company data, then AI writes a personalized email opener, intro, and pitch for each one.

How the work actually flows

A straight line. Runs once per each lead's company.

Pattern: Multiple Instances with a priori Run-Time Knowledge (14)

flowchart TD trig(("user requests outreach batch")):::human s0["pull batch of leads"]:::task s1[["scrape company website"]]:::mi s2[["AI writes email opener and pitch"]]:::mi s3[("save to leads spreadsheet")]:::store trig --> s0 s0 -->|"one per each lead's company"| s1 s1 --> s2 s2 --> s3 out[/"personalized outreach content per lead"/]:::out pay{{"personalized outreach at scale without manual digging"}}:::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
Knowledge Base & RAGLead Generation & ProspectingEmail AutomationSpreadsheet & Database Ops
Connects
ApifyOpenAIGoogle Sheets

The problem it solves

Writing a truly personalized cold email for every prospect takes real research time you don't have when you're trying to reach dozens or hundreds of leads. Generic templates get ignored, but customizing each one by hand doesn't scale. You want outreach that feels personal without doing all the digging yourself.

Who it fits

Best for sales teams, marketers, and business development professionals scaling outreach.

How it works

  1. The system pulls a batch of leads with their contact and company details
  2. It scrapes each lead's company website for relevant content
  3. AI summarizes the findings and identifies a unique angle for outreach
  4. AI writes a personalized icebreaker, intro, and value proposition
  5. These are saved back into your leads spreadsheet
What you get

Outreach emails that read like you wrote them

Every lead gets a personalized opener, intro, and pitch written from their own company details.

What you get

A personalized icebreaker, intro, and value proposition for each lead, saved to your spreadsheet.

What you need

An Apify account, an OpenAI API key, and a Google Sheets account.

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

Analyze competitor Facebook ads with AI and log to Google Sheets

Scrapes top-performing competitor Facebook ads, has AI summarize and rewrite the copy, and saves it all to a spreadsheet.

Advanced

Find LinkedIn leads and send personalized requests automatically

Describe your ideal customer in plain English and the system finds LinkedIn leads and reaches out with a personalized message.

Standard

Find newly funded companies and draft personalized outreach emails

Scrapes recently funded companies, finds the right contacts, and has AI draft a personalized outreach email for each one.

Advanced

Turn Google Maps business listings into ready-to-use lead lists

The system scrapes local business listings from Google Maps and uses AI to write a clean summary for each one in a spreadsheet.

Advanced
Back to the AI Playbook