Research business leads with Perplexity AI & save to Google Sheets using OpenAI
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 manually, when you click “Execute workflow”. Along the way it connects OpenAI Chat Model and Google Sheets.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Set Location (Edit Fields (Set)): sets 1 field: Area
- Get Current Leads (Google Sheets): uses Google Sheets
- Combine Into One (Aggregate): combines items into one
- Set as text (Edit Fields (Set)): sets 2 fields: Search Area, data
- Research Leads (Perplexity): uses Perplexity
- Write JSON (AI Agent): runs an AI agent, with model: OpenAI Chat Model; output parser: Structured Output Parser
- Split Companies (Split Out): splits a list into separate items
- Split Emails (Split Out): splits a list into separate items
- Merge: merges the data from its input branches
- Send Leads to Google Sheets (Google Sheets): append or update
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 (10)
- OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Aggregate
n8n-nodes-base.aggregate - Perplexity
n8n-nodes-base.perplexity - AI Agent
@n8n/n8n-nodes-langchain.agent - Split Out
n8n-nodes-base.splitOut - Merge
n8n-nodes-base.merge
From the author
Automatically research new leads in your target area, structure the results with AI, and append them into Google Sheets — all orchestrated in n8n. --- ✅ What this template does - Uses Perplexity to research businesses (coffee shops in this example) with…