Automatic Weekly Digital PR Stories Suggestions with Reddit and Anthropic

Published 3 days ago

Created by

Template description

Introduction

The "Automatic Weekly Digital PR Stories Suggestions" workflow is a sophisticated automated system designed to identify trending news stories on Reddit, analyze public sentiment through comment analysis, extract key information from source articles, and generate strategic angles for potential digital PR campaigns.

This workflow leverages the power of social media trends, natural language processing, and AI-driven analysis to deliver curated, sentiment-analyzed news opportunities for PR professionals.

Operating on a weekly schedule, the workflow searches Reddit for posts related to specified topics, filters them based on engagement metrics, and performs a deep analysis of both the content and public reaction.

It then generates comprehensive reports that include story opportunities, audience insights, and strategic recommendations. These reports are automatically compiled, stored in Google Drive, and shared with team members via Mattermost for immediate collaboration.

This workflow solves the time-consuming process of manually monitoring social media for trending stories, analyzing public sentiment, and identifying PR opportunities.

By automating these tasks, PR professionals can focus on strategy development and execution rather than spending hours on research and analysis.

Who is this for?

This workflow is designed for digital PR professionals, content marketers, communications teams, and media relations specialists who need to stay on top of trending stories and public sentiment to develop timely and effective PR campaigns. It's particularly valuable for:

PR agencies managing multiple clients across different industries
In-house PR teams needing to identify media opportunities quickly
Content marketers looking for trending topics to create timely content
Communications professionals monitoring public perception of industry news

Users should have basic familiarity with n8n workflows and the PR strategy development process. While technical knowledge of the integrated APIs is not required to use the workflow, some understanding of Reddit, sentiment analysis, and PR campaign development would be beneficial for interpreting and acting on the generated reports.

What problem is this workflow solving?

Digital PR professionals face several challenges that this workflow addresses:

Information Overload: Manually monitoring social media platforms for trending stories is time-consuming and often results in missed opportunities.
Sentiment Analysis Complexity: Understanding public perception of news stories requires reading through hundreds of comments and identifying patterns, which is labor-intensive and subjective.
Content Extraction: Visiting multiple news sources to read and analyze articles takes significant time.
Strategic Angle Development: Identifying unique PR angles that leverage trending stories and public sentiment requires synthesizing large amounts of information.
Team Collaboration: Sharing findings and insights with team members in a structured format can be cumbersome.

By automating these processes, the workflow enables PR professionals to quickly identify trending stories with PR potential, understand public sentiment, and develop strategic angles based on comprehensive analysis, all while maintaining a structured approach to team collaboration.

What this workflow does

Overview

The workflow automatically identifies trending posts on Reddit related to specified topics, analyzes both the content of linked articles and public sentiment from comments, and generates comprehensive PR strategy reports. These reports include story opportunities, audience insights, and strategic recommendations based on the analysis. The final reports are compiled, stored in Google Drive, and shared with team members via Mattermost.

Process

Topic Selection and Reddit Search:
- The workflow starts with a list of topics specified in the "Set Data" node
- It searches Reddit for posts related to these topics
- Posts are filtered based on upvotes and other criteria to focus on trending content
Comment Analysis:
- For each post, the workflow retrieves comments
- It extracts the top 30 comments based on score
- Using Claude AI, it analyzes the comments to understand:
  - Overall sentiment
  - Dominant narratives
  - Audience insights
  - PR implications
Content Analysis:
- The workflow extracts the content of the linked article using Jina AI
- It analyzes the content to identify:
  - Core story elements
  - Technical aspects
  - Narrative opportunities
  - Viral elements
PR Strategy Development:
- Based on the combined analysis of comments and content, the workflow generates:
  - First-mover story opportunities
  - Trend-amplifier story ideas
  - Priority rankings
  - Execution roadmap
  - Strategic recommendations
Report Generation and Distribution:
- The workflow compiles comprehensive reports for each post
- Reports are converted to text files
- All files are compressed into a ZIP archive
- The archive is uploaded to Google Drive
- A link to the archive is shared with team members via Mattermost

