Apify + OpenAI + Notion: Reddit Complaint Board in n8n

Turn public Reddit complaints into a structured “complaints board” in Notion—automatically

This weekly n8n workflow uses Apify to collect relevant Reddit posts, OpenAI to identify real product complaints and extract key details, and Notion to save them as a searchable complaints board (theme, severity, verbatim quote, and a “leaving” flag).

What this workflow does

• Runs every Monday morning on a scheduled schedule.
• Searches Reddit via Apify using your configured query, subreddit (optional), and maximum item count.
• Filters out low-signal posts by discarding items that are too short to contain meaningful complaint content.
• Avoids duplicates by skipping posts already processed in previous runs.
• Uses OpenAI to classify complaints, returning:
  • Whether the post is actually a complaint
  • A normalized theme
  • A verbatim quote
  • severity score
  • A “leaving” flag indicating switching away
• Normalizes theme wording into consistent buckets.
• Filters by minimum severity using your configured threshold.
• Creates a new Notion page in your database for each kept complaint, storing theme, quote, severity, source, and leaving.

Use cases

• SaaS product teams tracking recurring pain points from Reddit in a structured Notion board.
• Automation engineers setting up an opinionated pipeline: crawl → classify → deduplicate → save to Notion.
• Operators prioritizing support and product improvements based on OpenAI-scored severity and leaving intent.

Technical details

• Apify for Reddit collection (query/subreddit/maxItems).
• OpenAI for complaint detection, theme extraction, verbatim quote, severity scoring, and leaving flag.
• Notion for database inserts (Quote as rich text, Severity as number, Source as rich text, Leaving as checkbox).
• n8n nodes include set, code, filter, notion, and a sticky note (plus optional Slack/Google Sheets outputs if enabled).