Automate Stock Sector Tracking with Google Sheets & AI

Transform your stock market analysis with this intelligent n8n workflow that automatically tracks sector rotation patterns and alerts you to high-confidence bullish trends using AI-powered analysis and real-time market data.

What this workflow does

This automated sector rotation tracker acts as your personal quantitative analyst, monitoring equity market movements with precision. The workflow pulls your selected stocks from Google Sheets, fetches the last 5 days of market data from Yahoo Finance, and calculates momentum indicators plus sector strength using custom code algorithms. It compares current market data against historical trends stored in your Google Sheets to detect capital rotation signals between sectors. When significant shifts are identified, Groq's Llama-3 AI model analyzes the data like a professional financial analyst and automatically sends Gmail alerts for high-confidence bullish opportunities.

Perfect for these use cases

• Portfolio managers tracking sector allocation shifts across equity markets
• Quantitative traders seeking automated momentum and rotation signal detection
• Financial advisors monitoring client portfolio sectors for rebalancing opportunities
• Investment researchers analyzing historical sector performance patterns
• Individual investors wanting professional-grade market analysis automation

Technical implementation details

Built with essential n8n nodes including Code nodes for custom momentum calculations, Google Sheets integration for data storage and stock selection, Gmail automation for alert delivery, and intelligent workflow control using If, Set, Merge, and Sticky Note nodes. The workflow integrates seamlessly with Yahoo Finance APIs for real-time market data and leverages Groq's Llama-3 model for AI-powered financial analysis.

Setup requires connecting your Google Sheets, Gmail, and Groq API credentials, creating a two-tab Google Sheet structure for active stock tracking and historical data storage, and customizing the sector mapping in the Group By Sector code node. The workflow automatically maintains historical data while providing actionable insights through intelligent email alerts.