Quick overview
This workflow runs on a schedule to monitor Google News RSS results for a list of companies, uses Anthropic to classify headlines into business event types, and appends deduplicated events to a Google Sheets tab.
How it works
- Runs every morning on a schedule (or manually) and loads the monitoring settings, including the company list, lookback window, and Google Sheets target.
- Builds one Google News RSS search URL per company and fetches matching headlines from Google News.
- Filters results to recent items where the company name appears in the headline, limits the number of headlines per company, and skips links already checked in previous executions.
- Sends each headline and snippet to Anthropic to extract whether it is about the company plus an event type, event date, people involved, and a verbatim quote.
- Combines the AI output with the source headline data, drops passing mentions, and generates an event key to group duplicate reports.
- Removes items classified as “other”, deduplicates multiple outlets reporting the same event, skips events already logged in previous executions, and appends the remaining events to Google Sheets.
Setup
- Add an Anthropic API credential for the chat model used by the information extraction step (or replace it with another compatible LLM node).
- Add a Google Sheets OAuth2 credential and update the spreadsheet URL and sheet/tab name in the monitoring settings.
- Create the target tab in the spreadsheet (or ensure the named sheet exists) and edit the company list, keywords, locale, and limits in the monitoring settings before activating the workflow.
Requirements
- n8n with the AI (LangChain) nodes. Built and tested on n8n 2.21, self-hosted.
- A Google account with access to Google Sheets.
- An Anthropic API key, or a key for another chat model provider. Each headline is one short model call.
Customization
- Event types: edit the rules in the system prompt and the enum in the schema of Classify business event, then update the list at the top of Combine AI result with headline.
- Search scope: edit eventKeywords to widen or narrow the results, or leave it empty to check all news about each company.
- Region and language: change newsLanguage (for example de) and newsCountry (for example DE).
- Destination: the rows that reach the last node are flat, so you can replace Append events to Google Sheets with an Airtable, Baserow, Notion or database node. Use event_key as the unique key if you upsert.
- Alerts: add a Slack or email node after the last node to get a message for each new event.
Additional info
Limitations: the AI reads only headlines and short snippets, not full articles, so event_date is often empty. Google News links are Google redirect URLs. The Google News RSS feed is meant for personal feed readers, so check its terms for your use case or swap in a news API. Duplicate checks use the n8n deduplication store: to process the same headlines again, run the Remove Duplicates nodes once with the operation Clear Deduplication History.