AI-Driven SENSEX Trading Signals with Google Sheets & Gemini

Transform your SENSEX trading strategy with this powerful n8n workflow that combines AI analysis, technical indicators, and automated Google Sheets logging to generate high-confidence trading signals. This workflow leverages Google Gemini AI and Yahoo Finance data to deliver actionable buy/sell recommendations for the SENSEX index.

What This Workflow Does

This automated trading signal generator follows a sophisticated three-step process to identify profitable SENSEX opportunities. First, it fetches historical market data from Yahoo Finance and calculates essential technical indicators including moving averages, momentum, volatility, and price changes to assess current market trends.

Next, the workflow retrieves the latest SENSEX-related news headlines and feeds both technical data and news into Google Gemini AI. The AI model analyzes this combined information to generate comprehensive trading signals with confidence levels, strength ratings, risk assessments, and detailed reasoning for each recommendation.

Finally, the system calculates quality scores based on AI output, filters only high-confidence signals (score >70), and automatically logs qualified signals into your Google Sheets with columns for Date, Index, Signal, Confidence, Trend, and Reason.

Use Cases

• Day traders seeking AI-enhanced SENSEX signals with technical analysis backing
• Investment firms automating preliminary market screening and signal generation
• Portfolio managers tracking high-confidence trading opportunities in Indian markets
• Financial analysts combining AI insights with traditional technical indicators
• Trading teams maintaining centralized signal logs in Google Sheets for collaboration

Technical Details

Built using core n8n nodes including HTTP Request for Yahoo Finance API calls, Code nodes for technical indicator calculations, If nodes for signal filtering logic, Set nodes for data formatting, and Limit nodes for managing data processing. Integrates seamlessly with Google Gemini API for AI analysis and Google Sheets OAuth2 for automated logging.

Ready to deploy with simple credential setup for Google Gemini API and Google Sheets OAuth2. Execute manually or schedule for regular signal generation and tracking.