Analyze corporate action impact from NSE RSS with Google Sheets, Gemini, and Gmail
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 19 nodes and runs on a schedule (every day). Along the way it connects Google Sheets, Google Gemini and Gmail.
How it runs
Trigger: On a schedule (every day).
- Config (Edit Fields) (Edit Fields (Set)): sets 2 fields: client_id, admin_email
- Fetch Corporate Actions (RSS Read): reads an RSS feed
- Normalize RSS (Code): runs custom JavaScript code
- Fetch Portfolio (Single Client) (Google Sheets): uses Google Sheets
- Compare Holdings + Build Prompt (Code): runs custom JavaScript code
- Has Matching Actions? (If): checks a condition and branches into true / false
- Generate AI Impact Summary (Google Gemini): uses Google Gemini
- Prepare No-Match Output (Code): runs custom JavaScript code
- Clean + Parse AI Output (Code): runs custom JavaScript code
- Send No-Match Email (Gmail): uses Gmail
…plus 8 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (8)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - Google Gemini
@n8n/n8n-nodes-langchain.googleGemini - Gmail
n8n-nodes-base.gmail - RSS Read
n8n-nodes-base.rssFeedRead
From the author
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…