Automate LinkedIn profile research & email outreach with Apify, Gemini & Sheets
UnknownUnknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 13 nodes and runs on a schedule (every 2 minutes). Along the way it connects Google Sheets, Google Gemini Chat Model and Apify (community).
How it runs
Trigger: On a schedule (every 2 minutes).
- Get row(s) in sheet (Google Sheets): uses Google Sheets
- Check Profiles with no Data (If): checks a condition and branches into true / false
- Limit: keeps the first few items
- Runs Profile Extraction Actor (Apify): uses Apify
- Get dataset items (Apify): work with datasets
- Append or update row in sheet (Google Sheets): append or update
- Get row(s) in sheet (Google Sheets): uses Google Sheets
- Check Profiles with No Email Drafts (If): checks a condition and branches into true / false
- Hyper Personalised Email Generator (Basic LLM Chain): sends a prompt to an LLM, with model: Google Gemini Chat Model; output parser: Structured Output Parser
- Final Output (Google Sheets): append or update
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that @apify/n8n-nodes-apify is verified or supports 3.0 (used in Get dataset items, Runs Profile Extraction Actor).
Nodes used (8)
- Google Sheets
n8n-nodes-base.googleSheets - Limit
n8n-nodes-base.limit - Apify
@apify/n8n-nodes-apify.apify - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Schedule Trigger
n8n-nodes-base.scheduleTrigger - If
n8n-nodes-base.if - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm
From the author
This n8n template from Intuz provides a complete and automated solution for deep-dive lead research and hyper-personalized email generation. It transforms a basic list of LinkedIn profiles into a campaign-ready database by first enriching contacts with…