{"product_id":"automated-corporate-actions-tracker-n8n-rss-google-sheets-ai","title":"Automated Corporate Actions Tracker: n8n, RSS, Google Sheets \u0026 AI","description":"\u003cp\u003eTransform 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.\u003c\/p\u003e\n\n\u003ch3\u003eWhat This Workflow Does\u003c\/h3\u003e\n\u003cp\u003eThis 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.\u003c\/p\u003e\n\n\u003cp\u003eWhen 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.\u003c\/p\u003e\n\n\u003ch3\u003eUse Cases\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eFinancial Advisors:\u003c\/strong\u003e Automatically monitor corporate actions affecting client portfolios without manual RSS checking\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003ePortfolio Managers:\u003c\/strong\u003e Receive instant AI-powered impact analysis for dividend announcements and bonus issues\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eInvestment Firms:\u003c\/strong\u003e Streamline corporate action processing with automated Google Sheets integration\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eIndividual Investors:\u003c\/strong\u003e Stay informed about portfolio-relevant corporate actions with personalized email alerts\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical Details\u003c\/h3\u003e\n\u003cp\u003eBuilt 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.\u003c\/p\u003e\n\n\u003cp\u003eQuick 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.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45475748806835,"sku":"N8N-15336","price":28.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/automated-corporate-actions-tracker-n8n-rss-google-sheets-ai.png?v=1777369923","url":"https:\/\/buyflowscripts.com\/products\/automated-corporate-actions-tracker-n8n-rss-google-sheets-ai","provider":"N8N Commerce","version":"1.0","type":"link"}