My workflow - N8N Workflow Directory

Target Audience

Digital PR Professionals: Those looking to identify trending news and leverage social media insights for PR campaigns.
- Social Media Analysts: Individuals who analyze online discussions to gauge public sentiment and engagement.
- Content Creators: Writers and marketers aiming to generate content based on real-time trends and audience interests.
- Data-Driven Decision Makers: Professionals who rely on data analysis to inform their strategies and campaigns.
- Organizations Seeking Reputation Management: Companies wanting to monitor and respond to public sentiment effectively.

Problem Solved

This workflow addresses the challenge of identifying relevant and trending news stories on Reddit, analyzing public sentiment through comments, extracting key insights from source articles, and generating strategic angles for digital PR campaigns. It automates the entire process, ensuring timely and data-driven decision-making, ultimately enhancing the effectiveness of PR strategies.

Workflow Steps

Schedule Trigger: The workflow is automatically triggered every Monday at 6 AM, ensuring consistent updates.
- Set Data: Users input their topics of interest and API keys, which guide the workflow's focus.
- Split Topics into Items: Topics are divided into individual items for targeted processing.
- Search Posts: The workflow searches Reddit for posts related to the specified topics, focusing on those sorted by hot popularity.
- Upvotes Requirement Filtering: Posts are filtered based on a minimum of 100 upvotes, ensuring only popular content is considered.
- Set Reddit Posts: Relevant information from the filtered posts is organized into a structured format.
- Remove Duplicates: The workflow eliminates duplicate posts, retaining the most upvoted versions.
- Loop Over Items: Each unique post is processed individually to gather comments.
- Get Comments: Comments for each post are retrieved for further analysis.
- Extract Top Comments: The top 30 comments are extracted based on their scores.
- Format Comments: The comments are formatted into a structured Markdown format for clarity.
- Comments Analysis: A detailed analysis of the comments is performed to extract sentiment and engagement insights.
- Get News Content: Additional content is fetched from relevant news sources to complement the analysis.
- News Analysis: The news content is analyzed alongside Reddit metrics to identify PR opportunities.
- Stories Report: A comprehensive report is generated summarizing insights and recommendations.
- Set Final Report: The final report is compiled, summarizing the entire analysis and findings.
- Convert to File: The report is converted into a text file for easy sharing and storage.
- Compress Files: The generated files are compressed into a ZIP format for efficient storage.
- Google Drive Upload: The compressed files are uploaded to Google Drive for accessibility.
- Share on Mattermost: Notifications are sent to a Mattermost channel, informing team members of new updates.

Customization Guide

Adjust Topics: Users can modify the Topics field in the Set Data node to focus on different areas of interest.
- Change Schedule: The Schedule Trigger can be adjusted to run at different times or frequencies based on user needs.
- Modify Upvotes Threshold: The minimum upvotes required for posts can be changed in the Upvotes Requirement Filtering node to capture less popular content if desired.
- Customize Output Formats: Users can alter the formatting in the Format Comments and Set Final Report nodes to fit their reporting style.
- Integrate Additional APIs: Users can add more API integrations in the workflow to enrich the analysis with other data sources.
- Personalize Notifications: The Send files to Mattermost node can be customized to target specific channels or include different messaging.