Apify + Gemini Reddit Buyer Intent to Google Sheets (n8n)

Turn high-intent Reddit buyer signals into a Google Sheets lead list—automatically

This n8n workflow uses Apify to scrape recent Reddit posts, then leverages Google Gemini to identify “buyer intent” opportunities and records only the best matches in Google Sheets—deduplicated and ready for action.

What this workflow does

• Runs daily at 09:00 using an n8n schedule trigger.
• Uses Apify’s “Reddit Scraper - Posts, Comments, Search & Subreddits (harshmaur/reddit-scraper)” actor to search Reddit for posts matching predefined “need/looking for/alternative” style search terms.
• Normalizes and deduplicates each post to key fields: id, title, body, subreddit, and url, removing posts already seen in previous executions.
• Filters likely junk by excluding promotional content, hiring/threads, fiction, and posts that are too short—keeping problem/solution-seeking signals.
• Sends the remaining posts to Google Gemini (PaLM) to return a `JSON` array containing only opportunities with an intent score (75–100) plus structured fields such as problem, evidence, and solution idea.
• Parses and verifies Gemini’s response, then appends or updates matching rows in your target Google Sheet (including columns such as id, title, community, url, isOpportu).

Use cases

• Monitor Reddit for SaaS/tech alternatives and capture high-intent threads as leads in Google Sheets.
• Feed marketing, sales, or product teams a daily pipeline of “problem-first” community signals.
• Maintain an always-current spreadsheet of deduplicated Reddit opportunities scored by Gemini.

Technical details

• Nodes/Modules: schedule trigger, Apify (apify-n8n-nodes-apify), code, filter, sticky note, Google Sheets.
• Integrations: Apify OAuth2 connection, Google Gemini (PaLM) API credential, and Google Sheets OAuth2 with your spreadsheet ID and sheet name.