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.
Worth a look
- 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
What it does
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 networking in an industry. How it works - Send the AI agent information about your business + ideal customer. It will ask you to clarify any additional info. - The agent will use an LLM to turn your criteria into specific prompts for an internet search - Perplexity will use those prompts to identify ideal customers - An LLM will format those Perplexity results, then they'll be added to a Google sheet. Set up steps 1. Copy the provided google sheets template into your Google Drive 2. Connect your Google Drive/Sheets to the workflow 3. Connect OpenRouter and Perplexity to the workflow (Just paste in your API key!) 4. If desired, connect the Slack trigger/response nodes to control the agent from Slack.