{"product_id":"monetizable-reddit-problem-finder-apify-gemini-google-sheets-n8n","title":"Monetizable Reddit Problem Finder: Apify + Gemini + Google Sheets (n8n)","description":"\u003ch3\u003eFind Monetizable Software Problems on Reddit—Automatically (Apify + Gemini + Google Sheets in n8n)\u003c\/h3\u003e\n\u003cp\u003eThis 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.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a schedule:\u003c\/strong\u003e executes daily at \u003cstrong\u003e9:00\u003c\/strong\u003e via the \u003cstrong\u003eSchedule Trigger\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScrapes Reddit with Apify:\u003c\/strong\u003e uses \u003cstrong\u003eApify’s Reddit Scraper actor\u003c\/strong\u003e to search recent posts (last day, sorted by \u003cem\u003enew\u003c\/em\u003e) using predefined problem-oriented search terms.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes and deduplicates results:\u003c\/strong\u003e cleans scraped content into a consistent structure (id, title, body, subreddit, URL) and removes posts already seen in previous executions.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePre-filters for real “problem\/pain” signals:\u003c\/strong\u003e rejects obvious promotions, hiring\/megathreads, low-text posts, and keeps only items that show strong problem intent.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalls Google Gemini for opportunity scoring:\u003c\/strong\u003e sends the remaining posts to \u003cstrong\u003eGemini\u003c\/strong\u003e to select only opportunities with an \u003cstrong\u003eopportunityScore of 75+\u003c\/strong\u003e, returning a \u003cstrong\u003estrict JSON array\u003c\/strong\u003e with evidence, problem, and solution hypotheses.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWrites to Google Sheets:\u003c\/strong\u003e parses Gemini’s JSON, filters to keep only \u003cstrong\u003eopportunityScore ≥ 75\u003c\/strong\u003e, and appends\/updates rows keyed by the \u003cstrong\u003eReddit post ID\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 new product ideas from real customer pain on Reddit.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAutomation engineers\u003c\/strong\u003e building an n8n workflow that combines Apify scraping + Gemini analysis + Google Sheets reporting.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFounders and marketers\u003c\/strong\u003e maintaining a living pipeline of “monetizable problem” leads.\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 \u003cem\u003eSchedule Trigger\u003c\/em\u003e, \u003cem\u003eApify\u003c\/em\u003e (apifyn8n-nodes-apify), \u003cem\u003eCode\u003c\/em\u003e, \u003cem\u003eFilter\u003c\/em\u003e, \u003cem\u003eGoogle Sheets\u003c\/em\u003e, plus workflow notes via \u003cem\u003eSticky Note\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Apify Reddit Scraper actor, \u003cstrong\u003eGoogle Gemini (PaLM)\u003c\/strong\u003e, and \u003cstrong\u003eGoogle Sheets OAuth2\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup:\u003c\/strong\u003e connect Apify credentials, add a Google Gemini API credential, set your Google Sheets \u003cstrong\u003esheet tab\u003c\/strong\u003e and replace \u003cstrong\u003eYOUR_GOOGLE_SHEET_ID\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45950227153075,"sku":"N8N-19131","price":65.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/2smO2d5-MlLE2mf5SjDBn_sSabK2uk.png?v=1788514054","url":"https:\/\/buyflowscripts.com\/products\/monetizable-reddit-problem-finder-apify-gemini-google-sheets-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}