Automated lead research – from LinkedIn to ready-to-send report
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 28 nodes and runs manually, when you click “Execute workflow”. Along the way it connects OpenAI Chat Model, Google Sheets and Google Docs.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Get All Data (Google Sheets): uses Google Sheets
- Set Data (Edit Fields (Set)): sets or maps fields
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Company LinkedIn Account POST (HTTP Request): calls an HTTP API
- Perplexity Search (HTTP Request): calls an HTTP API
- Personal LinkedIn Account POST (HTTP Request): calls an HTTP API
- Wait: pauses before continuing
- check perplexity research (Basic LLM Chain): sends a prompt to an LLM, with model: OpenAI Chat Model
- Wait: pauses before continuing
- Company LinkedIn Account GET (HTTP Request): calls an HTTP API
…plus 13 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 (12)
- Manual Trigger
n8n-nodes-base.manualTrigger - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Wait
n8n-nodes-base.wait - Merge
n8n-nodes-base.merge - If
n8n-nodes-base.if - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Google Sheets
n8n-nodes-base.googleSheets - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - Google Docs
n8n-nodes-base.googleDocs
From the author
AI Prospect Researcher – Automated Lead Intelligence Workflow This workflow is built for professionals and teams who want to scale their B2B outreach with context-rich, personalized communication. It automates the full prospect research process — from pulling…