Draft personalized cold outreach emails automatically for each prospect

Researches each prospect company online, then drafts a tailored cold email ready to review and send.

How the work actually flows

It repeats. Repeats more ready companies remain.

Pattern: Structured Loop (21)

flowchart TD trig[\"company marked ready for outreach"\]:::trigdata s0["research company online"]:::svc s1["AI drafts personalized email"]:::svc s2[("write email back to sheet")]:::store trig --> s0 s0 --> s1 s1 --> s2 lp{"ready list exhausted"}:::gate s2 --> lp lp -. "more ready companies remain" .-> s0 lp -->|"finished"| out out[/"personalized email draft ready"/]:::out pay{{"tailored outreach without hours of research"}}:::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 itAn outside serviceA record or sheetRepeat or finishResultPayoff
Build size
Advanced

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

Business functions
AI Agents & Autonomous SystemsLead Generation & ProspectingEmail AutomationSpreadsheet & Database Ops
Connects
Google SheetsTavilyOpenRouter

The problem it solves

Writing a genuinely personalized cold email for every prospect takes real research time, so most outreach ends up generic and gets ignored. You either spend hours per email or send the same template to everyone.

Who it fits

Sales and business development teams doing B2B outreach to a list of target companies.

How it works

  1. Pulls the next company marked ready for outreach from your spreadsheet
  2. Researches the company online to find its offerings, focus, and recent news
  3. AI drafts a personalized email using that research
  4. The finished email is written back into your spreadsheet
  5. Optionally, the lead and message are sent to your outreach tool for sending
What you get

Outreach drafts personalized per prospect

You get a tailored cold email drafted for each prospect, researched and written around their company so your team's first message lands well.

What you get

A ready-to-send, personalized email draft for each prospect on your list.

What you need

A Google Sheets account, a Tavily API key, and an OpenRouter 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

Generate a full research report from a single topic using AI

You type in a topic and get back a full, sourced research report saved straight to Google Sheets.

Advanced

Research prospects and draft personalized outreach automatically

Looks up each sales prospect's company details, matches your products to their needs, and drafts a personalized follow-up.

Advanced

Turn real customer complaints from Reddit into LinkedIn posts

Finds real business problems people post about on Reddit and turns them into LinkedIn content that shows you understand the problem.

Advanced

Find and message solo lawyers for outreach automatically

Finds solo lawyers on LinkedIn through search, researches each one, and drafts a personalized message for outreach.

Advanced
Back to the AI Playbook