Generate Dream 100 prospect lists with Perplexity AI research and Google Sheets
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 20 nodes and runs when a chat message arrives (plus 1 other trigger). Along the way it connects OpenRouter Chat Model, Google Sheets, Slack and Perplexity.
How it runs
Trigger: When a chat message arrives (plus 1 other trigger).
- User Chat Message (Edit Fields (Set)): sets 1 field: User Chat Message
- Send correct message (Switch): routes items into 2 branches
- AI Agent: runs an AI agent, with model: OpenRouter Chat Model; 2 tools (Insert Data Into Sheet, Research via Perplexity); memory: Simple Memory
- Check First Row (Google Sheets): uses Google Sheets
- First Row Name (Edit Fields (Set)): sets 1 field: Prospect 1
- Check Last Row (Google Sheets): uses Google Sheets
- Last Row Name (Edit Fields (Set)): sets 1 field: Prospect 100
- Is there any data in the sheet? (If): checks a condition and branches into true / false
- Collect More Info (Chat): uses Chat
- Do we need MORE data in the sheet? (If): checks a condition and branches into true / false
…plus 4 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.
- Still check Slack Trigger requires a signing secret on the Slack API credential (When Slack Received).
Nodes used (13)
- AI Agent
@n8n/n8n-nodes-langchain.agent - OpenRouter Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenRouter - Chat Trigger
@n8n/n8n-nodes-langchain.chatTrigger - Simple Memory
@n8n/n8n-nodes-langchain.memoryBufferWindow - Edit Fields (Set)
n8n-nodes-base.set - Switch
n8n-nodes-base.switch - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - Chat
@n8n/n8n-nodes-langchain.chat - Slack Trigger
n8n-nodes-base.slackTrigger - Slack
n8n-nodes-base.slack - Perplexity Tool
n8n-nodes-base.perplexityTool - Google Sheets Tool
n8n-nodes-base.googleSheetsTool
From the author
Overview Send an AI a few details about your "Dream Customer" in normal english, then have it search the web and give you a "Dream 100" - 100 ideal prospects to connect with in your industry. Great for stress-testing a product idea or giving you a start for…