Reddit + Google Sheets: leads logged and replies drafted
Reddit is full of people practically describing what they want to buy. The annoying part is finding the right posts, fast, then tracking them somewhere other than “a bunch of open tabs.”
This is where Reddit lead logging pays off. Growth marketers get a steady stream of high-intent conversations, agency owners can spot client opportunities without doom-scrolling, and founders finally get a prospect list that doesn’t rot the moment the week gets busy.
This workflow pulls Reddit entries, filters out what you’ve already seen, uses Llama3 to judge intent, then logs everything in Google Sheets and drafts a reply you can post. You’ll see exactly how it works, what you need, and the gotchas to avoid.
How This Automation Works
The full n8n workflow, from trigger to final output:
n8n Workflow Template: Reddit + Google Sheets: leads logged and replies drafted
flowchart LR
subgraph sg0["When clicking ‘Test workflow’ Flow"]
direction LR
n0@{ icon: "mdi:play-circle", form: "rounded", label: "When clicking ‘Test workfl..", pos: "b", h: 48 }
n1@{ icon: "mdi:database", form: "rounded", label: "Get Existing Posts1", pos: "b", h: 48 }
n2@{ icon: "mdi:database", form: "rounded", label: "Log Irrelevant Post", pos: "b", h: 48 }
n3@{ icon: "mdi:database", form: "rounded", label: "Log Relevant Post", pos: "b", h: 48 }
n4["<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/>Post Reddit Comment"]
n5@{ icon: "mdi:swap-horizontal", form: "rounded", label: "Is Post Relevant?", pos: "b", h: 48 }
n6["<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/>Parse AI Response"]
n7@{ icon: "mdi:brain", form: "rounded", label: "Ollama Chat Model", pos: "b", h: 48 }
n8@{ icon: "mdi:robot", form: "rounded", label: "AI Relevance Analysis", pos: "b", h: 48 }
n9@{ icon: "mdi:swap-vertical", form: "rounded", label: "Process One Post at a Time", pos: "b", h: 48 }
n10["<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/>Filter New Posts"]
n11@{ icon: "mdi:swap-vertical", form: "rounded", label: "Process Post Fields", pos: "b", h: 48 }
n12["<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/>Get Reddit Posts"]
n10 --> n9
n12 --> n11
n12 --> n1
n5 --> n3
n5 --> n2
n3 --> n4
n7 -.-> n8
n6 --> n5
n1 --> n10
n2 --> n9
n4 --> n9
n11 --> n10
n8 --> n6
n9 --> n12
n9 --> n8
n0 --> n12
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 n8 ai
class n7 aiModel
class n5 decision
class n1,n2,n3 database
class n6,n10 code
classDef customIcon fill:none,stroke:none
class n4,n6,n10,n12 customIcon
The Problem: Reddit Prospecting Becomes Untrackable Fast
Manual Reddit prospecting starts out simple, then turns into a mess. You search a few subreddits, find a promising post, open more threads, and tell yourself you’ll “reply later.” Later becomes never. Even when you do reply, you usually can’t remember what you’ve already responded to, which posts were actually relevant, or which subreddit themes are producing real leads. And if you’re doing this for a team, it’s worse: everyone duplicates effort, nobody logs context, and the “best” conversations disappear into the feed.
It adds up fast. Here’s where it breaks down in real life.
- You re-read the same posts every day because there’s no clean “already reviewed” list.
- Good opportunities get missed because you see them too late, after the thread is cold.
- Replies end up generic since you’re rushing and can’t pull key details back quickly.
- Tracking in a spreadsheet happens “when you have time,” which honestly means it does not happen.
The Solution: Reddit → AI Intent Filter → Sheets Log + Reply Draft
This n8n workflow turns Reddit into a repeatable lead capture system you can actually trust. You kick it off (manually to start, which is useful while you’re tuning subreddits and keywords), and it pulls fresh Reddit entries from your target communities. It then checks Google Sheets for posts you’ve already logged, so you don’t waste time reviewing the same thread again. Each new post is mapped into a consistent format, then sent through an AI relevance review using Ollama with the Llama3 model. If the post shows real buyer intent, the workflow records it as relevant, drafts a tailored reply based on the post’s context, and can publish that reply back to Reddit. If it’s not a fit, it still gets logged as irrelevant, which keeps your tracking honest and improves your targeting over time.
The workflow starts by retrieving Reddit entries and normalizing the post attributes. Next, it filters out anything already logged in Google Sheets, then loops through the remaining posts one-by-one for AI review. Finally, it writes the result to Sheets and posts a reply only for the threads that pass the relevance decision.
What You Get: Automation vs. Results
| What This Workflow Automates | Results You’ll Get |
|---|---|
|
|
Example: What This Looks Like
Say you monitor 5 subreddits and skim about 30 posts a day. Manually, you might spend 2 minutes opening and scanning each post, plus another 5 minutes copying details into a sheet and writing a first reply draft for the handful that look promising. That’s about 1 hour on a “light” day. With this workflow, you run it, wait a few minutes for AI review, and then spend about 10 minutes scanning the Google Sheet and approving the best replies. You’re not guessing what you missed, because it’s logged.
What You’ll Need
- n8n instance (try n8n Cloud free)
- Self-hosting option if you prefer (Hostinger works well)
- Reddit for pulling posts and publishing replies.
- Google Sheets to store your lead and activity log.
- Ollama + Llama3 (get it from your Ollama install) to run intent analysis locally.
Skill level: Intermediate. You’ll connect accounts, set up Sheets columns, and adjust prompts and filters confidently.
Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).
How It Works
You trigger a Reddit pull. The workflow starts with a manual run, then uses the Reddit node to retrieve entries from the subreddits you care about.
Posts get normalized and de-duplicated. n8n maps post attributes (title, body, link, author, subreddit) into clean fields, then fetches your existing Google Sheets log to filter out anything you’ve already reviewed.
AI decides what’s worth your time. It loops through fresh posts in batches, sends each one to an AI relevance review (Ollama Chat Engine + Agent), then extracts the AI output into a simple “relevant or not” decision plus a reply draft.
Everything gets recorded, and replies can be posted. Relevant posts are logged to Google Sheets and sent to the Reddit publish node to post the generated response. Irrelevant posts still get recorded so your dataset stays complete.
You can easily modify the subreddits you monitor 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 Manual Trigger
Start the workflow with a manual trigger so you can test the Reddit review loop on demand.
- Add or open Manual Run Trigger at the start of the workflow.
- Confirm it is connected to Retrieve Reddit Entries as the first operational node.
- Keep Flowpast Branding as a reference note; it does not execute.
Step 2: Connect Reddit and Google Sheets
Set up data sources and logging so the workflow can read Reddit content and track processed posts.
- Open Retrieve Reddit Entries and configure it to pull the subreddit or feed you want to monitor.
- Credential Required: Connect your Reddit credentials in Retrieve Reddit Entries.
- Open Fetch Logged Posts and configure it to read the sheet that stores already-processed post IDs.
- Credential Required: Connect your Google Sheets credentials in Fetch Logged Posts.
- Open Record Relevant Post and Record Irrelevant Post to point to the correct logging tabs or ranges.
- Credential Required: Connect your Google Sheets credentials in both Record Relevant Post and Record Irrelevant Post.
Retrieve Reddit Entries outputs to both Map Post Attributes and Fetch Logged Posts in parallel.
Step 3: Map and Filter New Posts
Prepare Reddit data and remove posts that have already been logged.
- Open Map Post Attributes and map the Reddit fields you want to standardize (e.g., ID, title, body, permalink).
- In Filter Fresh Posts, implement the code that compares incoming posts against the list from Fetch Logged Posts.
- Confirm Filter Fresh Posts connects to Iterate Single Post to process one post at a time.
⚠️ Common Pitfall: If Filter Fresh Posts doesn’t return items, the batch loop will exit immediately. Make sure the code outputs only unlogged posts.
Step 4: Set Up AI Review and Decision Logic
Use an AI agent to review each post and decide whether it is relevant.
- Open AI Relevance Review and define the relevance prompt and expected output structure.
- Ensure Ollama Chat Engine is connected as the language model for AI Relevance Review; add credentials to Ollama Chat Engine if your setup requires them.
- Use Extract AI Output to parse the agent response into structured fields.
- Configure Relevance Decision to branch based on the parsed output (relevant vs. irrelevant).
Step 5: Configure Output Actions
Log AI decisions to Google Sheets and respond on Reddit when a post is relevant.
- In the true branch of Relevance Decision, confirm it routes to Record Relevant Post.
- In the false branch, confirm it routes to Record Irrelevant Post.
- Open Publish Reddit Reply and configure the reply content using fields from the AI output and post context.
- Credential Required: Connect your Reddit credentials in Publish Reddit Reply.
- Ensure both Record Irrelevant Post and Publish Reddit Reply loop back to Iterate Single Post to continue processing.
Step 6: Test and Activate Your Workflow
Run a manual test to confirm the workflow reads posts, evaluates relevance, and logs or replies correctly.
- Click Execute Workflow to run Manual Run Trigger.
- Verify that Retrieve Reddit Entries pulls posts and that Map Post Attributes and Fetch Logged Posts run in parallel.
- Check that AI Relevance Review runs for each post and that Relevance Decision routes correctly.
- Confirm new rows appear in Record Relevant Post or Record Irrelevant Post, and that Publish Reddit Reply posts only for relevant items.
- Once verified, switch the workflow to Active for production use.
Common Gotchas
- Reddit credentials can expire or need specific permissions. If things break, check your Reddit app settings and token scopes 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.
- Default prompts in AI nodes are generic. Add your brand voice early or you’ll be editing outputs forever.
Frequently Asked Questions
About 45 minutes if your Reddit, Sheets, and Ollama pieces are ready.
No. You’ll mostly connect accounts and edit prompts, plus adjust a couple of filters.
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 Ollama hosting costs (usually just your server or computer).
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 it’s a common tweak. You can disable or remove the “Publish Reddit Reply” node and keep the “Record Relevant Post” logging step, then store the draft reply text in Google Sheets for manual approval. Many teams also customize the AI Relevance Review prompt to enforce tone (helpful, non-promotional) and to avoid linking unless the thread explicitly asks for solutions. You can also add an extra If check that only allows posting in certain subreddits.
Usually it’s expired Reddit credentials or a misconfigured Reddit app (wrong redirect URI or missing scopes). Reconnect the Reddit account in n8n, then re-check the Reddit node’s authentication settings. If it works for a few posts and then fails, you may be hitting rate limits, so reduce how many entries you pull per run or space out executions.
On self-hosted n8n, it depends mostly on your server and how fast Ollama can evaluate posts, but handling a few hundred posts per day is realistic. On n8n Cloud, your cap is mainly monthly executions, and each post reviewed counts toward that total. If you plan to monitor lots of subreddits, consider batching and running it a few times per day instead of pulling everything at once.
For Reddit lead logging with AI filtering, n8n is usually the more flexible choice. You can branch logic freely (relevant vs. irrelevant), loop through posts in controlled batches, and keep the whole thing self-hosted if you want unlimited runs. Zapier and Make can work, but multi-step loops plus AI calls get expensive and fiddly. Also, this workflow’s “log everything and de-duplicate from Sheets” pattern is easier to manage when you can add small bits of code and custom mapping. If you want, start with n8n and only move platforms if your use case stays very simple. Talk to an automation expert if you’re not sure which fits.
Once this is running, your Reddit prospecting stops being a daily scramble and starts behaving like a system. The workflow handles the repetitive parts, and you keep control over the conversations that matter.
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.
