Workflow function to summarize Reddit posts using Google Gemini and Supabase

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