Find new leads and send them personalized cold emails automatically

Pulls fresh leads, checks their websites, and has AI write and send a personalized email to each one.

How the work actually flows

A straight line. Runs once per each lead in the list.

Pattern: Sequence (1) ยท Multiple Instances without Synchronization (12)

flowchart TD trig(("you start a lead search")):::human s0["pull matching leads"]:::task s1["remove duplicate or invalid emails"]:::task s2["look up company website"]:::svc s3[["write personalized email"]]:::mi s4["send email and log lead"]:::svc trig --> s0 s0 --> s1 s1 --> s2 s2 -->|"one per each lead in the list"| s3 s3 --> s4 out[/"personalized emails sent to leads"/]:::out pay{{"scales outreach 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
A stepAn outside serviceRuns once per itemA personResultPayoff
Build size
Advanced

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

Business functions
Email AutomationSpreadsheet & Database Ops
Connects
Apollo.ioApifyGoogle SheetsGmailOpenRouter

The problem it solves

Building a list of prospects and writing a personalized email to each one eats up hours every week. Most teams either send generic blasts that get ignored or fall behind on outreach because personalizing at scale is too slow to do by hand.

Who it fits

Sales teams and small business owners who need a steady stream of personalized cold outreach.

How it works

  1. Pulls a list of leads matching your search criteria
  2. Removes duplicate or invalid email addresses
  3. Looks up each company's website for extra context
  4. Uses AI to write a short, personalized email for each lead
  5. Logs the lead and sends the email through Gmail
What you get

Fresh leads reached with a personal touch

You get a steady stream of new leads found and emailed with a personalized message, all without lifting a finger.

What you get

A growing list of qualified leads in a spreadsheet, each one contacted with a personalized email.

What you need

A Gmail account, a Google Sheets account, an Apify account, 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

Track LinkedIn posts from multiple profiles into Google Sheets

Automatically scrapes new LinkedIn posts from tracked profiles, skips duplicates, and logs them to Sheets.

Advanced

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

Sell and deliver digital products automatically via Telegram chat

A Telegram chatbot answers customers, takes orders, and sends the download link automatically once payment is confirmed.

Advanced

Generate personalized sales emails using each lead's LinkedIn profile

Looks up each lead's LinkedIn and company profile, then uses AI to write and send a personalized outreach email.

Advanced
Back to the AI Playbook