đź“Š Workflow function to summarize Reddit posts using Google Gemini and Supabase
⚡ 150 views · 📊 Market Research & Insights
💡 Pro Tip — For competitive intelligence, ScraperNode can automate the data collection — Yelp reviews, Glassdoor company data, and Crunchbase profiles all return structured JSON you can feed straight into this workflow.
Description
Reddit Post Saver & Summarizer with AI-Powered Filtering
Who This Is For
Perfect for content curators, researchers, developers, and community managers who want to build a structured database of valuable Reddit content without manual data entry. If you’re tracking industry trends, gathering user feedback, or building a knowledge base from Reddit discussions, this workflow automates the entire process.
The Problem It Solves
Reddit has incredible discussions, but manually copying posts, extracting insights, and organizing them into a database is time-consuming. This workflow automatically transforms your saved Reddit posts into structured, searchable data—complete with AI-generated summaries of both the post and its comment section.
How It Works
1. Save Posts Manually
Simply use Reddit’s built-in save feature on any post you find valuable.
2. Automated Daily Processing
The workflow triggers once per day and:
- Fetches all your saved Reddit posts via Reddit API
- Filters posts by subreddit and custom conditions (e.g., “only posts about JavaScript frameworks” or “posts with more than 100 upvotes”)
- Uses an LLM (Google Gemini) to verify posts match your natural language criteria
- Generates comprehensive summaries of both the original post and top comments
3. Structured Database Storage
Filtered and summarized posts are automatically saved to your Supabase database with this structure:
{
"reddit_id": "unique post identifier",
"title": "post title",
"url": "direct link to Reddit post",
"summary": "AI-generated summary of post and comments",
"tags": ["array", "of", "relevant", "tags"],
"post_date": "original post creation date",
"upvotes": "number of upvotes",
"num_comments": "total comment count"
}Setup Requirements
- Reddit API credentials (client ID and secret)
- Supabase account with a database table
- Google Gemini API key (or alternative LLM provider)
- Basic configuration of filter conditions (subreddit names and natural language criteria)
Use Cases
- Product Research: Track competitor mentions and feature requests
- Content Creation: Build a library of trending topics in your niche
- Community Management: Monitor feedback across multiple subreddits
- Academic Research: Collect and analyze discussions on specific topics
đź”— Nodes Used
Reddit, Supabase, Schedule Trigger, Basic LLM Chain, Structured Output Parser, Google Gemini Chat Model
đź“Ą Import
Download workflow.json and import into n8n:
Workflow menu → Import from File