🔓 Unlock all 10,000+ workflows & prompts free Join Newsletter →
✅ Full access unlocked — explore all 10,000 AI workflow and prompt templates Browse Templates →
Home › n8n › Workflow
January 22, 2026

Reddit to Google Sheets, leads captured and cleaned

Reddit to Google Sheets, leads captured and cleaned - n8n workflow automation template
Lisa Granqvist Partner Workflow Automation Expert
Reddit to Google Sheets, leads captured and cleaned - n8n workflow automation template
Get a free AI assessment → Get a free AI assessment → ⬇️ Use template

You find a perfect Reddit thread, open it “for later,” and then it’s gone under 200 new posts. Or you do copy-paste into a spreadsheet, but the formatting is a mess and you never capture the context that makes the lead actually usable.

Reddit lead capture hits marketers doing outbound research hard. A founder trying to land early customers feels it too. Same for a freelancer hunting gigs without living on Reddit all day.

This n8n workflow pulls fresh posts from your chosen subreddits every 2 hours, filters for real opportunities, grabs the top-level comments (minus mod noise), then appends clean rows into Google Sheets. You’ll see exactly what it automates, what you get back, and what to watch out for.

How This Automation Works

The full n8n workflow, from trigger to final output:

n8n Workflow Template: Reddit to Google Sheets, leads captured and cleaned

The Problem: Reddit leads slip through the cracks

Reddit is great for finding people who are actively asking for help, hiring, or looking for recommendations. It’s also chaotic. Threads move fast, and the “real” lead is often hidden in the first few comments, not the post itself. Manually tracking all of that turns into a daily scavenger hunt: open five tabs, skim, copy text, clean it, paste it, find the URL again, then try to remember why it mattered. Miss a couple hours and you miss the moment.

It adds up fast. Here’s where it breaks down in real life.

  • You end up checking the same subreddits repeatedly because there’s no reliable “latest leads” list.
  • Copy-pasting comments destroys formatting, and later you can’t tell what was a quote vs. the actual request.
  • Moderator replies and auto-messages fill your notes, so the spreadsheet grows while lead quality drops.
  • Without deduplication, you log the same thread multiple times and waste outreach time on repeats.

The Solution: Reddit leads logged to Sheets automatically

This workflow runs on a schedule (every 2 hours) and uses Reddit’s OAuth connection to pull the latest posts from subreddits you choose. It then filters for posts that match the signals you care about, like mentions of freelance work, gigs, or n8n-related needs. For each relevant post, it fetches the comment thread, keeps only the top-level comments (so you get direct replies, not deep rabbit holes), and removes moderator comments that usually don’t help you qualify a lead. Finally, it formats everything into consistent fields and appends a clean row to your Google Sheet, including the subreddit, title, post URL, comment body, username, and timestamp.

The workflow starts with a cron trigger and a set of Reddit API requests that pull up to 10 recent posts per subreddit stream. After merging those streams, it collects comments, excludes mod replies, checks your existing sheet to prevent duplicates, then appends only net-new leads.

What You Get: Automation vs. Results

Example: What This Looks Like

Say you track 8 subreddits and manually review 10 new posts each. If it takes maybe 2 minutes per post to skim, open comments, and decide “lead or not,” that’s about 160 minutes per sweep. Do that twice a day and you’re near 5 hours a week, and you still forget to log details. With this workflow running every 2 hours, your “time spent” becomes a quick 10-minute review of the sheet and picking who to contact.

What You’ll Need

  • n8n instance (try n8n Cloud free)
  • Self-hosting option if you prefer (Hostinger works well)
  • Reddit app (OAuth2) to read posts and comments.
  • Google Sheets to store leads in a clean table.
  • Google account access (authorize in n8n credentials).

Skill level: Intermediate. You’ll connect OAuth credentials and match spreadsheet columns, but you won’t be writing new code from scratch.

Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).

How It Works

A scheduled check runs in the background. The cron trigger fires every 2 hours, so you get fresh threads without remembering to look.

Reddit posts are pulled and shaped into usable fields. Multiple HTTP requests fetch recent posts, then “Set” steps map details like title, URL, subreddit, and timestamps so everything stays consistent downstream.

