Webhook and Reddit integration

Reddit Posts & Comments Scraper A powerful workflow to scrape Reddit posts and comments by keywords and/or subreddit, with intelligent filtering and formatting. How it works Search Reddit - Accepts keywords and/or subreddit parameters via webhook to search for relevant posts Filter & Sort - Filters posts by date (last 60 days), minimum upvotes (20+), removes duplicates, and sorts by popularity Extract Comments - For each post, retrieves and extracts the top 20 most upvoted comments with their reply threads Format Results - Structures all posts and comments into a clean, readable markdown report Return Data - Sends the formatted report back as a webhook response, ready for use in AI tools or other applications Set up steps Time to set up: ~10 minutes Create Reddit App (5 minutes) Go to https://www.reddit.com/prefs/apps and create a new app Add your n8n URL and callback URL in the "redirect uri" field (you'll find this in the Reddit OAuth2 credentials setup in n8n) Copy your app's Client ID and Client Secret Configure Reddit Credentials in n8n (2 minutes) In n8n, create new Reddit OAuth2 API credentials Paste your Client ID and Client Secret from step 1 Complete the OAuth2 authentication flow Update Webhook URLs (2 minutes) Update the webhook URLs in the example HTTP request nodes to match your n8n instance URL The workflow has two webhooks: /webhook/reddit-search-keyword - for searching by keywords only /webhook/reddit-search-subreddit - for searching within a specific subreddit Customize Filters (1 minute - optional) Date filter**: Line 6 in "Posted in Last x days" node (default: 60 days) Upvote filter**: "Upvotes Requirement Filtering" node (default: 20+ upvotes) Post limit**: "Limit" node (default: 10 posts) Test the Workflow Use the example HTTP request nodes to test both search methods: Keywords only: ?keywords=your,keywords,here Subreddit search: ?keywords=your,keywords&subreddit=SubredditName Usage Examples Search by keywords: GET https://your-n8n.com/webhook/reddit-search-keyword?keywords=AI,machine learning Search within subreddit: GET https://your-n8n.com/webhook/reddit-search-subreddit?keywords=ChatGPT,GPT-4&subreddit=OpenAI The workflow returns a formatted text report with all posts, their metadata, and top comments ready for analysis or AI processing.

