Build a labeled Reddit opinion dataset with Apify, OpenAI, and Supabase
UnknownUnknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 16 nodes and runs on a schedule (every week at 08:00). Along the way it connects Supabase, Supabase Vector Store, Embeddings OpenAI and OpenAI and 1 more.
How it runs
Trigger: On a schedule (every week at 08:00).
- Set Reddit Dataset Inputs (Edit Fields (Set)): sets 5 fields: subreddits, sort, timeFilter…
- Generate Subreddit List Code (Code): runs custom JavaScript code
- Scrape Subreddits via Apify (Apify): run actor and get dataset
- Generate Post Rows (Code): runs custom JavaScript code
- Generate Comment Rows (Code): runs custom JavaScript code
- Insert Post into Supabase (Supabase): uses Supabase
- OpenAI: uses OpenAI
- Embed Post to Supabase (Supabase Vector Store): stores documents in the Supabase vector store, with embeddings: OpenAI Post Embeddings Model; document loader: Load Post Document
- Prepare Comment for Insertion (Code): runs custom JavaScript code
- Insert Comment into Supabase (Supabase): uses Supabase
…plus 1 more step. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that @apify/n8n-nodes-apify is verified or supports 3.0 (used in Scrape Subreddits via Apify).
Nodes used (9)
- Edit Fields (Set)
n8n-nodes-base.set - Apify
@apify/n8n-nodes-apify.apify - Code
n8n-nodes-base.code - Supabase
n8n-nodes-base.supabase - Supabase Vector Store
@n8n/n8n-nodes-langchain.vectorStoreSupabase - Embeddings OpenAI
@n8n/n8n-nodes-langchain.embeddingsOpenAi - Default Data Loader
@n8n/n8n-nodes-langchain.documentDefaultDataLoader - OpenAI
@n8n/n8n-nodes-langchain.openAi - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
Quick overview This workflow runs weekly to scrape Reddit posts and comments via Apify, labels each comment’s reaction type with OpenAI, and stores structured rows plus OpenAI embeddings in Supabase tables for analysis and vector search. How it works 1. Runs…