Enrich LinkedIn prospects and auto-write personalized opening lines

Pulls fresh LinkedIn profile details for your prospect list and has AI draft a personalized opening line for each one.

How the work actually flows

A straight line. Runs once per one per linkedin profile.

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

flowchart TD trig[\"new profile links added to sheet"\]:::trigdata s0[["pull profile details"]]:::mi s1[("update spreadsheet")]:::store s2["draft opening line"]:::svc s3[("deliver ready spreadsheet")]:::store trig --> s0 s0 --> s1 s1 --> s2 s2 --> s3 out[/"personalized opening lines for each prospect"/]:::out pay{{"faster personalized outreach without manual 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
Starts itAn outside serviceRuns once per itemA record or sheetResultPayoff
Build size
Advanced

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

Business functions
Lead Generation & ProspectingSpreadsheet & Database Ops
Connects
Google SheetsClaude

The problem it solves

Personalizing outreach for every prospect takes real research time, so most people either skip it or send generic messages that get ignored. You want messages that sound like you actually looked at someone's profile, without spending an hour per lead.

Who it fits

Sales development reps, growth marketers, or founders doing outbound prospecting at scale.

How it works

  1. You add a list of LinkedIn profile links to a spreadsheet
  2. The system pulls up-to-date profile details for each person
  3. Your spreadsheet is updated with their name, company, and recent activity
  4. AI reads their recent posts and drafts a short, relevant opening line
  5. You receive a spreadsheet ready for personalized outreach
What you get

Opening lines ready to personalize and send

Your prospect list comes back updated with fresh LinkedIn details and a personalized opening line drafted for every contact.

What you get

A spreadsheet of enriched prospect profiles, each with a ready-to-use personalized opening line.

What you need

A Google Sheets account, a data enrichment subscription, and an Anthropic 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