Generate personalized sales emails using each lead's LinkedIn profile

Looks up each lead's LinkedIn and company profile, then uses AI to write and send a personalized outreach email.

How the work actually flows

It branches. Every path runs; all paths must finish before it continues.

Pattern: Parallel Split (2) ยท Synchronisation (3)

flowchart TD trig[\"new lead added to sheet"\]:::trigdata s0["compose personalized email"]:::svc s1["send outreach email"]:::task trig --> s0 gx{"+ gather lead research"}:::gate s0 --> gx p00["fetch linkedin profile"]:::task gx -->|"linkedin lookup"| p00 p10["fetch company profile"]:::task gx -->|"company lookup"| p10 jn{"+ combine research data"}:::gate p00 --> jn p10 --> jn jn --> s1 out[/"personalized email sent to lead"/]:::out pay{{"outreach that converts at scale"}}:::pay s1 --> 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 itA stepAn outside serviceEvery pathWaits for allResultPayoff
Build size
Advanced

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

Business functions
Email AutomationSpreadsheet & Database Ops
Connects
Google SheetsGmailLinkedInApify

The problem it solves

You know personalized outreach converts better, but researching every lead's background and writing a custom email takes too long to do at scale. So your team either sends generic emails or falls behind on follow-up.

Who it fits

Sales teams and founders doing outbound outreach to a list of leads.

How it works

  1. A new lead is pulled from your Google Sheet of prospects
  2. The system looks up the lead's LinkedIn profile and their company's profile
  3. AI writes a personalized email using that context and your value proposition
  4. The email is sent automatically from Gmail
What you get

Replies and meetings booked from personalized outreach

Every lead on your list receives a personalized email crafted from their LinkedIn profile and company details, sent automatically through Gmail.

What you get

A personalized sales email sent to each lead, informed by their real LinkedIn background.

What you need

A Google account for Sheets and Gmail, an Apify account for LinkedIn lookups, and an OpenRouter account for the AI.

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

Scrape LinkedIn leads and approve cold emails from Sheets

Finds LinkedIn leads, drafts personalized cold emails with AI, and only sends after you approve them in Google Sheets.

Advanced

Find your warmest LinkedIn leads by scanning post comments

It reviews who commented on your LinkedIn posts, scores their interest level, and surfaces your best leads.

Advanced

Create SEO content designed to get picked up by AI search

AI writes blog posts, newsletters, landing pages, and social posts built to rank with Google and AI tools like ChatGPT.

Advanced

Find new leads and send them personalized cold emails automatically

Pulls fresh leads, checks their websites, and has AI write and send a personalized email to each one.

Advanced
Back to the AI Playbook