Only the posts worth your time continue. IF filters remove noise, then the workflow fetches comments for the remaining posts, keeps top-level replies, and excludes moderator comments that usually add clutter instead of context.

Your Google Sheet stays clean. The workflow reads existing rows, deduplicates in code, and appends only new lead records into a pre-created sheet with matching column names.

You can easily modify the subreddit list and keyword filters to match your niche based on your needs. See the full implementation guide below for customization options.

Step-by-Step Implementation Guide

Step 1: Configure the Scheduled Trigger

Set up the workflow schedule so all API requests start automatically on your preferred cadence.

  1. Add and open Scheduled Automation Trigger.
  2. Configure the schedule timing to match your lead-capture frequency (daily, hourly, etc.).
  3. Confirm that Scheduled Automation Trigger outputs to eight parallel request nodes.

Tip: Scheduled Automation Trigger outputs to Primary API Request, Secondary API Request, Third API Request, Fourth API Request, Fifth API Request, Sixth API Request, Seventh API Request, and Eighth API Request in parallel.

Step 2: Connect the Parallel API Requests

Configure all HTTP request nodes that fetch posts in parallel batches.

  1. Open Primary API Request and define the target endpoint and request method.
  2. Repeat the same setup for Secondary API Request, Third API Request, Fourth API Request, Fifth API Request, Sixth API Request, Seventh API Request, and Eighth API Request.
  3. Ensure each request returns a list of posts suitable for the downstream mapping nodes.

Credential Required: Connect your HTTP Request credentials in each API node if your endpoints require authentication.

Step 3: Map and Split Post Batches

Normalize post data and split each response into individual items for processing.

  1. Configure Map Post Details to set the fields you need from Primary API Request.
  2. Repeat field mapping for Map Post Details B through Map Post Details H to keep field names consistent across batches.
  3. Ensure each mapping node connects to its respective split node: Split Posts Batch A through Split Posts Batch H.
  4. Verify all Split Posts Batch nodes output to Combine Post Streams.

Tip: Keep field names identical across Map Post Details nodes to avoid mismatched data in Combine Post Streams.

Step 4: Combine Streams and Fetch Comments

Merge all post streams, then fetch comments across the combined posts.

  1. Open Combine Post Streams and confirm it receives inputs from all eight split nodes.
  2. Configure Fetch Multi-Post Comments to pull comments for each merged post.
  3. Connect Combine Post Streams → Fetch Multi-Post Comments as shown in the workflow.

Credential Required: Connect your Reddit credentials in Fetch Multi-Post Comments to authorize comment retrieval.

Step 5: Filter and Qualify Leads

Filter out moderator replies and narrow results to hiring-related comments.

  1. Configure Exclude Moderator Replies to identify and remove moderator content.
  2. Set up Hiring Comment Filter to pass only hiring-related comments forward.
  3. Ensure the flow is Fetch Multi-Post Comments → Exclude Moderator Replies → Hiring Comment Filter.

⚠️ Common Pitfall: If Exclude Moderator Replies is too strict, you may filter out valid leads. Test with real comment samples.

Step 6: Connect Google Sheets and Deduplicate

Retrieve existing leads, remove duplicates, and prepare clean records for storage.

  1. Open Retrieve Existing Leads and select your spreadsheet and worksheet.
  2. Configure Deduplicate Lead Records to compare incoming leads against existing rows.
  3. Confirm the flow is Hiring Comment Filter → Retrieve Existing Leads → Deduplicate Lead Records.

Credential Required: Connect your Google Sheets credentials in Retrieve Existing Leads.

Step 7: Configure the Output Destination

Append the deduplicated leads into your Google Sheet.

  1. Open Append Leads to Sheet and choose the same spreadsheet destination.
  2. Map the incoming fields from Deduplicate Lead Records to the target columns.
  3. Ensure Deduplicate Lead Records outputs directly to Append Leads to Sheet.

Credential Required: Connect your Google Sheets credentials in Append Leads to Sheet.

Step 8: Test and Activate Your Workflow

