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

1. Add leads (First Name, Last Name, Company, Email) to Google Sheets
2. Loop through leads in batches to avoid rate limits
3. Search Google for “{First} {Last} {Company} site:linkedin.com” and keep only profile links
4. Fetch person details via Apify linkedin-profile-detail (continue even if some fail)
5. Enrich company data: use current_company_url or search for company page if missing
6. Fetch LinkedIn company details via Apify linkedin-company-detail
7. Generate subject + email body with Claude 3.7 Sonnet (validated with structured JSON output)
8. 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.