{"product_id":"find-startup-opportunities-from-reddit-with-apify-gemini-sheets","title":"Find Startup Opportunities from Reddit with Apify, Gemini \u0026 Sheets","description":"\u003ch3\u003eFind high-confidence SaaS startup ideas from Reddit—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow searches Reddit for problem-focused posts using \u003cstrong\u003eApify\u003c\/strong\u003e, analyzes the best opportunities with \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e, and saves only the strongest matches to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e—ready for your next product brainstorm or validation sprint.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily at 09:00\u003c\/strong\u003e using a scheduled trigger.\u003c\/li\u003e\n  \u003cli\u003eUses \u003cstrong\u003eApify’s Reddit Scraper actor (harshmaur\/reddit-scraper)\u003c\/strong\u003e to fetch new Reddit posts from the \u003cstrong\u003elast day\u003c\/strong\u003e based on \u003cstrong\u003eproblem-oriented search terms\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes scraped fields\u003c\/strong\u003e, \u003cstrong\u003ededuplicates\u003c\/strong\u003e posts against items already seen in previous runs, and \u003cstrong\u003epre-filters\u003c\/strong\u003e low-signal\/promotional\/irrelevant content.\u003c\/li\u003e\n  \u003cli\u003eSends the remaining candidate posts in a \u003cstrong\u003ebatch\u003c\/strong\u003e to \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to extract and score \u003cstrong\u003emonetizable software opportunities\u003c\/strong\u003e as \u003cstrong\u003eJSON\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eParses Gemini’s JSON output into individual opportunity items and keeps only those with an \u003cstrong\u003eopportunityScore of 75+\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends or updates\u003c\/strong\u003e results in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, using the \u003cstrong\u003eReddit post ID\u003c\/strong\u003e as the \u003cstrong\u003eunique key\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaaS operators\u003c\/strong\u003e validating demand by scanning Reddit problem threads daily.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAutomation engineers\u003c\/strong\u003e building an ideas pipeline that turns unstructured posts into structured opportunities.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStartup teams\u003c\/strong\u003e generating hypotheses (problem, solutionIdea, whyPeoplePay) and tracking evidence in Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes:\u003c\/strong\u003e schedule trigger, Apify node (\u003ccode\u003eapify-nodes-apify\u003c\/code\u003e), code, filter, sticky note, Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify connection:\u003c\/strong\u003e add an \u003cstrong\u003eApify OAuth2\u003c\/strong\u003e connection and access the \u003cstrong\u003eharshmaur\/reddit-scraper\u003c\/strong\u003e actor.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGemini integration:\u003c\/strong\u003e add a \u003cstrong\u003eGoogle Gemini (PaLM) API credential\u003c\/strong\u003e for the Google Gemini node.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSheets schema:\u003c\/strong\u003e configure the target spreadsheet\/tab with columns: \u003ccode\u003eid\u003c\/code\u003e, \u003ccode\u003etitle\u003c\/code\u003e, \u003ccode\u003ecommunity\u003c\/code\u003e, \u003ccode\u003eurl\u003c\/code\u003e, \u003ccode\u003eisOpportunity\u003c\/code\u003e, \u003ccode\u003eopportunityScore\u003c\/code\u003e, \u003ccode\u003eproblem\u003c\/code\u003e, \u003ccode\u003esolutionIdea\u003c\/code\u003e, \u003ccode\u003ewhyPeoplePay\u003c\/code\u003e, \u003ccode\u003eevidence\u003c\/code\u003e, \u003ccode\u003ecategory\u003c\/code\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45945712017587,"sku":"N8N-19088","price":28.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/R5Aj5nNnpmvTc86_Pg1Oc_qlD2jf9X.png?v=1788426699","url":"https:\/\/buyflowscripts.com\/products\/find-startup-opportunities-from-reddit-with-apify-gemini-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}