Reddit sentiment analysis with Notion

People go there to 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 valuable. The hard part is reading it.

The problem with monitoring Reddit by hand

There's too much of it, and most of it isn't relevant. If you try to keep up manually, you either read everything (overwhelming) or miss what matters (useless).

I needed something that would watch the relevant subreddits, filter out the noise, tell me what the sentiment was, and surface only the things worth my attention.

What I built

A pipeline that does three things:

1. Monitors specific subredditsFor posts and comments related to topics I care about: industry discussions, competitor mentions, customer pain points.
2. Runs sentiment analysisOn what it finds: is the conversation positive, negative, or neutral? What are people frustrated about? What are they asking for?
3. Logs everything into NotionOrganized by topic, sentiment score, date, and source link, so I could review it in a structured way.

Claude handled the analysis. Notion held the output. The whole thing ran on a schedule.

Why Notion

That's where my research already lived. I wanted the insights in the same place I was doing my planning and content work, with no extra dashboard to check.

With Reddit sentiment sitting next to campaign notes and project briefs, I could connect the dots: what's the market saying, and how does that change what I'm working on?

What I used it for

• Finding languageWhen 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 are how real customers talk.
• Competitive intelligenceWhen someone complained about a competitor, or praised something a competitor did, that was a signal worth knowing.
• SurprisesOccasionally it surfaced something I hadn't considered: a new use case, a question that kept coming up, a problem nobody was solving well.

Building it

It wasn't hard. Reddit has a public API that's reasonably easy to work with. Claude Code wrote 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 useful rather than a wall of data.

The rule I landed on: if I wouldn't act on it, don't log it. Fewer, more meaningful entries beat comprehensive but unread ones.