Track weekly portfolio risk using GPT-4.1, Slack alerts, and Google Sheets

Description

📊 Description
This workflow reads your portfolio from Google Sheets, fetches market data, evaluates key risk factors such as sector concentration, volatility, and stock correlation, and generates an easy-to-understand risk summary using AI.
When meaningful risk is detected, the workflow sends a structured alert to Slack and stores a weekly risk snapshot in Google Sheets for tracking trends over time. This automation is designed to help investors, analysts, and teams understand portfolio risk clearly without manual analysis or constant monitoring.

🔁 What This Workflow Does
1️⃣ Runs automatically on a weekly schedule using a Schedule Trigger
2️⃣ Reads portfolio holdings from Google Sheets
3️⃣ Validates portfolio data to ensure required fields are present
4️⃣ Processes stocks in batches to avoid API rate limits
5️⃣ Fetches historical price data from Alpha Vantage
6️⃣ Normalizes market data into a consistent structure
7️⃣ Calculates portfolio-level risk metrics.
8️⃣ Generates a single portfolio risk score and risk flag
9️⃣ Uses AI to explain detected risks in simple language
🔟 Sends a clear weekly risk alert to Slack
1️⃣1️⃣ Stores a summarized weekly risk snapshot in Google Sheets
1️⃣2️⃣ Handles invalid data safely to avoid noisy or misleading alerts

⭐ Key Benefits
✅ Understand portfolio risk at a glance
✅ Detect sector overexposure and diversification issues early
✅ Receive only meaningful, high-signal alerts
✅ Simple AI explanations instead of raw numbers
✅ Automatic weekly risk history stored in Google Sheets
✅ No financial advice, only analytical insights
✅ Designed for reuse and easy customization

🧩 Features
Weekly automated portfolio risk analysis
Google Sheets–based portfolio input
Alpha Vantage market data integration
Batch processing with rate-limit protection
Sector, volatility, and correlation risk analysis
Portfolio risk scoring system
AI-generated risk explanations
Slack alerts for detected risk
Google Sheets storage for historical tracking

🔐 Requirements
Google Sheets credentials
Alpha Vantage API key
Slack credentials (OAuth or webhook)
AI provider API key

🎯 Target Audience
Long-term and active investors
Portfolio and risk analysts
Finance and operations teams
Fintech and investment platforms
Automation engineers building financial workflows