Discover, enrich, and email LinkedIn leads with Apify, Gmail, Gemini, and Sheets

Automate LinkedIn lead discovery, enrichment, and email follow-ups using Apify and Google Sheets

What this template demonstrates

• End-to-end lead pipeline (discovery → enrichment → outreach)
• Google Search–based LinkedIn discovery (safe approach)
• Batch processing with controlled loops
• AI-generated cold emails and follow-ups
• Google Sheets as a structured lead database

Use cases

• B2B outbound lead generation
• Recruitment sourcing workflows
• Founder-led sales outreach
• Building verified prospect lists
• Automated follow-up systems

How it works

• Reads role + location inputs from Google Sheets
• Uses Apify to find LinkedIn profiles via Google Search
• Stores raw leads and filters valid profiles
• Enriches profiles with additional data
• Generates personalized email sequences using AI
• Sends emails and tracks responses
• Updates lead status to prevent duplicates

How to use

• Add {{APIFY_API_TOKEN}}
• Connect Google Sheets and Gmail
• Prepare input sheet (Keyword, Location)
• Run workflow in test mode
• Verify outputs in Google Sheets
• Activate workflow

Requirements

• n8n (cloud or self-hosted)
• Apify account
• Google Sheets
• Gemini / LLM API key

Good to know

• No direct LinkedIn automation (safe and compliant)
• Email follow-ups include response tracking
• Uses batching to handle large datasets
• Google Sheets acts as the system state

Customising this workflow

• Change target roles and locations
• Improve AI prompts for personalization
• Add email verification tools
• Replace Sheets with a database
• Add retry logic and rate limits

What this template demonstrates

• Multi-step automation architecture
• API orchestration using HTTP nodes
• AI integration in workflows
• Conditional logic and batching
• Scalable lead processing design