Workflow's Purpose and Key Tools: Claude 3.7 Model Specification

LinkedIn Lead Enrichment & Cold-Email Sender with Apify + OpenRouter + Gmail

Most teams spend hours hunting LinkedIn profiles, enriching company data, and writing cold emails manually.
This workflow does it all automatically: lead enrichment, email generation, and sending — directly from a simple Google Sheet.

Benefits
Find verified LinkedIn profiles with Apify scrapers
Enrich company data automatically from LinkedIn
Generate fully personalized cold emails with Claude 3.7 Sonnet (OpenRouter)
Send emails directly through Gmail
Batch-safe with error handling so the workflow never stalls
Log all results and errors back to Google Sheets

How It Works
Add leads (First Name, Last Name, Company, Email) to Google Sheets
Loop through leads in batches to avoid rate limits
Search Google for “{First} {Last} {Company} site:linkedin.com” and keep only profile links
Fetch person details via Apify linkedin-profile-detail (continue even if some fail)
Enrich company data: use current_company_url or search for company page if missing
Fetch LinkedIn company details via Apify linkedin-company-detail
Generate subject + email body with Claude 3.7 Sonnet (validated with structured JSON output)
Send email with Gmail OAuth2 and log status to Google Sheets

Who Is This For
B2B founders doing manual outbound
SDR teams building lead lists
Lead-gen and growth agencies wanting scalable outreach

Setup
Connect Google Sheets (select your leads sheet)
Add Apify token for all scrapers (rag-web-browser, linkedin-profile-detail, linkedin-company-detail)
Enter OpenRouter API key (Claude 3.7 Sonnet or preferred model)
Connect Gmail via OAuth2
Configure sender_name, signature, and domain settings
Set batch size, retries, and rate-limit thresholds

ROI & Monetization
Save 5–8 hours per week on research and copywriting
Offer as a $1k–$3k/month outreach automation for clients
Upsell deliverability monitoring and sequence testing for premium retainers

Strategy Insights
In the full walkthrough, I show how to:
Build this workflow step by step with resilient error handling (alwaysOutputData, continue on error)
Pitch it as a “Done-For-You Personalized Outreach System”
Automate outreach to agencies, consultants, and SaaS teams that need enrichment
Turn this into recurring revenue with retainers

Check Out My Channel

For more advanced AI automation systems that generate real business results, check out my YouTube channel where I share the exact strategies I use to build automation agencies, sell high-value services, and scale to $20k+ monthly revenue.