Setup

To set up this workflow, follow these steps:

Import the Workflow:
- Download the workflow JSON file
- Import it into your n8n instance
Configure API Credentials:
- Reddit: Add a new credential "Reddit OAuth2 API" by following the guide at https://docs.n8n.io/integrations/builtin/credentials/reddit/
- Anthropic: Add a new credential "Anthropic Account" by following the guide at https://docs.n8n.io/integrations/builtin/credentials/anthropic/
- Google Drive: Add a new credential "Google Drive OAuth2 API" by following the guide at https://docs.n8n.io/integrations/builtin/credentials/google/oauth-single-service/
Configure the "Set Data" Node:
- Set your interested topics (one per line)
- Add your Jina API key (obtain from https://jina.ai/api-dashboard/key-manager)
Configure the Mattermost Node:
- Update your Mattermost instance URL
- Set your Webhook ID and Channel
- Follow the guide at https://developers.mattermost.com/integrate/webhooks/incoming/ for webhook setup
Adjust the Schedule (Optional):
- The workflow is set to run every Monday at 6am
- Modify the "Schedule Trigger" node if you need a different schedule
Test the Workflow:
- Run the workflow manually to ensure all connections are working properly
- Check the output to verify the reports are being generated correctly

How to customize this workflow to your needs

This workflow can be customized in several ways to better suit your specific requirements:

Topic Selection:
- Modify the topics in the "Set Data" node to focus on industries or subjects relevant to your PR strategy
- Add multiple topics to cover different client interests or market segments
Filtering Criteria:
- Adjust the "Upvotes Requirement Filtering" node to change the minimum upvotes threshold
- Modify the filtering conditions to include or exclude certain types of posts
Analysis Parameters:
- Customize the prompts in the "Comments Analysis," "News Analysis," and "Stories Report" nodes to focus on specific aspects of the content or comments
- Adjust the temperature settings in the Anthropic Chat Model nodes to control the creativity of the AI responses
Report Format:
- Modify the "Set Final Report" node to change the structure or content of the final reports
- Add or remove sections based on your specific reporting needs
Distribution Method:
- Replace or supplement the Mattermost notification with email notifications, Slack messages, or other communication channels
- Add additional storage options beyond Google Drive
Schedule Frequency:
- Change the "Schedule Trigger" node to run the workflow more or less frequently
- Set up multiple triggers for different topics or clients
Integration with Other Systems:
- Add nodes to integrate with your CRM, content management system, or project management tools
- Create connections to automatically populate content calendars or task management systems

Share Template

More AI workflow templates

AI agent chat

This workflow employs OpenAI's language models and SerpAPI to create a responsive, intelligent conversational agent. It comes equipped with manual chat triggers and memory buffer capabilities to ensure seamless interactions. To use this template, you need to be on n8n version 1.50.0 or later.

n8n Team

Scrape and summarize webpages with AI

This workflow integrates both web scraping and NLP functionalities. It uses HTML parsing to extract links, HTTP requests to fetch essay content, and AI-based summarization using GPT-4o. It's an excellent example of an end-to-end automated task that is not only efficient but also provides real value by summarizing valuable content. Note that to use this template, you need to be on n8n version 1.50.0 or later.

n8n Team

Building Your First WhatsApp Chatbot

This n8n template builds a simple WhatsApp chabot acting as a Sales Agent. The Agent is backed by a product catalog vector store to better answer user's questions. This template is intended to help introduce n8n users interested in building with WhatsApp. How it works This template is in 2 parts: creating the product catalog vector store and building the WhatsApp AI chatbot. A product brochure is imported via HTTP request node and its text contents extracted. The text contents are then uploaded to the in-memory vector store to build a knowledgebase for the chatbot. A WhatsApp trigger is used to capture messages from customers where non-text messages are filtered out. The customer's message is sent to the AI Agent which queries the product catalogue using the vector store tool. The Agent's response is sent back to the user via the WhatsApp node. How to use Once you've setup and configured your WhatsApp account and credentials First, populate the vector store by clicking the "Test Workflow" button. Next, activate the workflow to enable the WhatsApp chatbot. Message your designated WhatsApp number and you should receive a message from the AI sales agent. Tweak datasource and behaviour as required. Requirements WhatsApp Business Account OpenAI for LLM Customising this workflow Upgrade the vector store to Qdrant for persistance and production use-cases. Handle different WhatsApp message types for a more rich and engaging experience for customers.

Jimleuk

AI agent that can scrape webpages

⚙️🛠️🚀🤖🦾 This template is a PoC of a ReAct AI Agent capable of fetching random pages (not only Wikipedia or Google search results). On the top part there's a manual chat node connected to a LangChain ReAct Agent. The agent has access to a workflow tool for getting page content. The page content extraction starts with converting query parameters into a JSON object. There are 3 pre-defined parameters: url** – an address of the page to fetch method** = full / simplified maxlimit** - maximum length for the final page. For longer pages an error message is returned back to the agent Page content fetching is a multistep process: An HTTP Request mode tries to get the page content. If the page content was successfuly retrieved, a series of post-processing begin: Extract HTML BODY; content Remove all unnecessary tags to recude the page size Further eliminate external URLs and IMG scr values (based on the method query parameter) Remaining HTML is converted to Markdown, thus recuding the page lengh even more while preserving the basic page structure The remaining content is sent back to an Agent if it's not too long (maxlimit = 70000 by default, see CONFIG node). NB: You can isolate the HTTP Request part into a separate workflow. Check the Workflow Tool description, it guides the agent to provide a query string with several parameters instead of a JSON object. Please reach out to Eduard is you need further assistance with you n8n workflows and automations! Note that to use this template, you need to be on n8n version 1.19.4 or later.

Eduard

Telegram AI Chatbot

The workflow starts by listening for messages from Telegram users. The message is then processed, and based on its content, different actions are taken. If it's a regular chat message, the workflow generates a response using the OpenAI API and sends it back to the user. If it's a command to create an image, the workflow generates an image using the OpenAI API and sends the image to the user. If the command is unsupported, an error message is sent. Throughout the workflow, there are additional nodes for displaying notes and simulating typing actions.

Eduard

Ask questions about a PDF using AI

The workflow first populates a Pinecone index with vectors from a Bitcoin whitepaper. Then, it waits for a manual chat message. When received, the chat message is turned into a vector and compared to the vectors in Pinecone. The most similar vectors are retrieved and passed to OpenAI for generating a chat response. Note that to use this template, you need to be on n8n version 1.19.4 or later.

David Roberts

More Marketing workflow templates

Scrape business emails from Google Maps without the use of any third party APIs

Who is this template for? This workflow template is designed for sales, marketing, and business development professionals who want a cost-effective and efficient way to generate leads. By leveraging n8n core nodes, it scrapes business emails from Google Maps without relying on third-party APIs or paid services, ensuring there are no additional costs involved. Ideal for small business owners, freelancers, and agencies, this template automates the process of collecting contact information for targeted outreach, making it a powerful tool for anyone looking to scale their lead generation efforts without incurring extra expenses. You can watch the video tutorial here: https://youtu.be/HaiO-UeiKBA How it works This template streamlines email scraping from Google Maps using only n8n core nodes, ensuring a completely free and self-contained solution. Here’s how it operates: Input Queries You provide a list of queries, each consisting of keywords related to the type of business you want to target and the specific region or subregion you’re interested in. Iterates through Queries The workflow processes each query one at a time. For each query, it triggers a sub-workflow dedicated to handling the scraping tasks. Scrapes Google Maps for URLs Using these queries, the workflow scrapes Google Maps to collect URLs of business listings matching the provided criteria. Fetches HTML Content The workflow then fetches the HTML pages of the collected URLs for further processing. Extracts Emails Using a Code Node with custom JavaScript, the workflow runs regular expressions on the HTML content to extract business email addresses. Setup Add Queries: Open the first node, "Run Workflow" and input a list of queries, each containing the business keywords and the target region. Configure the Google Sheets Node: Open the Google Sheets node and select a document and specific sheet where the scraped results will be saved. Run the workflow: Click on "Test workflow" and watch your Google Sheets document gradually receive business email addresses. Customize as Needed: You can adjust the regular expressions in the Code Node to refine the email extraction logic or add logic to extract other kinds of information.

Akram Kadri

OpenAI GPT-3: Company Enrichment from website content

Enrich your company lists with OpenAI GPT-3 ↓ You’ll get valuable information such as: Market (B2B or B2C) Industry Target Audience Value Proposition This will help you to: add more personalization to your outreach make informed decisions about which accounts to target I've made the process easy with an n8n workflow. Here is what it does: Retrieve website URLs from Google Sheets Extract the content for each website Analyze it with GPT-3 Update Google Sheets with GPT-3 data

Lucas Perret

Automated Web Scraping: email a CSV, save to Google Sheets & Microsoft Excel

How it works: The workflow starts by sending a request to a website to retrieve its HTML content. It then parses the HTML extracting the relevant information The extracted data is storted and converted into a CSV file. The CSV file is attached to an email and sent to your specified address. The data is simultaneously saved to both Google Sheets and Microsoft Excel for further analysis or use. Set-up steps: Change the website to scrape in the "Fetch website content" node Configure Microsoft Azure credentials with Microsoft Graph permissions (required for the Save to Microsoft Excel 365 node) Configure Google Cloud credentials with access to Google Drive, Google Sheets and Gmail APIs (the latter is required for the Send CSV via e-mail node).

Mihai Farcas

⚡AI-Powered YouTube Video Summarization & Analysis

-- Disclaimer: This workflow uses a community node and therefore only works for self-hosted n8n users -- Transform YouTube videos into comprehensive summaries and structured analysis instantly. This n8n workflow automatically extracts, processes, and analyzes video transcripts to deliver clear, organized insights without watching the entire video. Time-Saving Features 🚀 Instant Processing Simply provide a YouTube URL and receive a structured summary within seconds, eliminating the need to watch lengthy videos. Perfect for research, learning, or content analysis. 🤖 AI-Powered Analysis Leverages GPT-4o-mini to analyze video transcripts, organizing key concepts and insights into a clear, hierarchical structure with main topics and essential points. Smart Processing Pipeline 📝 Automated Transcript Extraction Supports public YouTube video Handles multiple URL formats Extracts complete video transcripts automatically 🧠 Intelligent Content Organization Breaks down content into main topics Highlights key concepts and terminology Maintains technical accuracy while improving clarity Structures information logically with markdown formatting Perfect For 📚 Researchers & Students Quick comprehension of educational content and lectures without watching entire videos. 💼 Business Professionals Efficient analysis of industry talks, presentations, and training materials. 🎯 Content Creators Rapid research and competitive analysis of video content in your niche. Technical Implementation 🔄 Workflow Components Webhook endpoint for URL submission YouTube API integration for video details Transcript extraction system GPT-4 powered analysis engine Telegram notification system (optional) Transform your video content consumption with an intelligent system that delivers structured, comprehensive summaries while saving hours of viewing time.

Joseph LePage

AI-Powered Social Media Content Generator & Publisher

AI-Powered Social Media Content Generator & Publisher 🚀 This AI-driven n8n workflow automates social media content creation and publishing across LinkedIn, Instagram, Facebook, and Twitter (X). It generates engaging, platform-optimized posts using Google Gemini AI, based on user inputs such as a post title, keywords, and an uploaded image. The workflow ensures seamless content generation and publishing, making it a perfect tool for marketers, business owners, influencers, and content creators. 🌟 Features & Benefits ✅ AI-Generated Social Media Posts – Uses Google Gemini AI to create high-quality, optimized content. ✅ Multi-Platform Support – Automatically generates posts for LinkedIn, Instagram, Facebook, and Twitter (X). ✅ Hashtag & SEO Optimization – Includes trending hashtags to enhance visibility and engagement. ✅ Image Upload & Processing – Allows image uploads for Instagram and Facebook using imgbb and Facebook Graph API. ✅ Automated Publishing – Posts are automatically published on all selected platforms. ✅ Custom Call-to-Action – Each platform's post is optimized with CTAs for better engagement. ✅ User-Friendly Form Submission – Easy-to-use form where users can enter post titles, keywords, links, and images. ✅ Performance Tracking – Provides confirmation and tracking links for published posts. 📌 How It Works 1️⃣ User Submission Form Fill out the form with Post Title, Keywords, and an Optional Link. Upload an image for Instagram & Facebook posts. 2️⃣ AI Content Generation Google Gemini AI generates optimized content for each platform. The AI ensures professional, engaging, and audience-specific content. 3️⃣ Content Review Users review and approve the AI-generated content before publishing. 4️⃣ Automated Publishing Posts are automatically published on LinkedIn, Facebook, Instagram, and Twitter (X). Uses Facebook Graph API, LinkedIn API, Twitter API, and Instagram API. 5️⃣ Post Confirmation & Tracking Get links to track published posts on each platform. 🛠️ Prerequisites Before using this workflow, ensure you have: ✅ n8n Instance (Cloud or Self-Hosted) ✅ Social Media API Credentials (Facebook, Instagram, LinkedIn, Twitter API) ✅ Google Gemini AI API Key ✅ imgbb API Key (for image hosting) 📺 YouTube Video Tutorial 🎥 Watch the step-by-step tutorial on how to set up and use this n8n workflow template: 🔗 YouTube Tutorial - AI-Powered Social Media Posting in n8n 🎯 Use Cases 📌 Marketing Agencies – Automate client content scheduling. 📌 Businesses & Brands – Maintain a consistent brand presence on social media. 📌 Content Creators & Influencers – Generate high-quality posts quickly. 📌 E-commerce & Startups – Promote products and services effortlessly. 📌 Corporate & Enterprise Teams – Streamline internal and external communications. 👨‍💻 Creator Information 👤 Developed by: Amjid Ali 🌐 Website: SyncBricks 📧 Email: info@syncbricks.com 💼 LinkedIn: Amjid Ali 📺 YouTube: SyncBricks 💡 Support & Contributions If you find this workflow helpful, consider supporting my work: 👉 Donate via PayPal For full courses on * AI Automation*, visit: 📚 SyncBricks LMS 📚 AI and Auotmation Course 👉 Get Started with N8N

Amjid Ali

Flux AI Image Generator

Easily generate images with Black Forest's Flux Text-to-Image AI models using Hugging Face’s Inference API. This template serves a webform where you can enter prompts and select predefined visual styles that are customizable with no-code. The workflow integrates seamlessly with Hugging Face's free tier, and it’s easy to modify for any Text-to-Image model that supports API access. Try it Curious what this template does? Try a public version here: https://devrel.app.n8n.cloud/form/flux Set Up Watch this quick set up video 👇 Accounts required Huggingface.co account (free) Cloudflare.com account (free - used for storage; but can be swapped easily e.g. GDrive) Key Features: Text-to-Image Creation**: Generates unique visuals based on your prompt and style. Hugging Face Integration**: Utilizes Hugging Face’s Inference API for reliable image generation. Customizable Visual Styles**: Select from preset styles or easily add your own. Adaptable**: Swap in any Hugging Face Text-to-Image model that supports API calls. Ideal for: Creators**: Rapidly create visuals for projects. Marketers**: Prototype campaign visuals. Developers**: Test different AI image models effortlessly. How It Works: You submit an image prompt via the webform and select a visual style, which appends style instructions to your prompt. The Hugging Face Inference API then generates and returns the image, which gets hosted on Cloudflare S3. The workflow can be easily adjusted to use other models and styles for complete flexibility.

Max Tkacz

Implement complex processes faster with n8n

Get started