Monetizable Reddit Problem Finder: Apify + Gemini + Google Sheets (n8n)

Find Monetizable Software Problems on Reddit—Automatically (Apify + Gemini + Google Sheets in n8n)

This n8n workflow automatically scans Reddit for problem-focused posts, uses Google Gemini to identify monetizable software opportunities, and saves high-confidence results into Google Sheets—so you can turn “pain signals” into SaaS ideas with less guesswork.

What this workflow does

• Runs on a schedule: executes daily at 9:00 via the Schedule Trigger.
• Scrapes Reddit with Apify: uses Apify’s Reddit Scraper actor to search recent posts (last day, sorted by new) using predefined problem-oriented search terms.
• Normalizes and deduplicates results: cleans scraped content into a consistent structure (id, title, body, subreddit, URL) and removes posts already seen in previous executions.
• Pre-filters for real “problem/pain” signals: rejects obvious promotions, hiring/megathreads, low-text posts, and keeps only items that show strong problem intent.
• Calls Google Gemini for opportunity scoring: sends the remaining posts to Gemini to select only opportunities with an opportunityScore of 75+, returning a strict JSON array with evidence, problem, and solution hypotheses.
• Writes to Google Sheets: parses Gemini’s JSON, filters to keep only opportunityScore ≥ 75, and appends/updates rows keyed by the Reddit post ID.

Use cases

• SaaS operators validating new product ideas from real customer pain on Reddit.
• Automation engineers building an n8n workflow that combines Apify scraping + Gemini analysis + Google Sheets reporting.
• Founders and marketers maintaining a living pipeline of “monetizable problem” leads.

Technical details

• n8n nodes: Schedule Trigger, Apify (apifyn8n-nodes-apify), Code, Filter, Google Sheets, plus workflow notes via Sticky Note.
• Integrations: Apify Reddit Scraper actor, Google Gemini (PaLM), and Google Sheets OAuth2.
• Setup: connect Apify credentials, add a Google Gemini API credential, set your Google Sheets sheet tab and replace YOUR_GOOGLE_SHEET_ID.