{"product_id":"apify-gemini-reddit-buyer-intent-to-google-sheets-n8n","title":"Apify + Gemini Reddit Buyer Intent to Google Sheets (n8n)","description":"\u003ch3\u003eTurn high-intent Reddit buyer signals into a Google Sheets lead list—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow uses \u003cstrong\u003eApify\u003c\/strong\u003e to scrape recent Reddit posts, then leverages \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to identify “buyer intent” opportunities and records only the best matches in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e—deduplicated and ready for action.\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 an n8n schedule trigger.\u003c\/li\u003e\n  \u003cli\u003eUses \u003cstrong\u003eApify’s “Reddit Scraper - Posts, Comments, Search \u0026amp; Subreddits (harshmaur\/reddit-scraper)”\u003c\/strong\u003e actor to search Reddit for posts matching predefined “\u003cem\u003eneed\/looking for\/alternative\u003c\/em\u003e” style search terms.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes and deduplicates\u003c\/strong\u003e each post to key fields: \u003cem\u003eid\u003c\/em\u003e, \u003cem\u003etitle\u003c\/em\u003e, \u003cem\u003ebody\u003c\/em\u003e, \u003cem\u003esubreddit\u003c\/em\u003e, and \u003cem\u003eurl\u003c\/em\u003e, removing posts already seen in previous executions.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters likely junk\u003c\/strong\u003e by excluding promotional content, hiring\/threads, fiction, and posts that are too short—keeping problem\/solution-seeking signals.\u003c\/li\u003e\n  \u003cli\u003eSends the remaining posts to \u003cstrong\u003eGoogle Gemini (PaLM)\u003c\/strong\u003e to return a `JSON` array containing only opportunities with an \u003cstrong\u003eintent score (75–100)\u003c\/strong\u003e plus structured fields such as \u003cem\u003eproblem, evidence, and solution idea\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eParses and verifies\u003c\/strong\u003e Gemini’s response, then \u003cstrong\u003eappends or updates\u003c\/strong\u003e matching rows in your target Google Sheet (including columns such as \u003cem\u003eid, title, community, url, isOpportu\u003c\/em\u003e).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eMonitor Reddit for SaaS\/tech alternatives and capture high-intent threads as leads in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eFeed marketing, sales, or product teams a daily pipeline of “problem-first” community signals.\u003c\/li\u003e\n  \u003cli\u003eMaintain an always-current spreadsheet of deduplicated Reddit opportunities scored by Gemini.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes\/Modules:\u003c\/strong\u003e schedule trigger, Apify (apify-n8n-nodes-apify), code, filter, sticky note, Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e \u003cstrong\u003eApify OAuth2\u003c\/strong\u003e connection, \u003cstrong\u003eGoogle Gemini (PaLM)\u003c\/strong\u003e API credential, and \u003cstrong\u003eGoogle Sheets OAuth2\u003c\/strong\u003e with your spreadsheet ID and sheet name.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45949960585395,"sku":"N8N-19185","price":64.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/lCkpJImBlZD1FMnKl_QYq_WWBcFKxI.png?v=1788512583","url":"https:\/\/buyflowscripts.com\/products\/apify-gemini-reddit-buyer-intent-to-google-sheets-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}