Detect Binance USDT volume spikes with GPT-4o, Telegram and Google Sheets

Quick Overview This workflow runs hourly to scan Binance USDT trading pairs for unusual 1-hour volume spikes, enriches spikes with order book metrics and GPT-4o analysis, then sends a ranked Telegram alert and logs the top results to Google Sheets.

How it works 1. Runs every hour and pulls 24-hour ticker statistics from the Binance public API. 2. Filters for high-liquidity, non-stablecoin USDT pairs and iterates through each symbol. 3. Fetches the last 25 one-hour candles per symbol from Binance and calculates volume/trade spike ratios, taker buy/sell pressure, and basic price-action context with cooldown-based deduplication. 4. For symbols that exceed the spike thresholds, fetches Binance order book depth and computes bid/ask wall pressure and spread metrics. 5. Sends the spike, price-action, market-context (BTC/ETH), and order-book data to OpenAI (GPT-4o) to return a structured JSON classification, severity, and suggested action. 6. Collects all analyzed spikes, ranks them, sends the top alerts to Telegram as a formatted report, and appends the top entries to Google Sheets for tracking.

Setup 1. Add an OpenAI API credential and confirm the model selection (gpt-4o) in the OpenAI analysis step. 2. Add a Telegram bot credential and replace YOURTELEGRAMCHATID with the target chat or channel ID. 3. Add a Google Sheets OAuth2 credential, create a sheet with headers matching the logged fields, and replace YOURGOOGLESHEETID and the target sheet tab as needed. 4. Review and adjust the filtering and spike thresholds (for example MINVOL and MINCHANGE, plus the volume-ratio cutoffs) to fit the markets you want to monitor.