n8n templatesn8n templates

My workflow

This workflow implements automated digital public relations news trend mining and analysis. It can regularly monitor trending topics on Reddit, filter high-quality posts, and capture comments. By utilizing AI language models for sentiment and content analysis, it ultimately generates structured analytical reports, which are stored in Google Drive and communicated to the team via Mattermost, enhancing information delivery efficiency. This system helps the PR team quickly identify hot topics, gain deeper insights into public opinion dynamics, and optimize PR strategies and decision-making.

Workflow Diagram
My workflow Workflow diagram

Workflow Name

My workflow

Key Features and Highlights

This workflow implements an automated Digital PR news trend mining and analysis system. It can automatically monitor trending topics on Reddit, filter high-quality posts, extract and analyze comment content, perform sentiment and in-depth content analysis using AI language models, and ultimately generate structured and insightful PR reports. The workflow also automatically stores analysis reports on Google Drive and sends instant notifications to the team via Mattermost, enabling efficient information delivery and collaboration.

Core Problems Addressed

  • Automatically identify and filter trending discussions on Reddit related to user-specified topics, avoiding the complexity and delays of manual monitoring.
  • Intelligently filter and perform sentiment analysis on massive volumes of comments to uncover genuine user opinions and potential public sentiment risks.
  • Combine news content with social media data to provide precise news trend and PR story insights, supporting the formulation of effective PR strategies.
  • Automatically generate structured analysis reports and enable team sharing to improve information transmission efficiency and decision-making speed.

Application Scenarios

  • Digital PR teams seeking potential news hotspots and topic entry points.
  • Media monitoring and public opinion analysis to quickly capture public sentiment and discussion focal points.
  • Content creators and marketers planning stories with viral potential.
  • Corporate brand management and crisis PR for timely detection of negative discussions and strategy formulation.

Main Process Steps

  1. Scheduled Trigger: Automatically start the workflow every Monday at 6 AM.
  2. Topic Splitting: Split preset focus topics into individual keywords by line.
  3. Reddit Search: Search Reddit site-wide for posts related to keywords, sorted by popularity.
  4. Filtering: Retain only high-quality posts with over 100 upvotes, of link type, excluding specific URLs.
  5. Deduplication: Remove duplicate posts based on post URLs, keeping the highest upvoted ones.
  6. Iterative Processing: Retrieve all comment data for each post one by one.
  7. Comment Extraction: Recursively extract and filter out deleted comments, retaining the top 30 highest-rated comments and their reply trees.
  8. Comment Formatting: Convert comments into Markdown format while preserving hierarchical relationships.
  9. News Content Extraction: Use Jina API to extract the main body content of news articles linked in posts.
  10. AI Analysis:
    • Use Anthropic Claude model to perform multidimensional sentiment and content analysis on comment data.
    • Conduct trend evaluation and social validation analysis by combining news content with Reddit data.
    • Generate a comprehensive news trend analysis report.
  11. Report Integration: Aggregate analysis results to produce a detailed final digital PR story report.
  12. File Generation and Compression: Convert the report into text files and batch compress them into a ZIP archive.
  13. File Upload and Sharing: Automatically upload to a designated Google Drive folder and set public sharing permissions.
  14. Team Notification: Send messages via Mattermost Webhook to notify the team to download the latest report.

Involved Systems and Services

  • Reddit API: To obtain posts and comment data.
  • Jina API: To crawl and extract news webpage main content.
  • Anthropic Claude Model (integrated via n8n’s LangChain node): For natural language processing and sentiment analysis.
  • Google Drive: To store generated report files.
  • Mattermost: For team instant messaging and notification delivery.
  • n8n Automation Platform: For overall workflow orchestration and execution.

Target Users and Value

  • Digital PR Experts and PR Teams: Automatically discover news events and public opinion hotspots, improving work efficiency and response speed.
  • Media Analysts and Content Planners: Gain deep insights into social media discussions to uncover story potential and dissemination paths.
  • Brand Managers and Marketers: Capture public sentiment and key topics to formulate precise communication strategies.
  • Data Analysts and AI Developers: Integrate multi-source data and AI models for efficient public opinion analysis and content insight.

This workflow offers a one-stop solution for digital PR and media monitoring by leveraging automation and intelligent methods that combine social media big data with advanced language model analysis, effectively reducing manual costs and enhancing content insight and dissemination impact.

My workflow