{"product_id":"n8n-reddit-dataset-apify-openai-labels-to-supabase","title":"n8n Reddit Dataset: Apify + OpenAI Labels to Supabase","description":"\u003ch3\u003eAutomatically scrape Reddit, label comment reactions with OpenAI, and store searchable data in Supabase\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow runs weekly to pull Reddit posts and comments using Apify, classifies each comment’s reaction type with OpenAI (gpt-4.1-mini), and saves both structured rows and OpenAI embeddings into Supabase for analysis and vector search.\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 (weekly)\u003c\/strong\u003e and accepts dataset inputs such as subreddits, sort order, time window, minimum score, and item limits.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSplits your subreddit plan into scrape jobs\u003c\/strong\u003e and uses the \u003cstrong\u003eApify Reddit Scraper\u003c\/strong\u003e actor to collect posts and their comments.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFormats scraped post data\u003c\/strong\u003e into structured metadata rows and inserts them into the Supabase \u003cstrong\u003eposts\u003c\/strong\u003e table.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates OpenAI embeddings\u003c\/strong\u003e for each post’s combined context text and inserts vectors into the Supabase \u003cstrong\u003edocuments\u003c\/strong\u003e table.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters and formats comments\u003c\/strong\u003e, then uses \u003cstrong\u003eOpenAI (gpt-4.1-mini)\u003c\/strong\u003e to classify each comment into one reaction type.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStores labeled comments\u003c\/strong\u003e in the Supabase \u003cstrong\u003ecomments\u003c\/strong\u003e table and embeds comment text into the Supabase \u003cstrong\u003edocuments\u003c\/strong\u003e table for vector search.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eTrack community sentiment trends across specific subreddits by reaction type over time.\u003c\/li\u003e\n  \u003cli\u003eBuild a retrieval system that answers questions about Reddit threads using Supabase + pgvector embeddings.\u003c\/li\u003e\n  \u003cli\u003eMaintain an analytics-ready dataset of posts\/comments with consistent filtering (min score, time window, limits).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedule Trigger\u003c\/strong\u003e for weekly execution.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify integration\u003c\/strong\u003e via \u003cstrong\u003en8n-nodes-apify\u003c\/strong\u003e (Apify Reddit Scraper actor) using an \u003cstrong\u003eApify API token\u003c\/strong\u003e credential.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI integration\u003c\/strong\u003e using an OpenAI API credential for reaction classification (gpt-4.1-mini) and embeddings.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSupabase integration\u003c\/strong\u003e using a Supabase credential (project URL + service_role key) with \u003cstrong\u003epgvector\u003c\/strong\u003e, storing data in \u003cstrong\u003eposts\u003c\/strong\u003e, \u003cstrong\u003ecomments\u003c\/strong\u003e, and \u003cstrong\u003edocuments\u003c\/strong\u003e tables.\u003c\/li\u003e\n  \u003cli\u003eNodes include: \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, and \u003cstrong\u003esticky note\u003c\/strong\u003e (for workflow documentation).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003eSet your subreddit parameters in the workflow input config and get a structured, labeled, and vector-searchable Reddit dataset in Supabase—ready for n8n-powered automation and downstream analytics.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45887426494643,"sku":"N8N-18578","price":31.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/U1Y1HrdeF_Rqye9eDqohU_lWoBfGx7.png?v=1787475992","url":"https:\/\/buyflowscripts.com\/products\/n8n-reddit-dataset-apify-openai-labels-to-supabase","provider":"N8N Commerce","version":"1.0","type":"link"}