Gmail and Reddit 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

Extract Trends and Auto-Generate Social Media Content with OpenAI, Reddit, and Google Trends: Approve and Post to Instagram, TikTok, and More Description What Problem Does This Solve? 🛠️ This workflow automates trend extraction and social media content creation for businesses and marketers. It eliminates manual trend research and content generation by fetching trends, scoring them with AI, and posting tailored content to multiple platforms. Target audience: Social media managers, digital marketers, and businesses aiming to streamline content strategies. What Does It Do? 🌟 Fetches trending topics from Reddit, X and Google Trends Scores trends for relevance using OpenAI. Generates content for Twitter/X, LinkedIn, Instagram and Facebook Posts to supported platforms Stores results in Google Sheets for tracking Key Features 📋 Real-time trend fetching from Reddit and Google Trends. AI-driven trend scoring and content generation (OpenAI). Automated posting to Twitter/X, LinkedIn, Instagram, and Facebook. Persistent storage in Google Sheets. Setup Instructions Prerequisites ⚙️ n8n Instance**: Self-hosted or cloud n8n instance. API Credentials**: Reddit API: Client ID and secret from Reddit. SerpApi (Google Trends): API key from SerpApi, stored in n8n credentials OpenAI API: API key with GPT model access. Twitter/X API: OAuth 1.0a credentials with write permissions. LinkedIn API: OAuth 2.0 credentials with w_organization_social scope. Instagram/Facebook API: Meta Developer app with posting permissions. Google Sheets API: Credentials from Google Cloud Console. Installation Steps 📦 Import the Workflow: Copy the workflow JSON from the "Template Code" section below. Import it into n8n via "Import from File" or "Import from URL". Configure Credentials: Add API credentials in n8n’s Credentials section for Reddit, SerpApi, OpenAI, Twitter/X, LinkedIn, Instagram/Facebook, and Google Sheets. Assign credentials to respective nodes. For example: In the Fetch Google Trends node (HTTP Request), use n8n credentials for SerpApi instead of hardcoding the API key. Example: Set the API key in n8n credentials as SerpApiKey and reference it in the node’s query parameter: api_key={{ $credentials.SerpApiKey }}. Set Up Google Sheets with the following columns (exact column names are case-sensitive) -Timestamp | Trend | Score | BrandVoice | AudienceMood | Customize Nodes: OpenAI Nodes** (Trend Relevance Scoring, Generate Social Media Content): Update the model (e.g., gpt-4o) and prompt as needed. HTTP Request Nodes** (Post to Twitter/X, Post to LinkedIn, etc.): Verify URLs, authentication, and payloads. Brand Voice/Audience Mood**: Adjust Prepare Trend Scoring Input for your desired brand_voice (e.g., "casual") and audience_mood (e.g., "curious"). Test the Workflow: Fetch Reddit Trends to Store Selected Trends- to score and store trends. Retrieve Latest Trends to end) to generate and post content Check Google Sheets for posting statuses How It Works High-Level Steps 🔍 Fetch Trends**: Pulls trends from Reddit,X and Google Trends. Score Trends**: Uses OpenAI to score trends for relevance. Generate Content**: Creates platform-specific social media content. Post Content**: Posts to LinkedIn, Facebook or X Detailed descriptions are available in the sticky notes within the workflow screenshot above. Node Names and Actions Trend Extraction and Scoring Daily Trigger Idea: Triggers the workflow daily. Set Default Inputs: Sets default brand_voice and inputs. Fetch Reddit Trends: Fetches Reddit posts. Extract Reddit Trends: Extracts trends from Reddit. Fetch Google Trends: Fetches Google Trends via SerpApi. Extract Google Trends2: Processes Google Trends data. Fetch Twitter Mentions: Fetches Twitter mentions. Translate Tweets to English: Translates tweets. Fix Tweet Translation Output: Fixes translation format. Detect Audience Mood: Detects audience mood. Fix Audience Mood Output: Fixes mood output format. Analyze News Sentiment: Analyzes news sentiment. Combine Data (Merge): Merges all data sources. Merge Items into Single Item: Combines data into one item. Combine Trends and UGC: Combines trends with UGC. Prepare Trend Scoring Input: Prepares data for scoring. Trend Relevance Scoring: Scores trends with OpenAI. Parse Trend Scores: Parses scoring output. Store Selected Trends: Stores trends in Google Sheets. Content Generation and Posting Retrieve Latest Trends: Retrieves trends from Google Sheets. Parse Retrieved Trends: Parses retrieved trends. Select Top Trends: Selects the top trend. Generate Social Media Content: Generates platform-specific content. Parse Social Media Content: Parses generated content. Generate Images: Generates images for posts (if applicable). -Handle Approvals/Rejection before Posting Post to Instagram: Posts to Instagram. Post to Facebook: Posts to Facebook. Post to LinkedIn: Posts to LinkedIn. Customization Tips Add Trend Sources** 📡: Include more sources (e.g., Instagram trends) by adding nodes to Combine Data (Merge). Change Content Tone** ✍️: Update the Generate Social Media Content prompt for a different tone (e.g., "humorous"). Adjust Schedule** ⏰: Modify Daily Trigger Idea to run hourly or weekly. Automate TikTok/YouTube** 🎥: Add video generation (e.g., FFMPEG) to post TikTok and YouTube Shorts

