Daily Stock & Crypto Brief n8n Workflow: Gmail, Telegram, Sheets

Get a daily Stock & Crypto Brief in your inbox—plus a Telegram digest—automatically

This Daily Stock & Crypto Brief n8n workflow runs every morning (or on demand) to analyze stock trend/momentum, score Google News headlines with an OpenAI-compatible model, pulls crypto data from CoinGecko, saves results to Google Sheets, and sends a formatted HTML email via Gmail plus a compact Telegram message.

What this workflow does

• Schedules and triggers: Runs daily at 07:00 (or via manual trigger) and loads your configured tickers, crypto list, and recipient email.
• Builds day-over-day context: Reads prior ticker scores from Google Sheets to calculate changes.
• Stock technical analysis: Fetches 250 daily price bars per ticker from Twelve Data, computes technical indicators/signals including SMA/EMA, RSI, MACD, Bollinger Bands, ATR, and 52-week position.
• News sentiment scoring: Pulls recent ticker headlines from Google News RSS and uses an OpenAI-compatible chat model to return a structured sentiment score and short summary based on those headlines.
• Composite scoring and verdict: Combines trend, momentum, sentiment, and volatility into a 0–100 score with a BUY / HOLD / AVOID verdict; includes pacing (wait) to respect free API rate limits.
• Ranks and reports: Detects verdict/indicator events, appends today’s scores to Google Sheets, and fetches crypto prices from CoinGecko.
• Exec summary + delivery: Uses an OpenAI-compatible model to draft an executive summary, generates an HTML email for Gmail, and sends a concise Telegram digest.

Use cases

• Daily investment briefing for SaaS operators or analysts who track tickers and crypto.
• Automated “what changed since yesterday” scoring using Google Sheets history.
• News-aware alerts combining technical indicators with Google News sentiment.

Technical details

• Integrations / nodes: Twelve Data (stock bars), Google News RSS, CoinGecko (crypto), Google Sheets (score storage/history), Gmail (HTML email), Telegram (digest).
• Workflow building blocks: set, code, wait, gmail, telegram, sticky note.
• AI step: OpenAI-compatible chat model for structured headline sentiment + executive summary.

Setup note: Configure your Twelve Data API key and the workflow’s ticker/crypto lists and recipients.