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: json { "redditid": "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", "postdate": "original post creation date", "upvotes": "number of upvotes", "numcomments": "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