Description This workflow provides a powerful AI assistant for content creators, book editors, and marketers. It automates the collection and analysis of trending discussions from Reddit, YouTube, and X (Twitter), generating insightful topic reports. This frees you from hours of tedious data compilation, allowing you to make faster, more accurate topic decisions based on deep AI analysis. How it works This workflow simulates the complete research process of a strategic editor: Initiate & Collect: A user submits a keyword via a public Form Trigger. The workflow then automatically fetches relevant, trending content in parallel from the official APIs of Reddit, YouTube, and X (Twitter). Multi-stage AI Processing & Analysis: The workflow utilizes a layered AI pipeline to process the data. First, a lightweight Gemini model in the AI Pre-filter Content node rapidly screens the vast amount of content to filter out noise. Next, a more powerful Gemini Pro model in the AI Deep Analysis node performs a detailed, structured analysis on each high-value item, extracting summaries, sentiment, and key arguments. Finally, a "strategist" AI model in the AI Synthesize Final Report node aggregates all analyses to generate the comprehensive final topic report in HTML. Multi-Channel Report Distribution: The workflow distributes the final report to multiple channels based on pre-defined templates. The Send Gmail Report node sends the complete HTML report. The Send Feishu Notification node sends a concise summary card to a group chat. Meanwhile, the Archive to Google Sheets node archives key data. Setup Steps This workflow takes approximately 20-30 minutes to set up, with most of the time spent connecting your accounts. Connect Your API Accounts: In the n8n Credentials section, you will need to prepare and connect credentials for the following services: Google: For the Gemini AI model, Gmail sending, and Google Sheets archiving. This requires a Google Cloud API Key and OAuth2 credentials. Reddit: For fetching Reddit posts. This requires a Reddit account with OAuth2 configured in n8n to allow searches. YouTube: For collecting YouTube videos. You'll need to enable the YouTube Data API v3 in your Google Cloud Console and get an API Key. Twitter: For the official Twitter node, requiring a free developer account and an App with v2 API access. Configure Output Channels: In the final nodes (Send Gmail Report, Send Feishu Notification, Archive to Google Sheets), update the recipient email address, the Feishu bot's Webhook URL, and the target spreadsheet ID to match your own. Activate and Share the Trigger: Activate the workflow. The first Form Trigger node will automatically generate a public URL. Share this link with your team members to let them start using the tool.

WATCH THE n8n STARTER GUIDE 👇 This template is featured in the n8n Starter Guide series. The template is free, but comes with two additional PDFs and a Quick Start video if you grab the full download pack on gumroad. How it works This template is a visual map of many useful n8n nodes. It groups nodes like Triggers, AI tools, and App connectors onto the canvas. Explore the sections to learn about different nodes and easily copy them for your own workflows. It acts as a handy visual reference guide. Set up steps • Setup takes about 5 minutes. • Import the template into your n8n instance. • Explore the node categories visually on the canvas. • A Quick Start video is included in the download pack, along with a prompts PDF and PDF with links to other awesome n8n templates here on the n8n template gallery.

Use case Manually monitoring Reddit for viable business ideas is time-consuming and inconsistent. This workflow automatically analyzes trending Reddit discussions using AI to surface high-potential opportunities, filter irrelevant content, and generate actionable insights - saving entrepreneurs 10+ hours weekly in market research. What this workflow does This AI-powered workflow automatically collects trending Reddit discussions, analyzes posts for viable business opportunities using GPT-4, applies smart filters to exclude low-value content, and generates scored opportunity reports with market insights. It identifies unmet customer needs through sentiment analysis, prioritizes high-potential ideas using custom criteria, and outputs structured data to Google Sheets for actionable decision-making. Setup Add Reddit,Google and OpenAI credentials Configure target subreddits in Subreddit node Test workflow by testing workflow Review generated opportunity report in Google Sheets How to adjust this template Change data sources**: Replace Reddit trigger with Twitter/X or Hacker News API Modify criteria**: Adjust scoring thresholds in Opportunity Calculator node Add integrations**: Create automatic Slack alerts for urgent opportunities Generate draft business plans using AI Document Writer

