Scan Multi-Timeframe Stock Breakouts with n8n, Sheets & Slack

Daily multi-timeframe stock breakout alerts—automatically scanned and confirmed with n8n, Google Sheets, OpenAI, and Slack

This n8n workflow runs every 24 hours to scan your Google Sheets watchlist, fetch daily and weekly OHLCV data, confirm aligned breakouts across timeframes, log the results, and post clear alerts to Slack—complete with an AI-generated JSON summary.

What this workflow does

• Runs on a schedule: Uses an n8n scheduled trigger to execute every 24 hours.
• Reads your watchlist: Pulls tickers from a Google Sheets Watchlist tab and filters to only symbols marked as active.
• Fetches OHLCV data via HTTP: For each active ticker, requests daily OHLCV from an HTTP endpoint and stores the data alongside the symbol metadata.
• Fetches and normalizes weekly data: Requests weekly OHLCV, normalizes both daily and weekly series into a single structure, and calculates daily/weekly breakout direction using support/resistance logic and volume thresholds.
• Confirms multi-timeframe alignment: Continues only when the workflow’s multi-timeframe confirmation flag indicates that daily and weekly signals align.
• Generates an OpenAI JSON analysis: Sends confirmed signal details to OpenAI, then normalizes the response into a consistent structure (confidence, narrative, key confirmation, and risk note).
• Logs and notifies: Appends breakout metrics and the AI narrative to a Google Sheets Breakout Signals sheet and posts a formatted alert to Slack.

Use cases

• Automate daily scanning of a “breakout watchlist” for multi-timeframe stock setups.
• Maintain a continuously updated Breakout Signals log for reporting and review.
• Send actionable, time-aligned alerts to a Slack channel for trading or research workflows.

Technical details

• n8n nodes: schedule trigger, if, code, http request, google sheets, slack, and supporting nodes (e.g., sticky note).
• Data flow: Google Sheets watchlist → HTTP OHLCV (daily/weekly) → breakout calculation → multi-timeframe confirmation → OpenAI JSON → Google Sheets append + Slack post.
• Setup requirements: Configure Google Sheets OAuth and set the spreadsheet ID and the relevant sheet tabs (Watchlist and Breakout Signals).