Reddit to Google Sheets, qualified leads logged fast
You find a perfect “I need help with X” post on Reddit… and then it disappears into the scroll. Later, you can’t find it, nobody logged it, and your follow-up happens days too late (if it happens at all).
This hits marketing teams and sales-first founders hard. It also sneaks up on consultants running lean. Reddit leads automation fixes the messy middle: finding the right posts, qualifying them, and getting them into a sheet your team actually works from.
This workflow discovers high-intent Reddit posts, scores them with AI, writes the best ones into Google Sheets, and alerts your team in Slack so the next step is obvious.
How This Automation Works
The full n8n workflow, from trigger to final output:
n8n Workflow Template: Reddit to Google Sheets, qualified leads logged fast
flowchart LR
subgraph sg0["Schedule Flow"]
direction LR
n0@{ icon: "mdi:play-circle", form: "rounded", label: "Schedule Trigger", pos: "b", h: 48 }
n1@{ icon: "mdi:database", form: "rounded", label: "Get Enhanced Business Profile", pos: "b", h: 48 }
n2@{ icon: "mdi:brain", form: "rounded", label: "Google Gemini Chat Model", pos: "b", h: 48 }
n3@{ icon: "mdi:robot", form: "rounded", label: "Subreddit Output Parser", pos: "b", h: 48 }
n4@{ icon: "mdi:robot", form: "rounded", label: "Strategic Subreddit Selector", pos: "b", h: 48 }
n5@{ icon: "mdi:brain", form: "rounded", label: "Query Generator Model", pos: "b", h: 48 }
n6@{ icon: "mdi:robot", form: "rounded", label: "Multi-Query Output Parser", pos: "b", h: 48 }
n7@{ icon: "mdi:robot", form: "rounded", label: "Multi-Query Generator", pos: "b", h: 48 }
n8@{ icon: "mdi:swap-vertical", form: "rounded", label: "Split Query Batches", pos: "b", h: 48 }
n9["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/reddit.svg' width='40' height='40' /></div><br/>Reddit Search Engine"]
n10@{ icon: "mdi:brain", form: "rounded", label: "Lead Classifier Model", pos: "b", h: 48 }
n11@{ icon: "mdi:brain", form: "rounded", label: "Service Opportunity Model", pos: "b", h: 48 }
n12@{ icon: "mdi:robot", form: "rounded", label: "Service Analysis Parser", pos: "b", h: 48 }
n13@{ icon: "mdi:robot", form: "rounded", label: "Service Opportunity Analyzer", pos: "b", h: 48 }
n14@{ icon: "mdi:swap-horizontal", form: "rounded", label: "High Value Filter", pos: "b", h: 48 }
n15@{ icon: "mdi:database", form: "rounded", label: "Save High-Value Leads", pos: "b", h: 48 }
n16["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Code"]
n17@{ icon: "mdi:swap-vertical", form: "rounded", label: "Loop Over Items", pos: "b", h: 48 }
n18@{ icon: "mdi:robot", form: "rounded", label: "AI Lead Classifier", pos: "b", h: 48 }
n16 --> n8
n17 --> n13
n0 --> n1
n14 --> n15
n18 --> n17
n8 --> n18
n8 --> n9
n9 --> n8
n10 -.-> n18
n7 --> n16
n5 -.-> n7
n15 --> n17
n12 -.-> n13
n3 -.-> n4
n2 -.-> n4
n6 -.-> n7
n11 -.-> n13
n13 --> n14
n4 --> n7
n1 --> n4
end
%% Styling
classDef trigger fill:#e8f5e9,stroke:#388e3c,stroke-width:2px
classDef ai fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
classDef aiModel fill:#e8eaf6,stroke:#3f51b5,stroke-width:2px
classDef decision fill:#fff8e1,stroke:#f9a825,stroke-width:2px
classDef database fill:#fce4ec,stroke:#c2185b,stroke-width:2px
classDef api fill:#fff3e0,stroke:#e65100,stroke-width:2px
classDef code fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
classDef disabled stroke-dasharray: 5 5,opacity: 0.5
class n0 trigger
class n3,n4,n6,n7,n12,n13,n18 ai
class n2,n5,n10,n11 aiModel
class n14 decision
class n1,n15 database
class n16 code
classDef customIcon fill:none,stroke:none
class n9,n16 customIcon
The Problem: Reddit Leads Fall Through the Cracks
Reddit is full of people describing problems in plain English, which is exactly what you want for lead generation. The issue is speed and consistency. You might check a few subreddits, run a couple searches, open ten tabs, and still end up with “maybe” leads mixed with noise. Then the admin work starts: copy the URL, grab the title, paste the text, add a note, guess urgency, and tell someone on your team to follow up. It’s exhausting, and frankly it’s easy to abandon after a week.
The friction compounds. Here’s where it breaks down.
- You waste about an hour per session collecting posts, then realize half were the wrong fit.
- Good prospects get missed because your searches don’t match how people describe the problem.
- Leads aren’t de-duplicated, so the same post gets logged twice and trust in the list drops.
- Follow-up is slow because notifications live in someone’s head instead of in Slack.
The Solution: AI-Qualified Reddit Leads Sent to Sheets + Slack
This n8n workflow turns Reddit into a steady stream of qualified opportunities without you babysitting it. It starts on a schedule, pulls your business profile from a Google Sheet, and uses AI to figure out where your buyers hang out and how they talk about their pain. From there, it generates intent-based Reddit searches, runs them in real time, and classifies posts for lead potential. High-potential posts get analyzed again for service fit, urgency, and estimated value, then scored and filtered so only the best ones make it through. The final step writes the winners into your “Reddit Leads” Google Sheet and sends a Slack alert so someone can respond while the thread is still active.
The workflow begins with your one-row business profile (profession, services, pain points, intent signals). AI turns that into a subreddit plan and a set of search queries, then Reddit results get scored and routed. Your output is a clean, prioritized lead sheet plus Slack notifications that prompt timely follow-up.
What You Get: Automation vs. Results
| What This Workflow Automates | Results You’ll Get |
|---|---|
|
|
Example: What This Looks Like
Say you try to find prospects in 6 subreddits and run 10 searches each week. Manually, you might spend about 5 minutes per search skimming, opening posts, and copying details, which is roughly 5 hours before you even decide who’s worth contacting. With this workflow, the scheduled run kicks off automatically, the AI generates the searches, and results are scored and logged to Google Sheets. You mostly just read the Slack alerts and check the top rows, so the same weekly effort becomes closer to 20 minutes.
What You’ll Need
- n8n instance (try n8n Cloud free)
- Self-hosting option if you prefer (Hostinger works well)
- Google Sheets to store your profile and leads
- Reddit to search posts via OAuth
- Slack to alert your team instantly
- Google Gemini API key (get it from Google AI Studio)
Skill level: Intermediate. You’ll connect accounts, map a few fields, and paste in one API key.
Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).
How It Works
A timed schedule kicks it off. The workflow runs on a cadence you set (daily, a few times a day, or whatever matches your sales motion). No one has to “remember to check Reddit.”
Your business profile is pulled from Google Sheets. That single row (profession, services, pain points, intent signals, urgency indicators, price range) becomes the brief that guides everything that follows.
AI generates where to look and what to search. Google Gemini plans target subreddits, then produces search queries that match buyer language. The workflow transforms those outputs, splits them into batches, and runs Reddit searches without hammering the API.
Posts are scored, filtered, and stored. Another AI pass evaluates fit, urgency, and potential value, then a “high value” filter gates what gets written to your leads sheet. From there, Slack notifications go out so someone can act.
You can easily modify the subreddits and scoring thresholds to match your niche and deal size. See the full implementation guide below for customization options.
Step-by-Step Implementation Guide
Step 1: Configure the Schedule Trigger
Set the workflow to run automatically on a fixed interval using the existing schedule trigger.
- Open Timed Schedule Starter and confirm the schedule rule uses an hourly interval.
- Set Field to
hoursand Hours Interval to2. - Save the node to ensure the trigger starts the workflow every 2 hours.
Step 2: Connect Google Sheets
Pull your business profile from Google Sheets and prepare a destination sheet for prioritized leads.
- Open Fetch Business Profile and set Document to
[YOUR_ID]and Sheet togid=0(Sheet1). - Credential Required: Connect your googleSheetsOAuth2Api credentials in Fetch Business Profile.
- Open Store Priority Leads and confirm Operation is set to
appendOrUpdate. - In Store Priority Leads, map the columns with expressions such as
={{ $('Iterate Lead Posts').item.json.id}}and={{ $json.output.toJsonString() }}. - Credential Required: Connect your googleSheetsOAuth2Api credentials in Store Priority Leads.
⚠️ Common Pitfall: The field target_client_profile includes a trailing space in several expressions. Ensure your Google Sheet header matches this exactly or update the expressions.
Step 3: Set Up Subreddit Planning and Query Generation
Use AI to identify relevant subreddits and generate targeted search queries based on your business profile.
- Open Gemini Chat Engine and set Model Name to
models/gemini-2.0-flash-001. - Credential Required: Connect your googlePalmApi credentials in Gemini Chat Engine.
- Open Target Subreddit Planner and keep the Text prompt as-is, including expressions like
{{ $json.profession }}and{{ $json.pain_points }}. - Confirm Subreddit Result Parser is attached as the output parser for Target Subreddit Planner. (No credentials here—use the parent model in Gemini Chat Engine.)
- Open Query Model Driver and set Model Name to
models/gemini-2.0-flash. - Credential Required: Connect your googlePalmApi credentials in Query Model Driver.
- Open Search Query Builder and keep the prompt text with expressions like
{{ $('Fetch Business Profile').item.json.profession }}and{{ $json.output.subreddits }}. - Confirm Query Output Parser is attached to Search Query Builder as the output parser (credentials belong to Query Model Driver).
Step 4: Transform and Batch Queries for Reddit Search
Normalize the generated queries, batch them, and run Reddit searches for each query.
- Open Transform Outputs and confirm Language is
pythonwith the code that assignsitem.json.outputs=item.json.output. - Open Batch Query Splitter and keep Reset set to
falseto iterate through all queries. - Open Reddit Search Request and set Operation to
search, Location toallReddit, and Limit to10. - Set Keyword to the expression
={{ $json.query }}. - Credential Required: Connect your redditOAuth2Api credentials in Reddit Search Request.
Step 5: Categorize and Score Leads with AI
Classify Reddit posts and generate opportunity assessments with structured AI output.
- Open Lead Scoring Model and set Model Name to
models/gemini-2.0-flash. - Credential Required: Connect your googlePalmApi credentials in Lead Scoring Model.
- Open AI Lead Categorizer and keep the Input Text template with expressions like
{{ $json.title || 'N/A' }}and{{ $json.subreddit_name_prefixed }}. - Confirm Lead Scoring Model is connected as the language model for AI Lead Categorizer; add credentials on Lead Scoring Model, not the classifier.
- Open Service Opportunity LLM and set Model Name to
models/gemini-2.0-flash. - Credential Required: Connect your googlePalmApi credentials in Service Opportunity LLM.
- Open Opportunity Assessment and keep the prompt text that references Reddit fields and business profile values such as
{{ $json.title }}and{{ $('Fetch Business Profile').item.json.price_range }}. - Confirm Service Insight Parser is attached as the output parser for Opportunity Assessment (credentials are on Service Opportunity LLM).
Tip: The workflow loops between AI Lead Categorizer → Iterate Lead Posts → Opportunity Assessment to process each post individually.
Step 6: Filter High-Value Leads and Store Results
Apply a score threshold and write the qualified leads to Google Sheets.
- Open High Value Gate and set the condition to Lead Score greater than or equal to
6using={{ $json.output.lead_score }}. - Confirm Store Priority Leads receives data only from High Value Gate.
- Review column mappings in Store Priority Leads to ensure each field is mapped to the correct expression values.
Step 7: Test and Activate Your Workflow
Run a manual test to validate each stage, then activate the workflow for production use.
- Click Execute Workflow and verify Fetch Business Profile returns your business profile row.
- Check that Search Query Builder outputs multiple queries and Reddit Search Request returns posts.
- Confirm Opportunity Assessment produces structured output and High Value Gate filters by score.
- Verify a new row is appended or updated in Store Priority Leads with the post and service suggestion.
- Switch the workflow to Active to run it every 2 hours in production.
Common Gotchas
- Google Sheets credentials can expire or need specific permissions. If things break, check the Google connection in n8n’s Credentials and confirm the sheet is shared with the right Google account first.
- If you’re using Wait nodes or external rendering, processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
- Reddit OAuth can fail when your app permissions are too limited. Re-check your Reddit app settings, then re-authorize the Reddit credential inside n8n.
Frequently Asked Questions
About an hour if your Sheets, Reddit, and Slack accounts are ready.
No. You’ll mostly connect accounts and map Google Sheets columns. The only “technical” part is pasting your Gemini API key into n8n.
Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in Google Gemini API usage costs.
Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.
Yes, and you’ll feel the impact immediately. Update the “Business Profile Sheet” row (especially pain_points, intent_signals, urgency_indicators, and price_range), then adjust the High Value Gate filter so it matches what a “qualified” lead means for you. If you want different search behavior, tweak the AI prompts in the Gemini chat nodes that generate subreddits and queries, then re-run a few test cycles. Common customizations include adding negative keywords, narrowing to a smaller set of subreddits, and changing the scoring so “urgent help” posts rise to the top.
Usually it’s an expired OAuth authorization or a Reddit app permission issue. Reconnect the Reddit credential in n8n, then confirm your Reddit app is still active and allowed to perform searches. If it fails only on larger runs, you might be hitting rate limits, so reduce batch size in the Split in Batches step.
A lot, as long as you batch it sensibly.
For Reddit lead hunting plus AI scoring, n8n is usually the better fit. You can run multi-step logic with branching, batching, and filters without your costs jumping every time you add one more decision. Self-hosting is a big deal too, especially if you plan to run searches frequently. Zapier and Make are still great for simple “when X then Y” flows, but this use case tends to get complex fast. Talk to an automation expert if you want help choosing.
Once this is running, Reddit stops being “something you should check” and becomes a repeatable lead channel. The workflow handles the sorting and logging, so your team can focus on the part that actually wins deals.
Need Help Setting This Up?
Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.