Run an end-to-end test to confirm lead capture, filtering, and storage.

  1. Click Execute Workflow and inspect outputs from Combine Post Streams, Fetch Multi-Post Comments, and Append Leads to Sheet.
  2. Confirm that Exclude Moderator Replies and Hiring Comment Filter only pass valid hiring leads.
  3. Verify that new leads are appended in Append Leads to Sheet and that duplicates are removed.
  4. Switch the workflow to Active to run on schedule.
🔒

Unlock Full Step-by-Step Guide

Get the complete implementation guide + downloadable template

Common Gotchas

  • Reddit OAuth credentials can expire or lack the right scopes. If requests start failing, check your Reddit app settings and the n8n Credentials screen 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.
  • Google Sheets appends can go sideways when column names don’t match exactly. Make sure your header row matches the workflow’s fields before you run it on a schedule.

Related Workflows

If you want to act faster than “check the sheet later,” pair this with Reddit + Telegram: paid lead alerts you can act on so high-intent threads hit your phone while they’re still hot.

When you’re doing outreach in near-real time, Reddit to Telegram, never miss hot leads again is a clean companion workflow, because alerts help you reply while the thread is still active.

If you like this Google Sheets approach but need stricter filtering, Reddit to Google Sheets, qualified leads logged fast is useful when you’d rather log fewer rows and increase close rates.

For teams that want context for follow-up, Reddit to Google Sheets, lead notes logged for you can help you capture quick qualifiers so you’re not re-reading the whole thread before every message.

Finally, if your leads also come from your site, Webform to Google Sheets, leads logged clean keeps inbound and Reddit-sourced leads in the same system, which makes follow-up a lot more consistent.


Quick reference:

Frequently Asked Questions

How long does it take to set up this Reddit lead capture automation?

About 30 minutes if your Reddit and Google accounts are ready.

Do I need coding skills to automate Reddit lead capture?

No. You’ll connect accounts and confirm a few fields in Google Sheets.

Is n8n free to use for this Reddit lead capture workflow?

Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. Reddit and Google Sheets can be used on free tiers for most small teams.

Where can I host n8n to run this Reddit lead capture automation?

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.

Can I customize this Reddit lead capture workflow for different subreddits and keywords?

Yes, and you’ll want to. Update the subreddit targets in the HTTP Request nodes that fetch posts, then adjust the IF filters (and the “Hiring Comment Filter”) to match phrases you actually care about. Common tweaks include focusing on “hiring” flairs, excluding certain authors, and logging extra fields like score or comment count.

Why is my Reddit connection failing in this workflow?

Most of the time it’s expired OAuth access or a Reddit app misconfiguration. Reconnect the Reddit credential in n8n, then confirm your Reddit app is still active and allowed to access the endpoints you’re calling. Also check rate limiting if you expanded to lots of subreddits, because multiple HTTP requests can spike usage. Frankly, one small permissions change on the Reddit side can break a previously “working” flow.

How many leads can this Reddit lead capture automation handle?

Plenty for most prospecting routines: it pulls the latest 10 posts per request stream on each run, every 2 hours, and logs only what passes your filters. On n8n Cloud Starter you’re capped by monthly executions, while self-hosting is mostly limited by your server and how aggressively you hit the Reddit API.

Is this Reddit lead capture automation better than using Zapier or Make?

Yes, but it depends on how picky you are. This flow uses multi-step filtering, comment processing, and deduplication, which is where n8n tends to feel simpler (and cheaper) than building a long Zapier chain. Zapier or Make can be fine for a basic “new post to sheet,” but grabbing top-level comments and excluding mod replies usually turns into extra steps fast. n8n also gives you the self-hosted option, so you’re not watching task limits every week. If you want help choosing, Talk to an automation expert.

Once this is running, your spreadsheet becomes the habit, not Reddit tabs. The workflow handles the repetitive capture and cleanup so you can focus on outreach that actually closes.

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.

Talk to Automation Expert →

Lisa Granqvist

Workflow Automation Expert

Expert in workflow automation and no-code tools.

×

Use template

Get instant access to this n8n workflow Json file

Copy and import json workflow into your n8n workflow

💬
Get a free quote today!
Get a free quote today!

Tell us what you need and we'll get back to you within one working day.

Get a free quote today!
Get a free quote today!

Tell us what you need and we'll get back to you within one working day.