Monitor negative news for watchlist companies with Google Sheets, SerpAPI, Groq, and Gmail

AI-Powered Risk Monitor: Negative News Tracker

This workflow acts as an automated early-warning system for corporate risk. It pulls a list of companies from a Google Sheet, uses SerpAPI to scout the latest global news and employs Groq-powered AI to detect negative sentiment (such as lawsuits, layoffs or financial declines). New risks are archived in a master database and immediate Gmail alerts are sent for any confirmed negative news, ensuring you never miss a critical market signal.

Quick Implementation Steps

[Import: Upload the JSON file into your n8n workflow editor](https://n8n.partnerlinks.io/om1efg2qgvwi). Authenticate: Connect your Google Sheets, SerpAPI, Groq and Gmail credentials. Prepare Watchlist: Create a Google Sheet with a column named Companies and add the entities you want to monitor. Set Database: Create a second sheet (or tab) with headers: ID, Company, Title, Date, Reason, Severity, Link. Activate: Click Start Workflow to run a manual check or add a Schedule Trigger for 24/7 monitoring.

What It Does

This workflow automates the tedious process of manual "reputation monitoring." It starts by reading a list of target companies from your Watchlist. For every company found, it performs a real-time Google News search via SerpAPI. To handle high volumes of data efficiently, it aggregates all found articles into a single stream, standardizes the formatting and generates a unique digital fingerprint (ID) for every story.

The "intelligence" of the workflow lies in its deduplication and AI analysis. It cross-references every new article ID against your Processed News spreadsheet; if an article has been seen before, it is discarded. Only 100% new content reaches the Groq AI engine. The AI then acts as a financial analyst, reading the headline to determine if the news is truly negative and assigning a severity level (Low, Medium or High).

Finally, the workflow acts on these insights. If the AI flags an article as negative, the data is appended to your tracking sheet for long-term auditing and a formatted HTML email is sent via Gmail to your team, containing the reasoning, severity and a direct link to the source article.