Turn a list of LinkedIn profiles into personalized email drafts

The system enriches LinkedIn leads with contact data and has AI write five personalized email sections for each one.

How the work actually flows

A straight line. Runs once per each linkedin profile.

Pattern: Multiple Instances without Synchronization (12)

flowchart TD trig(("profile list submitted")):::human s0[["check for known email"]]:::mi s1["enrich profile data"]:::svc s2["generate personalized email copy"]:::svc s3[("save to spreadsheet")]:::store trig --> s0 s0 --> s1 s1 --> s2 s2 --> s3 out[/"spreadsheet of personalized email drafts"/]:::out pay{{"scale 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
Advanced

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

Business functions
Spreadsheet & Database OpsAPI & Webhook Integration
Connects
Google SheetsOpenAI

The problem it solves

Personalizing outreach emails for every lead takes real research time, so most teams end up sending generic messages instead. You want outreach that actually references each prospect, without writing every email by hand.

Who it fits

Sales and outreach teams who want personalized cold emails at scale.

How it works

  1. A list of LinkedIn profile URLs is submitted
  2. The system checks whether each profile has a known email
  3. Profile details are enriched using an external data source
  4. AI writes a personalized subject line, icebreaker, pitch, call to action, and postscript for each lead
  5. The enriched profile and email copy are saved to Google Sheets
What you get

Personalized email drafts ready for outreach

You get a personalized subject line, icebreaker, pitch, and call to action written for every lead on your list.

What you get

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

What you need

A Google Sheets account, an OpenAI API key, and a data enrichment 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

Score and route new leads automatically with AI and Slack alerts

Reads new leads from email or web forms, scores them with AI, updates your CRM, and alerts your team on Slack.

Advanced

Enrich your company list with AI-generated business details

Feeds your spreadsheet of companies through AI to fill in missing details like industry and description automatically.

Advanced

Automatically enrich company records in Google Sheets with AI

Reads a list of companies from Google Sheets and uses AI to fill in missing details automatically.

Advanced

Send personalized birthday messages to employees automatically

Checks your team roster each day and sends a warm, AI-written birthday message to whoever's birthday is next.

Standard
Back to the AI Playbook