Automated Corporate Actions Tracker: n8n, RSS, Google Sheets & AI

Transform your corporate action monitoring from manual spreadsheet checking into an intelligent, automated system that tracks NSE announcements, analyzes portfolio impact, and delivers actionable insights directly to your inbox.

What This Workflow Does

This n8n automation connects NSE RSS feeds with Google Sheets portfolio data to deliver comprehensive corporate action analysis. The workflow fetches the latest corporate actions from NSE RSS feeds and converts raw data into structured information including company names, dividend amounts, bonus ratios, and critical dates. It intelligently matches these announcements with your client's holdings stored in Google Sheets using normalized company name matching.

When relevant matches are found, Gemini AI calculates the precise financial impact—from dividend benefits to bonus share allocations—and determines any required client actions. The system generates clean email summaries sent via Gmail while maintaining detailed logs for audit trails and performance tracking.

Use Cases

• Financial Advisors: Automatically monitor corporate actions affecting client portfolios without manual RSS checking
• Portfolio Managers: Receive instant AI-powered impact analysis for dividend announcements and bonus issues
• Investment Firms: Streamline corporate action processing with automated Google Sheets integration
• Individual Investors: Stay informed about portfolio-relevant corporate actions with personalized email alerts

Technical Details

Built using essential n8n nodes including RSS Feed Read for NSE data ingestion, Google Sheets integration for portfolio management, Gmail for notification delivery, and Code nodes for data processing logic. The workflow leverages IF nodes for conditional processing and Set nodes for data transformation, while Sticky Note nodes provide clear documentation.

Quick setup requires Google Sheets, Gmail, and Google Gemini API credentials, plus configuration of your client ID and admin email. The workflow includes a scheduler for automated runs and comprehensive logging for tracking performance and maintaining audit compliance.