Reddit Sentiment Analysis with Notion
Reddit is one of the most honest places on the internet.
People go there to actually say what they think — about products, industries, problems, competitors. No PR filter. No polished messaging. Just real opinions from real people.
For a marketer, that’s gold. The hard part is actually reading it.
What’s the problem with monitoring Reddit manually?
There’s too much of it, and most of it isn’t relevant. If you try to keep up with Reddit manually, you’ll either read everything (overwhelming) or miss the stuff that actually matters (useless).
What I needed was something that could watch the relevant subreddits, filter out the noise, tell me what the sentiment was, and surface only the things worth my attention.
What did I build?
A pipeline that does three things:
- Monitors specific subreddits for posts and comments related to topics I care about — industry discussions, competitor mentions, customer pain points
- Runs sentiment analysis on what it finds — is the conversation positive, negative, or neutral? What are people frustrated about? What are they asking for?
- Logs everything into Notion — organized by topic, sentiment score, date, and source link, so I can actually review it in a structured way
Claude handles the analysis. Notion holds the output. The whole thing runs on a schedule so I don’t have to think about it.
Why Notion specifically?
Because that’s where my research already lives. I didn’t want another dashboard to check. I wanted the insights to show up in the same place I’m doing my planning and content work.
Having Reddit sentiment sitting next to campaign notes and project briefs in Notion means I can actually connect the dots — what’s the market saying, and how does that change what I’m working on?
What do I actually use this for?
A few things. Finding language. When people describe a problem in their own words on Reddit, that’s often better copy than anything I could write from scratch. The phrases they use, the frustrations they express — that’s how real customers talk.
I also use it for competitive intelligence. When someone complains about a competitor on Reddit, or praises something a competitor does, that’s a signal worth knowing about.
And occasionally it surfaces something genuinely surprising — a use case I hadn’t considered, a question that keeps coming up, a problem nobody’s solving well yet.
Was it hard to build?
Not really. Reddit has a public API that’s reasonably easy to work with. Claude Code helped write most of the integration logic. The Notion MCP handled the database side.
The hardest part was deciding what to track and how to structure the output in Notion so it was actually useful rather than just a wall of data.
The rule I landed on: if I wouldn’t act on it, don’t log it. Fewer, more meaningful entries beats comprehensive but unread ones.