Generate SENSEX trading signals using Gemini, Yahoo Finance and Google Sheets

Description

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 high-confidence signals and logs them into Google Sheets for tracking.

Quick Implementation Steps

Import the workflow into your n8n account
Add credentials:
Google Gemini API
Google Sheets OAuth2
Create a Google Sheet with columns:
Date | Index | Signal | Confidence | Trend | Reason
Execute the workflow manually
Check results in your Google Sheet

What It Does

This workflow automates stock market signal generation for the SENSEX index using a hybrid approach that combines technical analysis and AI-based reasoning.

First, it fetches historical market data from Yahoo Finance and computes key indicators such as moving averages, momentum, volatility and price change. These indicators help identify the current market trend and behavior.

Next, it retrieves the latest SENSEX-related news headlines and feeds both the technical data and news into a Google Gemini AI model. The AI analyzes this combined input to generate a trading signal (Buy/Sell), along with confidence, strength, risk level and reasoning.

Finally, the workflow calculates a score based on AI output, filters only high-quality signals (score > 70) and logs them into Google Sheets for further tracking and decision-making.

Who It's For

Traders looking for automated signal generation
Developers building fintech or trading tools
Data analysts interested in AI-driven market insights
Automation enthusiasts using n8n
Anyone exploring AI + financial data workflows

Requirements

To use this workflow, you need:

n8n account (self-hosted or cloud)
Google Gemini API credentials
Google Sheets OAuth2 credentials
A Google Sheet with predefined columns
Internet access for:
Yahoo Finance API
Google News RSS

How It Works & Setup Guide

Workflow Breakdown

Manual Trigger

Starts the workflow execution manually

Fetch Market Data

HTTP Request pulls SENSEX data from Yahoo Finance

Technical Analysis

Code node calculates:
5-day & 20-day moving averages
Momentum
Volatility
Price change (%)

Data Structuring

Set node formats key metrics for AI processing

Fetch Latest News

RSS node pulls SENSEX-related news from Google News

Limit News

Only the latest article is passed to AI

AI Signal Generation

Gemini AI analyzes:
Technical indicators
News sentiment
Outputs:
Signal (Buy/Sell)
Confidence
Strength
Risk level
Reason

Parse AI Output

Converts AI response into structured JSON

Score Calculation

Score is computed using:
Confidence
Strength
Risk level

Validation

Only signals with score > 70 are accepted

Store Results

Valid signals are appended to Google Sheets

Setup Instructions

Import workflow into your n8n account
Configure credentials:
Google Gemini API
Google Sheets OAuth2
Update Google Sheet ID (if needed)
Verify API URLs:
Yahoo Finance endpoint
Google News RSS link
Execute manually using Start node
Check output in Google Sheets

How To Customize Nodes

HTTP Request Node**
Change index (e.g., NIFTY, NASDAQ) by updating the URL

Code Node (Indicators)**
Modify moving average window (e.g., 10-day, 50-day)
Add RSI, MACD, etc.

AI Agent Prompt**
Customize signal logic
Add stricter risk rules or additional outputs

Score Calculator**
Adjust scoring weights:
Confidence threshold
Strength importance
Risk penalties

Google Sheets Node**
Add more columns like:
Risk Level
Strength
Score

Add-ons (Enhancements)

Add Cron Trigger for automation (daily execution)
Integrate Telegram/Email alerts for signals
Store data in a database (PostgreSQL, MongoDB)
Add multi-index support (NIFTY, Dow Jones, etc.)
Build a dashboard (Power BI / Streamlit)
Include advanced indicators like RSI, MACD

Use Case Examples

Automated Trading Signal Logger
Generate and store signals daily

AI-Assisted Decision Support
Use signals as guidance before trading

Market Trend Monitoring System
Track trend + volatility over time

Fintech Product Prototype
Build an AI-based trading assistant

Research & Backtesting Tool
Analyze historical signals and performance

There can be many more use cases depending on how you want to extend this workflow.

Troubleshooting Guide

| Issue | Possible Cause | Solution |
|------|--------------|---------|
| No data from Yahoo Finance | API URL incorrect or rate-limited | Verify endpoint and retry |
| AI output not parsing | Invalid JSON from AI | Ensure prompt enforces strict JSON |
| No rows in Google Sheets | Validation failed (score ≤ 70) | Check score logic or lower threshold |
| Credential errors | Missing or incorrect API keys | Reconfigure credentials |
| Empty news input | RSS feed issue | Verify RSS URL and connectivity |
| Workflow stops early | Node misconfiguration | Check execution logs in n8n |

Need Help?

If you need assistance with:

Setting up this workflow
Customizing AI logic
Adding new integrations (Telegram, dashboards, APIs)
Scaling this into a production-ready system

Feel free to reach out to n8n automation developers at WeblineIndia

We can help you build powerful automation workflows tailored to your business needs.