Scrape LinkedIn leads with Apify and draft GPT-4.1 Mini Gmail cold emails

Description

This n8n workflow fully automates the outbound lead generation process using LinkedIn, Apify, OpenAI, Google Sheets, and Gmail.

The workflow:

Finds targeted LinkedIn leads automatically
Enriches profiles with verified email addresses
Stores lead data inside Google Sheets
Filters high-quality email addresses
Generates personalized AI cold emails using GPT-4.1 Mini
Creates Gmail drafts ready for manual review and sending

Workflow Architecture

Schedule Trigger
↓
Find LinkedIn Leads (Apify)
↓
Enrich Leads using LinkedIn URL (Apify)
↓
Store Leads in Google Sheets
↓
Filter High-Quality Emails
↓
Generate Personalized AI Cold Emails
↓
Create Gmail Drafts

Explanation

1. Schedule Trigger

This node automatically starts the workflow at a predefined schedule.

Current Configuration

Runs daily at 11:06 AM

Purpose

Fully automates lead generation
Removes manual workflow execution
Keeps your outreach pipeline continuously active

2. Find LinkedIn Leads (Apify)

This node uses the Apify LinkedIn scraping actor to search for targeted LinkedIn profiles.

Current Search Filters

Job Role: CEO
Location: New York
Experience: 5+ years

What It Does

Searches LinkedIn profiles matching the criteria
Extracts LinkedIn profile URLs
Returns targeted prospects for enrichment

3. Enrich Leads using LinkedIn URL

This node enriches every LinkedIn profile using the Apify LinkedIn Profile Scraper.

Extracted Information

First name
Last name
Verified email addresses
Email deliverability score
LinkedIn profile URL
Company website
Company LinkedIn URL
About section
Job headline

4. Store Leads (Google Sheets)

This node appends all enriched lead information into Google Sheets automatically.

Stored Data

First Name
Last Name
Email
Deliverability status
Email quality score
LinkedIn URL
Company website
Job title
About section
Company LinkedIn URL

Benefits

Creates a centralized lead database
Makes lead management easier
Enables campaign tracking and organization

5. Filter High-Quality Emails

This node filters leads based on email quality score.

Current Filter Condition

Email Score >= 70

Purpose

Removes low-confidence emails
Reduces bounce rates
Improves outreach deliverability
Increases campaign effectiveness

Only high-quality leads proceed to the AI outreach stage.

6. Draft Cold Email (OpenAI GPT-4.1 Mini)

This node uses OpenAI GPT-4.1 Mini to generate personalized cold emails.

AI Uses the Following Data

Lead name
Job title
About section
Company LinkedIn profile

Generated Output

Personalized subject line
Curiosity-driven hook
Concise outreach message
HTML-formatted email body

7. Create a Draft (Gmail)

This node automatically creates a Gmail draft using the AI-generated email content.

Included in Draft

Personalized subject line
HTML email body
Recipient email address