Back to Templates
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