Find Startup Opportunities from Reddit with Apify, Gemini & Sheets

Find high-confidence SaaS startup ideas from Reddit—automatically

This n8n workflow searches Reddit for problem-focused posts using Apify, analyzes the best opportunities with Google Gemini, and saves only the strongest matches to Google Sheets—ready for your next product brainstorm or validation sprint.

What this workflow does

• Runs daily at 09:00 using a scheduled trigger.
• Uses Apify’s Reddit Scraper actor (harshmaur/reddit-scraper) to fetch new Reddit posts from the last day based on problem-oriented search terms.
• Normalizes scraped fields, deduplicates posts against items already seen in previous runs, and pre-filters low-signal/promotional/irrelevant content.
• Sends the remaining candidate posts in a batch to Google Gemini to extract and score monetizable software opportunities as JSON.
• Parses Gemini’s JSON output into individual opportunity items and keeps only those with an opportunityScore of 75+.
• Appends or updates results in Google Sheets, using the Reddit post ID as the unique key.

Use cases

• SaaS operators validating demand by scanning Reddit problem threads daily.
• Automation engineers building an ideas pipeline that turns unstructured posts into structured opportunities.
• Startup teams generating hypotheses (problem, solutionIdea, whyPeoplePay) and tracking evidence in Sheets.

Technical details

• n8n nodes: schedule trigger, Apify node (apify-nodes-apify), code, filter, sticky note, Google Sheets.
• Apify connection: add an Apify OAuth2 connection and access the harshmaur/reddit-scraper actor.
• Gemini integration: add a Google Gemini (PaLM) API credential for the Google Gemini node.
• Sheets schema: configure the target spreadsheet/tab with columns: id, title, community, url, isOpportunity, opportunityScore, problem, solutionIdea, whyPeoplePay, evidence, category.