Generate SENSEX trading signals using Gemini, Yahoo Finance and Google Sheets
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 12 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Gemini Chat Model and Google Sheets. It also calls query1.finance.yahoo.com over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Fetching INDEX data (HTTP Request): calls query1.finance.yahoo.com
- Code: runs custom JavaScript code
- Parse Important Data (Edit Fields (Set)): sets 6 fields: trend, momentum, volatility…
- News Fetching (RSS Read): reads an RSS feed
- Extrating latest news (Limit): keeps the first few items
- AI Agent: runs an AI agent, with model: Google Gemini Chat Model
- AI agent output parsing (Edit Fields (Set)): sets 1 field: parsed
- Score Calculator (Code): runs custom JavaScript code
- Validating signal (If): checks a condition and branches into true / false
- Log into sheet (Google Sheets): append
Services it uses
HTTP calls to: query1.finance.yahoo.com
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 (10)
- Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Edit Fields (Set)
n8n-nodes-base.set - If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets - AI Agent
@n8n/n8n-nodes-langchain.agent - RSS Read
n8n-nodes-base.rssFeedRead - Limit
n8n-nodes-base.limit - Manual Trigger
n8n-nodes-base.manualTrigger
From the author
AI-Powered SENSEX Signal Generator > Gemini, Yahoo Finance & Google Sheets --- This n8n workflow automatically analyzes SENSEX market data using technical indicators and AI (Google Gemini) to generate trading signals (Buy/Sell). It filters only…