Research each prospect and write a personalized cold email opener

Researches each prospect's company and LinkedIn activity, then writes a custom opening line for your cold email.

How the work actually flows

It branches. Every path runs; all paths must finish before it continues; runs once per each prospect in the list.

Pattern: Parallel Split (2) · Synchronisation (3) · Multiple Instances with a priori Run-Time Knowledge (14)

flowchart TD trig(("prospect list run started")):::human s0[["research company website"]]:::mi s1[["ai writes personalized opener"]]:::mi s2[("write opener back to sheet")]:::store trig --> s0 s1 --> s2 gx{"+ what to research per prospect"}:::gate s0 --> gx p00["read company website"]:::task gx -->|"company research"| p00 p10["review linkedin activity"]:::task gx -->|"linkedin research"| p10 jn{"+ both research done"}:::gate p00 --> jn p10 --> jn jn --> s1 out[/"personalized opener per prospect"/]:::out pay{{"outreach personalized at scale"}}:::pay s2 --> 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 sheetEvery pathWaits for allResultPayoff
Build size
Advanced

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

Business functions
Lead Generation & ProspectingEmail AutomationSpreadsheet & Database OpsHR & Recruiting
Connects
Google SheetsApifyAnthropicLinkedIn

The problem it solves

Generic cold emails get ignored, but manually researching every prospect's company and LinkedIn activity before writing to them takes far more time than most sales or recruiting teams have. That research usually gets skipped, and reply rates suffer for it.

Who it fits

Recruiters, staffing agencies, or sales teams sending outbound cold emails at scale.

How it works

  1. You start the run against a list of prospects in a spreadsheet
  2. The system reads each prospect's company website for recent news and context
  3. It reviews the prospect's LinkedIn activity for relevant details
  4. AI combines both sources to write a one to two sentence personalized opener
  5. The opener is written back into the spreadsheet next to that prospect
What you get

Cold email openers written from real research

You get a personalized cold email opener written for each prospect from their own company news and LinkedIn activity, dropped right into your sheet.

What you get

A spreadsheet of prospects, each with a unique, research-backed opening line ready to drop into an email.

What you need

A Google Sheets account, an Apify account, and an Anthropic or OpenAI 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 job postings as hiring and buying signals

Automatically collects new LinkedIn job postings and turns them into a de-duplicated list of hiring signals.

Standard

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

Automatically scrape, qualify, and verify B2B leads

The system finds new company contacts, has AI decide who's a good fit, verifies their email, and preps them for outreach.

Advanced

Collect LinkedIn profile details into a Google Sheet

Pulls detailed information from a list of LinkedIn profile links and organizes it into a spreadsheet.

Standard
Back to the AI Playbook