Discover LinkedIn leads and draft outreach using Apify, Google Sheets, and Gemini
Go to Workflow
Dinakar Selvakumar
Description
LinkedIn Lead Discovery & AI Outreach System
This n8n template helps you discover LinkedIn profiles using Google Search, enrich them with public data, and generate personalized outreach messages — all without unsafe browser automation.
What this template demonstrates
Safe LinkedIn lead discovery without direct scraping
Scalable batch processing using Split In Batches
Google Sheets as a lightweight lead database
Responsible AI usage with strict prompt constraints
Clear separation between data collection and messaging
Use cases
B2B lead research for agencies and consultants
Founder-led outbound without expensive SaaS tools
Market research and prospect list building
Personal LinkedIn outreach systems
Pre-sales research workflows
How it works
Role and location keywords are generated automatically
Apify runs Google searches to find LinkedIn profile URLs
Results are stored in Google Sheets
Profiles are enriched one-by-one
AI generates a connection message
A follow-up message is generated after connection
Lead status is updated to avoid duplicates
How to use
Make a copy of the Google Sheet
👉 https://docs.google.com/spreadsheets/d/1UXwFkCGgQKrfOiDgohQLy7WsqUw5TL3unPBgRi4npBQ/copy
Add your Apify API token
Connect your Google Sheets credentials
Review or customise role keywords
Run the workflow in test mode
Monitor results inside Google Sheets
Requirements
n8n (Cloud or Self-hosted)
Apify account (free tier works for testing)
Google Sheets access
Gemini / LLM API key (for messaging)
Customising this workflow
Change target roles or locations in the query generator
Replace Google Sheets with a database if needed
Adjust AI prompts to match your brand tone
Disable follow-up generation if not required
Add rate limits or delays for larger runs
Good to know
This template does NOT send LinkedIn messages automatically
It focuses on research, enrichment, and message drafting
Designed to be compliant, stable, and production-ready
Ideal foundation for custom outreach systems
Who this is for
n8n users building lead generation systems
Freelancers and agencies avoiding expensive SaaS tools
Founders running manual or semi-automated outreach
Anyone who wants control, transparency, and ownership