Log Reddit Customer Pain Points to Google Sheets with n8n

Turn Reddit complaints into a structured customer pain-point log—automatically

This n8n workflow searches your chosen subreddits every day for keyword-driven complaint phrases, uses GPT-4o-mini to keep only first-hand problem reports, and appends each verified pain point to Google Sheets with a verbatim quote and permalink for full traceability.

What this workflow does

• Runs once daily using a schedule trigger to keep your research log up to date.
• Uses a single Config node to centralize all settings you’ll change: subreddits, keywords, post limit, and the spreadsheet ID—no digging through the workflow.
• Builds search queries by pairing each subreddit with each keyword (one query per pair).
• Queries Reddit for recent posts that match the keyword. The Reddit node is configured to continue on failure, so rate limits return partial results instead of killing the run.
• Flattens results into one row per post, removes duplicates within the run, filters out deleted/empty posts, and trims long bodies to 2000 characters.
• Processes posts one at a time with GPT-4o-mini to produce a structured record: first-hand pain point flag, category, severity, any product named, a verbatim quote, and a one-sentence summary.
• Filters to keep only posts marked as genuine first-hand pain points (questions, advice, and secondhand accounts are discarded).
• Appends the surviving records to Google Sheets with subreddit, score, comment count, and permalink.

Use cases

• SaaS teams tracking customer pain points from specific Reddit communities for product feedback
• Automation engineers building a repeatable “voice of customer” pipeline for continuous research
• Support and growth teams monitoring recurring complaints and severity trends over time

Technical details

• n8n nodes: set, code, filter, reddit, google sheets, sticky note
• AI: GPT-4o-mini used to classify and extract category, severity, and a verbatim quote
• Data integrity: per-row permalink included so every entry can be traced back to the original Reddit post