Send AI stock risk alerts from Google Sheets with Twelve Data and Groq

Google Sheets + Twelve Data + Groq AI Stock Risk Alert Workflow

> Smart Stock Risk Alerts in Minutes

This workflow automatically reads your stock portfolio from Google Sheets, fetches real-time prices via API, calculates risk metrics (price drops and volatility) and sends AI-generated email alerts only when risks are detected. It helps you stay informed without being overwhelmed by unnecessary notifications.

Quick Implementation Steps

1. Connect your Google Sheets account and prepare your portfolio sheet. 2. Add your Twelve Data API key in the HTTP Request node. 3. Connect your Gmail account for sending alerts. 4. Configure thresholds in the Edit Fields – Config & Thresholds node. 5. Set up a Cron (Schedule Trigger) instead of manual execution. 6. [Run the workflow and monitor alerts](https://n8n.partnerlinks.io/om1efg2qgvwi).

What It Does

This workflow automates stock portfolio monitoring by combining spreadsheet data, real-time market prices and AI-powered summaries. It reads your portfolio data from Google Sheets and processes each stock by fetching its current market price through an external API.

Once the data is enriched, the workflow calculates key risk indicators such as percentage price change and volatility. Based on predefined thresholds, it flags stocks that may require attention. Instead of sending raw data, it uses an AI model to generate a clean, human-readable summary.