Write personalized cold email openers from a prospect's website

Reads each prospect's website and writes a custom opening line for your cold email, ready to send.

How the work actually flows

A straight line. Runs once per each prospect website.

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

flowchart TD trig(("outreach campaign run started")):::human s0[("read prospect list from sheet")]:::store s1[["scrape prospect website"]]:::mi s2[["ai summarizes the business"]]:::mi s3[["ai writes personalized opener"]]:::mi trig --> s0 s0 -->|"one per each prospect website"| s1 s1 --> s2 s2 --> s3 out[/"personalized openers ready in spreadsheet"/]:::out pay{{"saves hours of prospect research"}}:::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
Runs once per itemA personA record or sheetResultPayoff
Build size
Advanced

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

Business functions
Spreadsheet & Database OpsWeb Scraping & Data Collection
Connects
ApifyGoogle SheetsOpenAI

The problem it solves

Writing a genuinely personal opening line for every cold email means visiting each prospect's website and picking out something worth mentioning. That research is what makes outreach feel less like spam, but doing it for a long list one by one takes forever.

Who it fits

Sales teams and agencies running cold email campaigns who want personalized openers at scale.

How it works

  1. The system reads a list of prospect websites from a spreadsheet
  2. It scrapes the homepage and a few internal pages of each site
  3. AI summarizes what each business does
  4. AI writes a personalized opening line based on that summary
  5. The result is saved to your spreadsheet next to the contact's info
What you get

Replies you get because the email felt personal

You get a custom opening line for every prospect based on what their website says about their business.

What you get

A spreadsheet of prospects with a custom, personalized email opener ready for each one.

What you need

An Apify account, a Google Sheets account, and an OpenAI 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

Turn one YouTube video into a full week of social content

Turns a YouTube transcript into social posts, a polished script, and organized files, saved automatically to Drive.

Advanced

Turn Yelp listings into a verified lead list with emails and phones

Pulls business listings from Yelp, finds and verifies owner emails, and sorts qualified leads into Google Sheets.

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

Automatically analyze Instagram posts with AI and log to Sheets

Pulls recent Instagram photos for any account and uses AI to describe what's in each one automatically.

Advanced
Back to the AI Playbook