Reddit to Google Sheets, sentiment insights ready
Tracking what Reddit is saying about your brand (or your market) sounds simple until you’re copy-pasting posts into a spreadsheet, skimming comments, and guessing if the tone is “bad bad” or just “Reddit bad.” It’s slow. It’s inconsistent. And you always find the important thread two days late.
Reddit sentiment automation helps most when you’re the person expected to “keep a pulse” on the community. Marketing managers feel it during launches. Community leads end up firefighting. Founders end up reading threads at midnight.
This workflow pulls Reddit posts plus their comments, scores sentiment and toxicity with AI, then saves clean, structured insights to Google Sheets so you can report, escalate, and decide faster.
How This Automation Works
The full n8n workflow, from trigger to final output:
n8n Workflow Template: Reddit to Google Sheets, sentiment insights ready
flowchart LR
subgraph sg0["Structured Output Bu Flow"]
direction LR
n0["<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/>Fetch Post Comments"]
n1["<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/>Retrieve Post List"]
n2["<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/webhook.dark.svg' width='40' height='40' /></div><br/>Incoming Webhook Trigger"]
n3@{ icon: "mdi:swap-vertical", form: "rounded", label: "Separate Items", pos: "b", h: 48 }
n4@{ icon: "mdi:swap-vertical", form: "rounded", label: "Batch Iterator", pos: "b", h: 48 }
n5@{ icon: "mdi:brain", form: "rounded", label: "OpenRouter Chat Engine", pos: "b", h: 48 }
n6@{ icon: "mdi:robot", form: "rounded", label: "Structured Output Builder", pos: "b", h: 48 }
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/code.svg' width='40' height='40' /></div><br/>Transform Script"]
n8["<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/webhook.dark.svg' width='40' height='40' /></div><br/>Return Webhook Reply"]
n9@{ icon: "mdi:robot", form: "rounded", label: "Sentiment Scoring", pos: "b", h: 48 }
n7 --> n8
n2 --> n1
n3 --> n0
n1 --> n3
n4 --> n3
n4 --> n9
n9 --> n6
n5 -.-> n6
n5 -.-> n9
n6 --> n7
n0 --> 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 n6,n9 ai
class n5 aiModel
class n2,n8 api
class n7 code
classDef customIcon fill:none,stroke:none
class n0,n1,n2,n7,n8 customIcon
The Problem: Reddit Insight Work Turns Into Manual Reporting
Reddit is incredible market research, but it’s not packaged for decision-making. One thread can have a great post, a messy comment section, sarcasm, pile-ons, and a few genuinely useful suggestions buried near the bottom. When you “monitor Reddit” manually, you end up doing three jobs at once: collecting data, interpreting tone, and turning it into something your team can act on. That’s why it drags. And why your weekly report quietly turns into “a few screenshots and vibes.”
The friction compounds. Not because any single step is hard, but because there are too many of them.
- Copying posts and comment excerpts into a sheet takes about 10 minutes per thread, and it’s easy to miss the most upvoted reply.
- Human sentiment labeling is inconsistent across people and days, so your “trend” can be a mood swing.
- Toxicity and urgency are usually spotted late, which means escalations happen after a thread has already spread.
- Without structured fields (topic, sentiment, confidence, tone), it’s hard to compare communities or build a reliable dashboard.
The Solution: Reddit Sentiment + Toxicity Scoring to Google Sheets
This n8n workflow starts with an incoming webhook request where you specify a subreddit, an optional search query, and how many posts you want to analyze. It then pulls a list of recent posts from Reddit, splits them into individual items, fetches comments for each post, and processes everything in batches so your analysis doesn’t fall over when volume spikes. From there, an AI model (via an OpenRouter chat node, plus structured output steps) evaluates sentiment, emotional tone, discussion type, toxicity level, and what action to take next. Finally, the workflow transforms the AI response into clean fields you can save and report on, and returns a structured JSON response (perfect for piping into Google Sheets or Excel 365).
The workflow begins when your webhook receives a payload like “r/technology, query AI, limit 10.” It collects posts and their comments, then uses AI to score and summarize what’s happening. You end up with structured insights you can paste into a sheet, chart, filter, and share without re-reading the whole thread.
What You Get: Automation vs. Results
| What This Workflow Automates | Results You’ll Get |
|---|---|
|
|
Example: What This Looks Like
Say you monitor 3 subreddits and review 10 posts per subreddit each week. Manually, if you spend roughly 10 minutes per post to skim comments, judge tone, and paste notes, that’s about 5 hours weekly. With this workflow, you send 3 webhook requests (a minute each), wait for processing, and paste or write results into Google Sheets. Most teams get the same weekly coverage in under an hour, with far better consistency.
What You’ll Need
- n8n instance (try n8n Cloud free)
- Self-hosting option if you prefer (Hostinger works well)
- Reddit OAuth2 app for pulling posts and comments
- OpenRouter API to run the AI sentiment model
- Google Sheets to store and report the insights
Skill level: Intermediate. You’ll paste credentials, test a webhook request, and tweak prompts, but you won’t be writing an app from scratch.
Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).
How It Works
Webhook request triggers the run. You POST a simple payload with subreddit, limit, and (optionally) a query term. That makes it easy to run on-demand, or from another tool that can send webhooks.
Reddit content is collected and separated. The workflow retrieves a post list, splits the results into individual items, then fetches comments for each post so the AI sees the real conversation, not just the title.
Batch processing keeps it stable. A batch iterator groups items to avoid overwhelming APIs. Inside the batch loop, the sentiment scoring and structured output steps produce consistent JSON fields you can trust.
Structured insights are returned and ready for Sheets. A transform script cleans the AI response, then the workflow returns the final payload. From there, you save to Google Sheets (or Excel 365) for dashboards, weekly reports, and alerts.
You can easily modify the AI prompt to focus on product mentions or competitors based on your needs. See the full implementation guide below for customization options.
Step-by-Step Implementation Guide
Step 1: Configure the Webhook Trigger
Set up the inbound trigger that starts the workflow and initiates the Reddit post retrieval.
- Add and open Incoming Webhook Trigger.
- Configure the webhook path and HTTP method as required for your source system.
- Copy the webhook URL for use in your calling system or test tool.
- Ensure Incoming Webhook Trigger is connected to Retrieve Post List as shown in the workflow.
Step 2: Connect Reddit Data Sources
Configure the Reddit nodes that collect posts and comments for sentiment analysis.
- Open Retrieve Post List and set the subreddit, listing type, and limits based on your use case.
- Open Separate Items to confirm it splits the post list into individual items.
- Open Fetch Post Comments and configure it to retrieve comments for each post item.
- Verify the flow order: Incoming Webhook Trigger → Retrieve Post List → Separate Items → Fetch Post Comments → Batch Iterator.
Step 3: Set Up AI Sentiment Processing
Configure the LLM workflow that scores sentiment and formats structured output.
- Open OpenRouter Chat Engine and select the model you want to use for sentiment analysis.
- Open Sentiment Scoring and define the prompt or instructions for sentiment evaluation.
- Open Structured Output Builder and configure the output schema you want returned (e.g., sentiment label, score, confidence).
- Confirm the AI flow: Sentiment Scoring → Structured Output Builder.
Step 4: Configure Output and Response
Transform the AI output and return a response to the original webhook request.
- Open Transform Script to format or aggregate the structured sentiment results as needed.
- Open Return Webhook Reply and configure the response body to return the transformed data.
- Ensure the final flow is connected: Structured Output Builder → Transform Script → Return Webhook Reply.
Step 5: Test and Activate Your Workflow
Run a full test to validate Reddit data retrieval, sentiment scoring, and webhook response output.
- Click Execute Workflow and send a test request to the Incoming Webhook Trigger URL.
- Verify that Retrieve Post List, Fetch Post Comments, Sentiment Scoring, and Structured Output Builder all return data.
- Confirm Return Webhook Reply sends back a response containing your transformed sentiment results.
- When satisfied, toggle the workflow to Active for production use.
Common Gotchas
- Reddit OAuth2 credentials can expire or have the wrong redirect URI. If things break, check your Reddit App Preferences and confirm the callback URL matches your n8n instance first.
- If you’re using Wait nodes or external processing, run times vary. Bump up the wait duration if downstream nodes fail on empty responses.
- OpenRouter model output can drift if your prompt is too broad. Add brand voice, your definitions of “toxic,” and what “urgent” means early or you will be editing outputs forever.
Frequently Asked Questions
About 30 minutes if you already have your Reddit and OpenRouter keys.
No. You’ll mostly connect accounts, paste API keys, and test the webhook payload once.
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 OpenRouter API usage costs, which depend on the model you pick.
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 mostly prompt work. Update the instructions in the “Sentiment Scoring” and “Structured Output Builder” nodes to force brand mention extraction (product names, competitors, pricing terms) and to add a field like “needs_response: yes/no.” You can also filter posts earlier by using the webhook “query” parameter so you only analyze relevant threads.
Usually it’s the Reddit OAuth app settings, not n8n. Confirm your Client ID and Client Secret are correct, and double-check the redirect URI matches your n8n URL plus /oauth/callback. If it worked before and suddenly stopped, re-authorize the Reddit credential in n8n because tokens can expire. Rate limits can also cause intermittent failures when you pull lots of posts quickly.
On self-hosted n8n there’s no execution cap; it mainly depends on your server, Reddit rate limits (about 60 requests per minute), and how many items you batch per run.
Often, yes, because this kind of Reddit-to-AI-to-structured-output flow benefits from batching, branching logic, and flexible data shaping. n8n makes it easier to loop through posts, fetch related comments, and then merge everything into consistent fields without paying extra for every “step.” Zapier and Make can still work if you keep it very simple, but multi-item processing gets clunky fast. If you want alerts, storage, and dashboards all connected, n8n tends to stay cleaner as you scale. Talk to an automation expert if you want a quick recommendation for your setup.
You don’t need more raw Reddit links. You need structured insight you can scan, share, and act on. Set this up once, and your reporting stops depending on who had time to read every comment.
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.
