Write personalized cold emails from each lead's website

Reads each lead's website, summarizes their business, and has AI draft a personalized cold email for them.

How the work actually flows

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

Pattern: Multiple Instances without Synchronization (12)

flowchart TD trig(("you start the campaign run")):::human s0[["crawl lead website"]]:::mi s1["summarize business from site"]:::task s2["draft personalized email"]:::svc s3[("write email back to sheet")]:::store trig --> s0 s0 --> s1 s1 --> s2 s2 --> s3 out[/"personalized email drafted per lead"/]:::out pay{{"cold emails that convert better"}}:::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 stepAn outside serviceRuns 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 & RAGEmail AutomationSpreadsheet & Database OpsWeb Scraping & Data Collection
Connects
FirecrawlGoogle GeminiGoogle Sheets

The problem it solves

You know generic cold emails get ignored, but researching every lead's website and writing something personal takes far too long to do at scale. You end up sending the same templated message to everyone and hoping it lands.

Who it fits

A sales or agency team running outbound cold email campaigns.

How it works

  1. The system reads your list of leads from Google Sheets
  2. Each lead's website is crawled and summarized
  3. Gemini uses that summary to draft a personalized outreach email
  4. The finished email is written back into Google Sheets, ready to send
What you get

Cold emails ready to send

Each lead on your list gets a personalized cold email draft written from their own website, ready for your team to review.

What you get

A spreadsheet of leads with a personalized, ready-to-send email drafted for each one.

What you need

A Firecrawl API key, a Google Gemini 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 a website and classify its pages with AI into Sheets

Submit a website and get its pages scraped, analyzed, and sorted into products or categories in Google Sheets.

Advanced

Ask a question and get AI-researched web data in a spreadsheet

Chat with an AI research assistant that searches and scrapes the web, then organizes findings into a spreadsheet.

Advanced

Turn a quick Telegram message into a polished LinkedIn post

Send a message or link on Telegram and get back an AI-drafted LinkedIn post ready for your approval.

Advanced

Build an enriched list of local business leads automatically

Pulls business listings from Google Maps, adds Yelp details, and saves a clean, enriched lead list to a spreadsheet.

Advanced
Back to the AI Playbook