Reddit Sentiment Analysis with AI-Powered Insights Automatically analyze Reddit posts and comments to extract sentiment, emotional tone, and actionable community insights using AI. This powerful n8n workflow combines Reddit's API with advanced AI sentiment analysis to help community managers, researchers, and businesses understand public opinion and engagement patterns on Reddit. Get structured insights including sentiment scores, toxicity levels, trending concerns, and moderation recommendations. Features Comprehensive Sentiment Analysis**: Categorizes content as Positive, Negative, or Neutral with confidence scores Emotional Intelligence**: Detects emotional tones like excitement, frustration, concern, or sarcasm Content Categorization**: Identifies discussion types (questions, complaints, praise, debates) Toxicity Detection**: Flags potentially harmful content with severity levels Community Insights**: Analyzes engagement quality and trending concerns Actionable Intelligence**: Provides moderation recommendations and response urgency levels Batch Processing**: Efficiently processes multiple posts and their comments Structured JSON Output**: Returns organized data ready for further analysis or integration How It Works The workflow follows a two-stage process: Data Collection: Fetches recent posts from specified subreddits along with their comments AI Analysis: Processes content through DeepSeek AI to generate comprehensive sentiment and contextual insights Use Cases Community Management**: Monitor sentiment trends and identify posts requiring moderator attention Brand Monitoring**: Track public opinion about your products or services on Reddit Market Research**: Understand customer sentiment and concerns in relevant communities Content Strategy**: Identify what type of content resonates positively with your audience Crisis Management**: Quickly detect and respond to negative sentiment spikes Required Credentials Before setting up this workflow, you'll need to obtain the following credentials: Reddit OAuth2 API Go to Reddit App Preferences Click "Create App" or "Create Another App" Choose "web app" as the app type Fill in the required fields: Name: Your app name Description: Brief description of your app Redirect URI: http://localhost:8080/oauth/callback (or your n8n instance URL + /oauth/callback) Note down your Client ID and Client Secret OpenRouter API Visit OpenRouter Sign up for an account Navigate to your API Keys section Generate a new API key Copy the API key for use in n8n Step-by-Step Setup Instructions Step 1: Import the Workflow Copy the workflow JSON from this template In your n8n instance, click the "+" button to create a new workflow Select "Import from URL" or "Import from Clipboard" Paste the workflow JSON and click "Import" Step 2: Configure Reddit Credentials Click on any Reddit node (e.g., "Get many posts") In the credentials dropdown, click "Create New" Select "Reddit OAuth2 API" Enter your Reddit app credentials: Client ID: Your Reddit app client ID Client Secret: Your Reddit app client secret Auth URI: https://www.reddit.com/api/v1/authorize Access Token URI: https://www.reddit.com/api/v1/access_token Click "Connect my account" and authorize the app Save the credentials Step 3: Configure OpenRouter Credentials Click on the "OpenRouter Chat Model1" node In the credentials dropdown, click "Create New" Select "OpenRouter API" Enter your OpenRouter API key Save the credentials Step 4: Test the Webhook Click on the "Webhook" node Copy the webhook URL (it will look like: https://your-n8n-instance.com/webhook/reddit-sentiment) Test the webhook using a tool like Postman or curl with this sample payload: { "subreddit": "technology", "query": "AI", "limit": 5 } Step 5: Customize the Analysis Modify the Structured Data Generator prompt: Edit the prompt in the "Structured Data Generator" node to adjust the analysis criteria or output format Change the AI model: In the "OpenRouter Chat Model1" node, you can switch to different models like anthropic/claude-3-haiku or openai/gpt-4 based on your preferences and budget Adjust post limits: Modify the limit parameter in the "Get many posts" and "Get many comments in a post" nodes to control how much data you process Usage Instructions Making API Calls Send a POST request to your webhook URL with the following parameters: Required Parameters: subreddit: The subreddit name (without r/) limit: Number of posts to analyze (recommended: 5-15) Optional Parameters: query: Search term to filter posts (optional) Example Request: curl -X POST https://your-n8n-instance.com/webhook/reddit-sentiment \ -H "Content-Type: application/json" \ -d '{ "subreddit": "CustomerService", "limit": 10 }' Understanding the Output The workflow returns a JSON array with detailed analysis for each post: [ { "sentiment_analysis": { "overall_sentiment": { "category": "Negative", "confidence_score": 8 }, "emotional_tone": ["frustrated", "concerned"], "intensity_level": "High" }, "content_categorization": { "discussion_type": "Complaint", "key_themes": ["billing issues", "customer support"], "toxicity_level": { "level": "Low", "indicators": "No offensive language detected" } }, "contextual_insights": { "community_engagement_quality": "Constructive", "potential_issues_flagged": ["service disruption"], "trending_concerns": ["response time", "resolution process"] }, "actionable_intelligence": { "moderator_attention_needed": { "required": "Yes", "reason": "Customer complaint requiring company response" }, "response_urgency": "High", "suggested_follow_up_actions": [ "Escalate to customer service team", "Monitor for similar complaints" ] } } ] Workflow Nodes Explanation Data Collection Nodes Webhook**: Receives API requests with subreddit and analysis parameters Get many posts**: Fetches recent posts from the specified subreddit Split Out**: Processes individual posts for analysis Get many comments in a post**: Retrieves comments for each post Processing Nodes Loop Over Items**: Manages batch processing of multiple posts Sentiment Analyzer**: Primary AI analysis node that processes content Structured Data Generator**: Formats AI output into structured JSON Code**: Parses and cleans the AI response Respond to Webhook**: Returns the final analysis results Customization Options Adjusting Analysis Depth Modify the limit parameters to analyze more or fewer posts/comments Update the AI prompts to focus on specific aspects (e.g., product mentions, competitor analysis) Adding Data Storage Connect database nodes to store analysis results for historical tracking Add email notifications for high-priority findings Integrating with Other Tools Connect to Slack/Discord for real-time alerts Link to Google Sheets for easy data visualization Integrate with CRM systems for customer feedback tracking Tips for Best Results Choose Relevant Subreddits: Focus on communities where your target audience is active Monitor Regularly: Set up scheduled executions to track sentiment trends over time Customize Prompts: Tailor the AI prompts to your specific industry or use case Respect Rate Limits: Reddit API has rate limits, so avoid excessive requests Review AI Output: Periodically check the AI analysis accuracy and adjust prompts as needed Troubleshooting Common Issues "Reddit API Authentication Failed" Verify your Reddit app credentials are correct Ensure your redirect URI matches your n8n instance Check that your Reddit app is set as "web app" type "OpenRouter API Error" Confirm your API key is valid and has sufficient credits Check that the selected model is available Verify your account has access to the chosen model "Webhook Not Responding" Ensure the workflow is activated Check that the webhook URL is correct Verify the request payload format matches the expected structure "AI Analysis Returns Errors" Review the prompt formatting in the Structured Data Generator Check if the selected AI model supports the required features Ensure the input data is not empty or malformed Performance Considerations Rate Limits**: Reddit allows 60 requests per minute for OAuth applications AI Costs**: Monitor your OpenRouter usage to manage costs Processing Time**: Larger batches will take longer to process Memory Usage**: Consider n8n instance resources when processing large datasets Contributing This workflow can be extended and improved. Consider adding: Support for multiple subreddits in a single request Historical sentiment tracking and trend analysis Integration with visualization tools Custom classification models for industry-specific analysis Ready to start analyzing Reddit sentiment? Import this workflow and start gaining valuable insights into online community discussions!