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

Description

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 Runs every hour and pulls 24-hour ticker statistics from the Binance public API. Filters for high-liquidity, non-stablecoin USDT pairs and iterates through each symbol. 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. For symbols that exceed the spike thresholds, fetches Binance order book depth and computes bid/ask wall pressure and spread metrics. 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. 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 Add an OpenAI API credential and confirm the model selection (gpt-4o) in the OpenAI analysis step. Add a Telegram bot credential and replace YOUR_TELEGRAM_CHAT_ID with the target chat or channel ID. Add a Google Sheets OAuth2 credential, create a sheet with headers matching the logged fields, and replace YOUR_GOOGLE_SHEET_ID and the target sheet tab as needed. Review and adjust the filtering and spike thresholds (for example MIN_VOL and MIN_CHANGE, plus the volume-ratio cutoffs) to fit the markets you want to monitor. An n8n automation workflow template by Đại Khiêm Như.

Community Metrics

Categories

• Automation
• AI

Tags

• n8n
• workflow
• google-sheets
• http-request
• telegram
• code
• openai

Capabilities

• 5 nodes
• 23 views

Information