This workflow provides a 24/7 brand monitoring solution. It automatically fetches social media/news mentions for selected keywords every 15 minutes, classifies sentiment, alerts teams about negative posts on Slack, stores positive mentions as testimonials in Airtable, and logs everything in Google Sheets for centralised reporting.

Problem Statement

Many companies struggle to keep up with how their brand or products are being discussed online. Mentions on platforms like Twitter/X, blogs, or news sites can spread rapidly, but most teams rely on manual searches or sporadic checks which often leads to:

• Delayed responses to negative mentions or emerging PR issues.
• Missed opportunities to capture positive testimonials for marketing.
• Scattered data across different tools, making reporting and analysis difficult.
• Lack of consistent monitoring, especially outside business hours.

Without a structured, automated system in place, important conversations slip through the cracks, which can harm brand reputation or cause teams to miss valuable feedback and engagement opportunities.

Solution Overview

This project addressed the need for a real-time, automated monitoring and alert system. By using n8n, external APIs and a simple rule-based sentiment engine, the solution:

• Enabled 24/7 monitoring of keywords and hashtags without manual effort.
• Ensured that negative mentions were flagged instantly, allowing teams to act quickly before issues escalate.
• Captured positive mentions for reuse in marketing and testimonials, building social proof.
• Centralised all data in Google Sheets for easy reporting, trend analysis and decision-making.
• Free up team members from repetitive searching, allowing them to focus on engagement and strategy rather than manual tracking.

In essence, this automation provide companies with faster insights, stronger reputation management and better data visibility, all without relying on expensive third-party monitoring platforms.