Reddit and Supabase integration

This template gives you a complete, automated system for monitoring Reddit and extracting growth insights. It tracks discussions across target subreddits, surfaces what users love, dislike, want changed, and highlights how they compare you to competitors. Paired with the free WeWeb UI template, it prioritizes engagement and organizes everything into a clean, easy-to-use dashboard. So every team gets the insights they need: Leadership** gains clarity on industry trends and emerging shifts Product** can adjust roadmaps and prioritize features or integrations Marketing** gets content angles, competitive messaging, and SEO topics Sales** receives objection insights straight from real conversations Support** spots early patterns in user challenges 🙌 Who this is for Perfect for product teams, founders, and growth marketers who want to build and scale Reddit as a channel without spending hours manually scanning threads. 💫 What Makes This Different Eliminates manual scanning:** Automatically pull product and competitor mentions using F5Bot for free, without the high cost of traditional monitoring tools. Captures full conversations:** Track not just posts, but the entire comment chain where real insights, objections, and frustrations actually surface. AI-powered prioritization:** Every mention is classified by sentiment and topic so you know what to prioritize and why. Cross-team intelligence:** Highlights product insights, competitor signals, sales objections, user frustrations, and industry trends, helping product, marketing, sales, support, and leadership make more customer-centric decisions. ⚙️ How the Workflow Works A cron job runs every hour and scans your Gmail inbox for new F5Bot alert emails. When an alert is found, the workflow extracts all mention data from the email. An AI node processes each mention to: categorize it by topic tag sentiment All data is stored in Supabase. The data is displayed in a WeWeb dashboard where users can browse mentions. If a user wants deeper context, they click “AI Summary.” This triggers a webhook in n8n, which pulls the main Reddit post and its entire comment chain. The AI node summarizes the full thread and highlights: the core discussion competitor comparisons what users like or dislike industry-level signals The workflow returns a clean, actionable summary back to the WeWeb UI. 🧪 Requirements You don’t need any heavy infrastructure. To get started, you’ll need: F5Bot account (free)** - to track Reddit mentions by keywords and trigger email alerts Gmail integration** - so the workflow can parse emails from F5Bot OpenAI API key** - for AI-powered categorization and summarization Supabase project (free)** - to store all mention data WeWeb account (free)** - connects your n8n workflow to a clean, user-friendly dashboard for viewing insights Here's a detailed setup guide. 🔧 Want to Go Further? This setup is beginner-friendly, but you can extend it with: Blog topic generation Full blog post generation Social media posts Competitor benchmarking reports Weekly or monthly email digests Slack alerts for high-signal mentions

This workflow monitors targeted subreddits for potential sales leads using Reddit’s API, AI content analysis, Supabase, and Google Sheets. It is built specifically to discover posts from Reddit users who may benefit from a particular product or service. It can be easily customized for any market. 🔍 Features Targeted Subreddit Monitoring:** Searches multiple niche subreddits like smallbusiness, startup, sweatystartup, etc., using relevant keywords. AI-Powered Relevance Scoring:** Uses OpenAI GPT to analyze each post and determine if it’s written by someone who might benefit from your product, returning a simple “yes” or “no.” Duplicate Lead Filtering with Supabase:** Ensures you don’t email the same lead more than once by storing already-processed Reddit post IDs in a Supabase table. Content Filtering:** Filters out posts with no body text or no upvotes to ensure only high-quality content is processed. Lead Storage in Google Sheets:** Saves qualified leads into a connected Google Sheet with key data (URL, post content, subreddit, and timestamp). Email Digest Alerts:** Compiles relevant leads and sends a daily digest of matched posts to your team’s inbox for review or outreach. Manual or Scheduled Trigger:** Can be manually triggered or automatically scheduled (via the built-in Schedule Trigger node). ⚙️ Tech Stack Reddit API** – For post discovery OpenAI Chat Model** – For AI-based relevance filtering Supabase** – For lead de-duplication Google Sheets** – For storing lead details Gmail API** – For sending email alerts 🔧 Customization Tips Adjust Audience**: Modify the subreddits and keywords in the initial Code node to match your market. Change the AI Prompt**: Customize the prompt in the “Analysis Content by AI” node to describe your product or service. Search Comments Instead**: To monitor comments instead of posts, change type=link to type=comment in the Reddit Search node. Change Email Recipients**: Edit the Gmail node to direct leads to a different email address or format.

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 Save Posts Manually Simply use Reddit's built-in save feature on any post you find valuable. 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 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