Send Daily Price Alert Emails
Monitor stock and crypto prices daily, detect significant movements beyond your set thresholds, and send a formatted HTML email report each morning.
Stock MonitoringCrypto AlertsPrice TrackingEmail Reports
Stock and Crypto Price Alert Workflow
This workflow monitors your chosen stock and cryptocurrency prices every morning, compares daily movements against your configured thresholds, and delivers a polished HTML email summarizing significant changes. It's ideal for investors and traders who want timely market updates without manually checking prices.
What It Does
- Triggers daily at 9 AM UTC to kick off the monitoring cycle.
- Parses your configured watchlist of stock and crypto symbols.
- Fetches recent price data from Yahoo Finance for each symbol.
- Analyzes price changes and flags any that exceed your rise or drop thresholds.
- Uses an AI model to generate a detailed, well-formatted HTML email with alerts, a market summary, and actionable insights.
- Sends the completed email report to your configured address via Gmail.
What You Need
- A Needle platform account to create and run workflows.
- A comma-separated watchlist of stock and crypto symbols (e.g.,
AAPL, BTC-USD, TSLA) stored in your workflow configuration. - Configured percentage thresholds for price rises and drops.
- Network access to Yahoo Finance API endpoints (
https://query1.finance.yahoo.com) — no authentication required. - A connected Gmail account for sending the alert emails.
How the Flow Works
| Node | Description |
|---|---|
| Scheduled Trigger | Starts the workflow daily at 9 AM UTC. |
| Code (Parse Watchlist) | Splits the configured watchlist into individual symbols and builds Yahoo Finance API URLs for each. |
| HTTP Request | Fetches price data in JSON format for each symbol from Yahoo Finance's chart API. |
| Code (Analyze Price Movement) | Parses API responses, calculates percentage price changes, and flags symbols with significant rises or drops based on your thresholds. |
| AI Model | Generates a fully formatted HTML email body summarizing price movements, alerts, and market insights. |
| Gmail (Send Email) | Sends the finished HTML report to the configured recipient email address. |
Output
The workflow delivers a professionally formatted HTML email each morning. It includes:
- Header — Report title with the current date.
- Significant Movements — Alerts highlighting notable price rises or drops, or an "All Clear" message if nothing exceeded your thresholds.
- Market Summary Table — All tracked assets with current prices, daily percentage changes, and status indicators.
- Analysis — A brief text block summarizing key trends across your watchlist.
- What To Watch — Actionable insights generated from the day's data.
- Footer — A disclaimer noting the report is auto-generated and not financial advice.
Configuration Options
| Parameter | Description | Default |
|---|---|---|
WATCHLIST | Comma-separated list of symbols to track (e.g., AAPL, BTC-USD, TSLA) | — |
PRICE_RISE_THRESHOLD | Percentage increase that triggers a rise alert | 5% |
PRICE_DROP_THRESHOLD | Percentage decrease that triggers a drop alert | 5% |
ALERT_EMAIL | Email address to receive the daily report | — |
Notes
- Make sure your watchlist symbols match Yahoo Finance's symbol format exactly (e.g.,
BTC-USDfor Bitcoin,AAPLfor Apple). - The AI-generated email uses table-based layouts and inline styles for maximum email client compatibility.
- You can customize the AI prompt within the workflow if you want different email styling or content.
- Be mindful of rate limits on Yahoo Finance endpoints if you scale to a large number of symbols.
- The schedule defaults to UTC but can be adjusted in the trigger node to match your preferred timezone.
Want to showcase your own workflows?
Become a Needle workflow partner and turn your expertise into recurring revenue.
