Reddit + Google Sheets: replies logged and ready
You find a perfect Reddit thread, start writing a thoughtful reply, then get pulled into something else. Ten minutes later the tab is gone, the moment passed, and your “community marketing” plan turns into random drive-bys.
This hits marketers trying to stay visible in niche communities. A solo founder feels it too, because every missed conversation is a missed customer insight. Even agency leads juggling multiple clients run into the same wall. This Reddit Sheets automation keeps the signal, drafts the reply, and logs everything so you can review it later.
You’ll see how the workflow finds relevant Reddit posts, uses Google Gemini to decide which ones are actual pain points, writes a helpful comment, and appends the details to Google Sheets for easy tracking.
How This Automation Works
The full n8n workflow, from trigger to final output:
n8n Workflow Template: Reddit + Google Sheets: replies logged and ready
flowchart LR
subgraph sg0["When clicking ‘Execute workflow’ Flow"]
direction LR
n0@{ icon: "mdi:play-circle", form: "rounded", label: "When clicking ‘Execute workf..", pos: "b", h: 48 }
n1@{ icon: "mdi:robot", form: "rounded", label: "AI Agent", pos: "b", h: 48 }
n2@{ icon: "mdi:brain", form: "rounded", label: "Google Gemini Chat Model", pos: "b", h: 48 }
n3["<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/merge.svg' width='40' height='40' /></div><br/>Merge"]
n4@{ icon: "mdi:robot", form: "rounded", label: "AI Agent1", pos: "b", h: 48 }
n5@{ icon: "mdi:brain", form: "rounded", label: "Google Gemini Chat Model1", 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/merge.svg' width='40' height='40' /></div><br/>Merge1"]
n7["<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/>Create a comment in a post"]
n8@{ icon: "mdi:database", form: "rounded", label: "Append row in sheet", 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/>Post Searching"]
n10@{ icon: "mdi:swap-horizontal", form: "rounded", label: "If Condition", pos: "b", h: 48 }
n11@{ icon: "mdi:swap-vertical", form: "rounded", label: "Value setup", pos: "b", h: 48 }
n12@{ icon: "mdi:swap-horizontal", form: "rounded", label: "If Condition 2", pos: "b", h: 48 }
n3 --> n12
n6 --> n8
n1 --> n3
n4 --> n6
n11 --> n1
n11 --> n3
n10 --> n11
n12 --> n4
n12 --> n6
n9 --> n10
n8 --> n7
n2 -.-> n1
n5 -.-> n4
n0 --> n9
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 n1,n4 ai
class n2,n5 aiModel
class n10,n12 decision
class n8 database
classDef customIcon fill:none,stroke:none
class n3,n6,n7,n9 customIcon
The Problem: Reddit engagement is high-effort to do well
Reddit rewards helpfulness, context, and timing. That’s the good part. The rough part is the manual grind: searching subreddits, opening posts, skimming for real frustration (not just noise), then trying to craft something that doesn’t sound promotional. And even if you do all that, you usually don’t track it anywhere. So you can’t answer simple questions later, like “What pain points are showing up this month?” or “Which replies actually got upvoted?” It’s not one big failure. It’s a dozen small frictions that stack up.
Here’s where it breaks down.
- You spend about 30 minutes hunting for “the right” threads, and most of them aren’t actionable.
- Good replies take focus, but you’re writing them inside a chaotic browser session with zero structure.
- Without a log, you lose community insights that could inform content, positioning, or product fixes.
- When you scale to more than one subreddit or brand, consistency falls apart fast.
The Solution: Auto-detect pain points, draft replies, and log everything
This n8n workflow monitors Reddit posts matching a keyword you choose, then uses Google Gemini to figure out if the post is actually describing a problem worth responding to. If Gemini says “No,” the workflow still captures the post details for context and moves on. If Gemini says “Yes,” it triggers a second Gemini prompt that drafts a concise, helpful solution comment. Finally, it merges the post data and the AI output, appends a clean row to Google Sheets, and (optionally) publishes the reply back to Reddit as a comment on the original thread. You end up with two outcomes at once: community engagement that happens on time, and a growing spreadsheet of real-world pain points you can sort and review.
The workflow starts when you run it (manual trigger by default, easy to swap to a schedule). It searches a subreddit like r/n8n for posts containing a phrase such as “Why I stopped using,” filters for minimum quality (2+ upvotes and non-empty text), then lets Gemini make the call. If it’s a match, Gemini drafts the reply and n8n posts it, then logs the whole interaction to Sheets.
What You Get: Automation vs. Results
| What This Workflow Automates | Results You’ll Get |
|---|---|
|
|
Example: What This Looks Like
Say you check Reddit three times a week and scan about 25 posts per session. If you spend roughly 2 minutes reading each post and another 5 minutes drafting a decent reply, that’s around 3 hours a week. With this workflow, you run one execution, let it filter for 2+ upvotes, and Gemini drafts replies only for posts that are real problems. You’ll still review the Google Sheet and tweak wording when needed, but the weekly effort often drops to about 30–45 minutes.
What You’ll Need
- n8n instance (try n8n Cloud free)
- Self-hosting option if you prefer (Hostinger works well)
- Reddit OAuth2 API for searching posts and replying.
- Google Sheets to log posts, classifications, and drafts.
- Google Gemini API key (get it from Google AI Studio / Gemini API in your Google Cloud setup).
Skill level: Intermediate. You will connect credentials, adjust a search query, and lightly edit AI prompts to match your niche.
Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).
How It Works
A manual run (or schedule) kicks things off. In the provided workflow, you click “Execute workflow” to run it on demand. If you want a steady drumbeat, swap in a Schedule Trigger so it checks Reddit every morning or a few times per day.
Reddit is searched, then low-quality posts are filtered out. The Reddit node looks for recent posts in a subreddit (r/n8n by default) containing a keyword like “Why I stopped using.” An If condition keeps only posts with at least 2 upvotes and non-empty text, so you’re not wasting Gemini calls on fluff.
Gemini classifies the post, then drafts a reply if it’s a real pain point. n8n maps the post fields (title, body, upvotes, creation time, subreddit ID), sends that to a “Problem Classifier” Gemini prompt, and waits for a simple Yes/No decision. If it’s Yes, a second Gemini prompt generates a helpful solution comment that aims to be concise and non-spammy (important on Reddit, frankly).
Everything gets merged, logged to Sheets, and optionally posted as a comment. The workflow merges your post data with the AI output, appends a row to Google Sheets, then publishes the reply on Reddit. That means you can audit what was posted, learn from the patterns, and refine prompts over time.
You can easily modify the search keyword 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
Set up the workflow entry point so you can manually execute the Reddit analysis flow during testing.
- Add the Manual Run Trigger node at the start of the workflow.
- Confirm no parameters are required for Manual Run Trigger.
- Connect Manual Run Trigger to Reddit Post Finder.
Step 2: Connect Reddit Search and Filtering
Pull recent posts from the n8n subreddit and filter to only high-engagement posts with text content.
- Open Reddit Post Finder and set Operation to
search. - Set Subreddit to
n8nand Keyword toWhy i stopped using. - Set Limit to
10. - Credential Required: Connect your Reddit credentials in Reddit Post Finder (currently not configured).
- Open Engagement Filter and add conditions: ups
>= 2using{{$json.ups}}and selftext is not empty using{{$json.selftext}}. - Connect Reddit Post Finder to Engagement Filter.
Step 3: Map Post Data for AI and Merging
Standardize the fields needed by the AI nodes and downstream merges.
- Open Map Post Fields and create assignments for:
title ={{$json.title}}, selftext ={{$json.selftext}}, ups ={{$json.ups}}, created ={{$('Reddit Post Finder').item.json.created}}, url ={{$json.url}}, subreddit_id ={{$json.subreddit_id}}, id ={{$json.id}}. - Connect Engagement Filter to Map Post Fields.
- Map Post Fields outputs to both Problem Classifier Agent and Combine Inputs in parallel.
Step 4: Set Up AI Classification and Routing
Use Gemini to decide whether the Reddit post describes a real automation problem and route accordingly.
- Open Problem Classifier Agent and confirm Prompt is set to:
=Define weather the reddit post is talking about the problems faced by the users of AI Automation or they need a solution on how they want bew features in AI Automation. the post should mention a specific problem faced by the users. Reddit Post: {{ $json.selftext }} Is this post is about a problem that users are facing about AI Automation or they need new features, Just answer with Yes or No. - Ensure Gemini Chat Model A is connected as the language model for Problem Classifier Agent.
- Credential Required: Connect your Google Gemini credentials in Gemini Chat Model A (add credentials to the model, not the agent).
- Open Combine Inputs and set Mode to
combineand Combine By tocombineByPosition(leave Include Unpaired on). - Connect Problem Classifier Agent to Combine Inputs, then connect Combine Inputs to Problem Check Gate.
- In Problem Check Gate, set the condition to output contains
Yesusing{{$json.output}}. - Problem Check Gate outputs to both Solution Planner Agent and Merge Solution Data in parallel.
Step 5: Generate Solutions and Merge Outputs
Generate a concise solution and merge it with the post data for storage and reply.
- Open Solution Planner Agent and confirm the prompt text is:
=Based on the reddit post, suggest a plan or a solution on how i fix the issues the users are facing with Sora 2. Reddit Post: {{ $json.selftext }} Provide a concise solution on how we can fix the problems in slack based on the reddit post. Explain the solution - Ensure Gemini Chat Model B is connected as the language model for Solution Planner Agent and set Model Name to
models/gemini-2.0-flash. - Credential Required: Connect your Google Gemini credentials in Gemini Chat Model B (add credentials to the model, not the agent).
- Open Merge Solution Data and set Mode to
combineand Combine By tocombineByPosition. - Connect Solution Planner Agent to Merge Solution Data.
Step 6: Configure Outputs to Google Sheets and Reddit Reply
Store analysis results in Google Sheets and publish a Reddit comment using the generated solution.
- Open Append Sheet Row and set Operation to
append. - Select your target spreadsheet: set Document ID to your sheet and Sheet Name to
Sheet2. - Map columns in Append Sheet Row: Bio =
{{$json.created}}, username ={{$json.selftext}}, Full Name ={{$json.output}}, Profile ID, ={{$json.title}}, Follower Count ={{$json.subreddit_id}}. - Credential Required: Connect your Google Sheets credentials in Append Sheet Row (currently not configured).
- Connect Merge Solution Data to Append Sheet Row, then connect Append Sheet Row to Publish Reddit Reply.
- Open Publish Reddit Reply and set Post ID to
{{$json.Bio}}and Comment Text to{{$json['Full Name']}}. - Credential Required: Connect your Reddit credentials in Publish Reddit Reply (currently not configured).
Step 7: Test and Activate Your Workflow
Run a manual test to confirm the Reddit search, AI classification, and outputs are working end-to-end before activating.
- Click Execute Workflow to run Manual Run Trigger and fetch live Reddit posts.
- Verify Engagement Filter passes posts with ups ≥ 2 and non-empty selftext.
- Confirm Problem Classifier Agent returns
YesorNoand that Problem Check Gate routes correctly. - Check that Append Sheet Row writes a new row and Publish Reddit Reply posts a comment using the generated solution.
- When successful, toggle 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 the connected OAuth scopes in n8n 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 30 minutes if you already have your API keys.
No. You’ll mostly connect accounts and edit a few prompts and 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 Google Gemini API usage, which is usually low for a few runs per day but depends on your prompt size and model.
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 smart move at first. Keep the Google Sheets logging step, but disable the “Publish Reddit Reply” node so nothing posts automatically. Many teams also add a simple “Approved?” column in Sheets, then only publish when that value is true. You can also tweak the search keyword and the upvote threshold so the workflow only surfaces higher-quality threads.
Usually it’s expired or revoked OAuth access in your Reddit developer app, so re-authenticate and confirm the correct scopes for reading and posting. Also double-check the subreddit and search query, because some failures are just “no results” disguised as a node error. If you’re running it often, you might also hit rate limits, so spacing runs out with a schedule can help.
Practically, it can handle as many as your n8n execution limits and API rate limits allow.
Often, yes, because this workflow isn’t just a simple “Reddit new post → do X” zap. You have filtering, two AI decisions, merging data, and an optional publish step, which is exactly where n8n tends to feel more flexible. Self-hosting also changes the economics if you expect higher volume. Zapier or Make can still be fine if you want the quickest setup and you’re keeping it to a lightweight flow, but Reddit + AI + logging usually grows into something that benefits from n8n. Talk to an automation expert if you’re not sure which fits.
Once this is running, you stop relying on memory and browser tabs to “do Reddit.” The workflow keeps you consistent, and Google Sheets keeps you honest.
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.
