Detect client portfolio news impact with Gemini AI, Gmail, and Google Sheets

Client Portfolio News Impact Detection with AI & Gmail

This workflow automatically fetches the latest business news, analyzes its impact on clients using AI and sends alerts for high-impact articles while logging all processed data in Google Sheets. It ensures no duplicate processing using URL normalization and maintains a complete audit trail.

Quick Implementation Steps

1. Add your News API key in the [HTTP Request node in your n8n account](https://n8n.partnerlinks.io/om1efg2qgvwi). 2. Connect Google Sheets (Client Dataset + Article Log). 3. Configure Gemini AI credentials. 4. Set up Gmail node for alerts. 5. Activate the workflow (runs daily at 8 AM).

What It Does

This workflow continuously monitors business news and evaluates its relevance to a predefined client dataset. It fetches the latest articles, validates them and ensures that only new articles are processed by comparing normalized URLs against previously logged entries.

Each article is enriched with structured client data and sent to an AI model for classification. The AI determines the impact level (High, Medium, Low) and identifies which clients are affected along with precise reasoning.

High-impact articles trigger automated email alerts, ensuring timely communication. All articles—regardless of impact—are logged in a Google Sheet along with metadata such as processing time, impact level, affected clients and email status.