Automated Reddit lead generation with AI analysis 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.
Nodes used (10)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Reddit
n8n-nodes-base.reddit - Filter
n8n-nodes-base.filter - Code
n8n-nodes-base.code - Text Classifier
@n8n/n8n-nodes-langchain.textClassifier
What it does
This workflow contains community nodes that are only compatible with the self-hosted version of n8n. How It Works This n8n workflow automatically discovers high-quality business leads from Reddit posts by analysing posts across targeted subreddits. 1. Loads your business profile from a connected Google Sheet. 2. Uses AI to identify relevant subreddits where your potential customers engage. 3. Generates intent-based Reddit search queries based on your services, keywords, and client pain points. 4. Searches Reddit in real time using the generated queries. 5. Classifies posts based on whether they show lead potential. 6. Analyses high-potential posts for service-fit, urgency, and estimated value. 7. Filters and scores leads to prioritize high-conversion opportunities. 8. Saves the most promising leads to a dedicated Google Sheet. 9. Sends Slack alerts to notify your sales team for immediate follow-up. Requirements Before using this workflow, ensure the following services are connected and configured: 1. Google Sheets (OAuth2): Reads your business profile and writes qualified leads 2. Reddit (OAuth2) Perform Reddit post searches based on generated queries 3. Google Gemini API Analyse posts, generate queries, and extract insights 4. Slack API : Notify your team with qualified lead summaries Google Sheets Setup You will need two Google Sheets: 1. Business Profile Sheet (Input) This sheet contains a single row describing your service business. The workflow reads this to generate relevant subreddit selections and search queries. Required Fields (as headers in row 1): - profession - industry - primaryservices - servicekeywords - targetclientprofile - painpoints - intentsignals - urgencyindicators - pricerange 2. Reddit Leads Sheet (Output) This sheet stores high-quality Reddit posts identified as potential leads. The workflow appends or updates rows based on postid to avoid duplication. Expected Columns: - postid - posturl - posttitle - postpost - postsubreddit - postdate