🤖 AI Reddit Scout Agent: Auto Post Analysis & Insights Stay ahead of trends and conversations with this intelligent n8n workflow that automatically monitors Reddit, analyzes discussions using AI, and delivers actionable insights to your team via Slack and Gmail. Perfect for market research, content inspiration, and competitive intelligence. 🔄 How It Works This automated 4-step intelligence gathering system runs daily to keep you informed: Step 1: Scheduled Monitoring The workflow automatically triggers daily (default: 9 AM) to scan Reddit for fresh discussions and trending topics. Step 2: Smart Content Retrieval The Reddit API integration searches specified subreddits using customizable filters: Target subreddits (e.g., r/ChatGPT, r/technology, r/startups) Keyword matching for specific topics Post ranking criteria (hot, top, new) Engagement thresholds (upvotes, comments) Step 3: AI-Powered Analysis Each retrieved post is processed by GPT-4 through a specialized agent that: Extracts key discussion points and themes Classifies topics in 3-5 word categories Generates concise one-sentence summaries Identifies sentiment and engagement patterns Highlights actionable insights and trends Step 4: Multi-Channel Distribution Analyzed insights are automatically delivered to: Slack channels for immediate team visibility Gmail inboxes for stakeholders and decision-makers Formatted with links back to original Reddit discussions ⚙️ Setup Steps Prerequisites Reddit account (for API access) OpenAI API key with GPT-4 access Slack workspace with posting permissions Gmail account for email distribution n8n instance (cloud or self-hosted) Configuration Steps Credential Setup Reddit API: Configure Reddit node with API credentials OpenAI API Key: Required for AI analysis and summarization Slack OAuth2: Connect workspace for channel posting Gmail OAuth2: Enable email distribution functionality Reddit Configuration Subreddit Selection: Define target communities to monitor Professional: r/entrepreneur, r/marketing, r/sales Technology: r/artificial, r/MachineLearning, r/programming Industry-specific: r/fintech, r/biotech, r/startups Search Parameters: Set keywords and filters Keywords: "AI trends", "market analysis", "customer feedback" Time ranges: past day, week, or month Minimum engagement thresholds AI Analysis Customization Default analysis prompt can be tailored for: Market Research Focus: Extract business insights and opportunities Competitive Intelligence: Identify competitor mentions and sentiment Content Ideas: Find trending topics for content creation Customer Research: Analyze user pain points and feedback Distribution Setup Slack Integration: Choose channels for different content types #market-intelligence for business insights #content-ideas for creative inspiration #competitive-intel for competitor discussions Email Configuration: Set recipient lists and formatting preferences Schedule Optimization Frequency: Daily, weekly, or custom intervals Timing: Optimize for team availability and time zones Volume Control: Limit posts per execution to avoid overwhelm 🚀 Use Cases Market Research & Intelligence Trend Identification: Spot emerging technologies and methodologies Customer Sentiment: Monitor brand mentions and user feedback Competitive Analysis: Track competitor discussions and reputation Industry Insights: Stay updated on regulatory changes and news Content Marketing Topic Discovery: Find trending subjects for blog posts and videos Audience Research: Understand community questions and pain points Content Validation: Test ideas before creating full content pieces Engagement Strategies: Learn what resonates with target audiences Product Development Feature Requests: Identify commonly requested functionality User Experience Feedback: Discover usability issues and improvements Market Validation: Gauge interest in new product concepts Beta Testing Insights: Monitor feedback on product releases Sales & Business Development Lead Generation: Find potential customers discussing relevant problems Objection Handling: Understand common concerns and hesitations Partnership Opportunities: Identify potential collaboration prospects Market Education: Understand knowledge gaps in your target market Investment & Strategy Startup Monitoring: Track emerging companies and funding news Technology Assessment: Evaluate new tools and platforms Risk Assessment: Monitor potential threats and challenges Opportunity Identification: Spot underserved markets and niches 🔧 Advanced Customization Options Multi-Subreddit Orchestration Configure different analysis approaches: Technical Communities: Focus on innovation and implementation details Business Communities: Extract market opportunities and strategies User Communities: Emphasize pain points and solution requests News Communities: Highlight breaking developments and reactions Sentiment & Engagement Scoring Enhance analysis with quantitative metrics: Sentiment Analysis: Positive, negative, neutral classification Engagement Prediction: Likelihood of viral content Influence Scoring: Identify high-authority contributors Trend Momentum: Track discussion growth over time Content Filtering & Prioritization Implement smart content curation: Quality Thresholds: Minimum upvotes, comments, or awards Relevance Scoring: AI-based topic matching and ranking Duplicate Detection: Avoid repetitive content in summaries Language Processing: Handle multiple languages and slang Extended Integration Options Connect additional platforms and tools: CRM Integration: Push leads to Salesforce, HubSpot, or Pipedrive Documentation Tools: Save insights to Notion, Obsidian, or Confluence Analytics Platforms: Feed data to Google Analytics or Mixpanel Social Media: Cross-post insights to Twitter, LinkedIn, or Facebook 📊 Output Examples Sample Slack Message: 🔍 Reddit Intelligence Report - r/ChatGPT 📊 Top Discussion: "Why I stopped using ChatGPT for coding" 📝 Topic: AI Tool Limitations & Alternatives 📋 Summary: Users discussing ChatGPT's declining code quality and exploring alternatives like Claude and GitHub Copilot for development work. 📈 Engagement: 847 upvotes, 234 comments 💭 Sentiment: Mixed (concerns about accuracy, praise for alternatives) 🔗 View Discussion: [Reddit Link] Key Insights: Growing demand for specialized coding AI tools Quality consistency remains a major user concern Opportunity for developer-focused AI solutions Generated at 9:15 AM • Next scan: Tomorrow 9:00 AM Gmail Report Format: Subject: Daily Reddit Intelligence - AI & Technology Trends 📡 REDDIT SCOUT REPORT Date: March 15, 2024 🎯 TOP INSIGHTS TODAY: AI Development Tools (r/programming) Discussion: "Best AI coding assistants in 2024" Insight: Developers increasingly comparing specialized tools vs general AI Engagement: High (500+ upvotes) Startup Funding (r/entrepreneur) Discussion: "Raised $2M seed round - lessons learned" Insight: Current funding landscape and investor priorities Engagement: Moderate (150+ upvotes) Customer Feedback (r/SaaS) Discussion: "Why our churn rate dropped 40%" Insight: Onboarding and support strategy impacts Engagement: High (300+ upvotes) 🔗 View all discussions: [Links included] Powered by AI Reddit Scout Agent Next report: Tomorrow at 9:00 AM 🛠️ Troubleshooting & Best Practices Common Issues & Solutions API Rate Limiting Implement exponential backoff delays Distribute requests across multiple time periods Cache results to minimize redundant calls Monitor Reddit API status and limits Content Quality Control Set minimum engagement thresholds Filter out low-quality or spam posts Implement keyword blacklists for irrelevant content Regular prompt tuning for better AI analysis Information Overwhelm Limit posts per subreddit per day Prioritize by engagement and relevance scores Create digest formats for high-volume periods Allow team members to customize their alerts Optimization Strategies Performance Enhancement Use parallel processing for multiple subreddits Implement caching for repeated analysis Optimize OpenAI prompt length and complexity Monitor and optimize workflow execution time Cost Management Balance AI analysis depth with API costs Use different models for different content types Implement smart filtering before AI analysis Track ROI through engagement metrics Team Adoption Start with pilot programs in specific departments Provide training on interpreting AI insights Create feedback loops for continuous improvement Establish clear action protocols for different insight types 📈 Success Metrics Intelligence Quality Indicators Relevance Score: Percentage of insights that lead to action Timeliness: How quickly trends are identified vs competitors Accuracy: Validation of AI predictions against actual outcomes Engagement: Team interaction with distributed insights Business Impact Measurements Content Performance: Improvement in content engagement rates Market Timing: Success rate of trend-based decisions Competitive Advantage: Early identification of opportunities/threats Time Savings: Reduction in manual research and monitoring time 📞 Questions & Support Need assistance with your AI Reddit Scout Agent setup or customization? 📧 Technical Support Email: [email protected] Response Time: Within 24 hours on business days Expertise: Reddit API integration, AI prompt optimization, workflow scaling 🎥 Learning Resources YouTube Channel: https://www.youtube.com/@YaronBeen/videos Complete setup and configuration guides Advanced filtering and analysis techniques Integration tutorials for popular business tools Troubleshooting common issues 🤝 Professional Networking LinkedIn: https://www.linkedin.com/in/yaronbeen/ Connect for ongoing automation support Share your intelligence gathering success stories Access to exclusive workflow templates and updates 💬 Support Request Guidelines Include in your message: Target subreddits and use cases Current team size and distribution needs Specific industries or topics of interest Integration requirements with existing tools Any error messages or unexpected behaviors