Reddit lead finder: Automated prospecting with GPT-4, Supabase and Gmail alerts
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: AI Agent v1 (old agent modes). 1 breaking item(s) found. Static check, last run 2026-10-19.
What to replace before upgrading
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) Analysis Content By AI (v1.7) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (12)
- Manual Trigger
n8n-nodes-base.manualTrigger - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - AI Agent
@n8n/n8n-nodes-langchain.agent - Reddit
n8n-nodes-base.reddit - If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets - Gmail
n8n-nodes-base.gmail - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Supabase
n8n-nodes-base.supabase - Code
n8n-nodes-base.code - Wait
n8n-nodes-base.wait - Schedule Trigger
n8n-nodes-base.scheduleTrigger
What it does
This workflow monitors targeted subreddits for potential sales leads using Reddit’s API, AI content analysis, Supabase, and Google Sheets. It is built specifically to discover posts from Reddit users who may benefit from a particular product or service. It can be easily customized for any market. --- 🔍 Features - Targeted Subreddit Monitoring: Searches multiple niche subreddits like smallbusiness, startup, sweatystartup, etc., using relevant keywords. - AI-Powered Relevance Scoring: Uses OpenAI GPT to analyze each post and determine if it’s written by someone who might benefit from your product, returning a simple “yes” or “no.” - Duplicate Lead Filtering with Supabase: Ensures you don’t email the same lead more than once by storing already-processed Reddit post IDs in a Supabase table. - Content Filtering: Filters out posts with no body text or no upvotes to ensure only high-quality content is processed. - Lead Storage in Google Sheets: Saves qualified leads into a connected Google Sheet with key data (URL, post content, subreddit, and timestamp). - Email Digest Alerts: Compiles relevant leads and sends a daily digest of matched posts to your team’s inbox for review or outreach. - Manual or Scheduled Trigger: Can be manually triggered or automatically scheduled (via the built-in Schedule Trigger node). --- ⚙️ Tech Stack - Reddit API – For post discovery - OpenAI Chat Model – For AI-based relevance filtering - Supabase – For lead de-duplication - Google Sheets – For storing lead details - Gmail API – For sending email alerts --- 🔧 Customization Tips - Adjust Audience: Modify the subreddits and keywords in the initial Code node to match your market. - Change the AI Prompt: Customize the prompt in the “Analysis Content by AI” node to describe your product or service. - Search Comments Instead: To monitor comments instead of posts, change type=link to type=comment in the Reddit Search node. - Change Email Recipients: Edit the Gmail node to direct leads to a different email address or format.