Discover LinkedIn leads and draft outreach using Apify, Google Sheets, and Gemini
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 13 nodes and runs from “Generate LinkedIn Search Queries” (no trigger node, so run it manually or call it from another workflow). Along the way it connects Google Sheets and Google Gemini.
How it runs
Trigger: From “Generate LinkedIn Search Queries” (no trigger node, so run it manually or call it from another workflow).
- Generate LinkedIn Search Queries (Code): runs custom JavaScript code
- Load Unenriched Profiles (Google Sheets): uses Google Sheets
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Process Each Profile (Loop Over Items (Split in Batches)): loops over the items in batches
- Search in Apify (HTTP Request): calls an HTTP API
- Scrape LinkedIn Profile Data (HTTP Request): calls an HTTP API
- Flatten Apify Results (Code): runs custom JavaScript code
- Generate Connection Message (Google Gemini): uses Google Gemini
- Save in Database (Google Sheets): uses Google Sheets
- Save Enriched Lead Data (Google Sheets): uses Google Sheets
…plus 3 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (5)
- HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Google Gemini
@n8n/n8n-nodes-langchain.googleGemini
From the author
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…