Find LinkedIn leads and draft personalized outreach messages

Searches for LinkedIn profiles matching your target roles and drafts a personalized message for each one.

How the work actually flows

A straight line. Runs once per one per lead profile found.

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

flowchart TD trig(("target roles defined")):::human s0["search matching profiles"]:::svc s1[("log profile to sheet")]:::store s2[["draft personalized message"]]:::mi s3[("update sheet to prevent duplicates")]:::store trig --> s0 s0 --> s1 s1 -->|"one per one per lead profile found"| s2 s2 --> s3 out[/"lead list with drafted messages"/]:::out pay{{"scalable personalized outreach"}}:::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
An outside serviceRuns once per itemA personA record or sheetResultPayoff
Build size
Standard

A mid-size build with several tools working together.

Business functions
Lead Generation & ProspectingSpreadsheet & Database Ops
Connects
Google SheetsGoogle GeminiApify

The problem it solves

Building a list of leads on LinkedIn and writing a personal note to each one takes hours you would rather spend selling. Generic mass messages get ignored, but writing individually researched notes for every prospect does not scale.

Who it fits

Agencies, consultants, and founders doing B2B outreach who need a steady list of qualified leads.

How it works

  1. You define the target roles and locations you want to reach
  2. The system searches for matching LinkedIn profiles
  3. Each profile is logged into a spreadsheet
  4. AI drafts a personalized connection message for each lead
  5. The spreadsheet is updated so no lead is contacted twice
What you get

Personalized outreach messages drafted per lead

You get a list of matching LinkedIn profiles along with a personalized connection message drafted for each one, ready for you to send.

What you get

A spreadsheet of leads with a personalized outreach message drafted for each one.

What you need

A web search and scraping API account, a Google account, and a Gemini 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

Back to the AI Playbook