Analyze corporate action impact from NSE RSS with Google Sheets, Gemini, and Gmail

Corporate Actions Impact Analyzer

> n8n, NSE RSS, Google Sheets, Gemini AI and Gmail

This workflow automatically tracks corporate actions from NSE RSS, matches them with a single client’s portfolio stored in Google Sheets, calculates financial impact using AI and sends a structured email summary. Every run is logged for tracking and auditing.

Quick Implementation Steps

1. [Connect credentials in your n8n account](https://n8n.partnerlinks.io/om1efg2qgvwi): Google Sheets Gmail Google Gemini API 2. Open Config (Edit Fields) and update clientid and adminemail 3. Ensure your Portfolio Sheet has required columns (see below) 4. Run workflow manually once for testing 5. Activate Run Workflow (Scheduler)

What It Does

This workflow automates corporate action monitoring for a single client portfolio. It starts by fetching the latest corporate actions from the NSE RSS feed and converting raw feed data into structured fields such as company name, dividend amount, ratios and important dates.

It then retrieves the client’s holdings from Google Sheets and intelligently matches them with corporate actions using normalized company names. Only relevant matches are processed further.