Automate Crypto Exchange Trade Alerts + Weekly Reports using Webhook, Telegram & Google Sheets

Built with n8n
1

I’ve been working on automating the operational side of a cryptocurrency exchange platform and built a workflow that I think will be super useful for anyone dealing with high-frequency trade events, fintech apps, or crypto projects.

What This Workflow Does

This template handles two automation flows in one:

Flow 1 — Real-Time Trade Alert System

  • A Webhook receives trade events from your crypto exchange backend
  • Detects whether it's a BUY or SELL order
  • Formats a clean Telegram alert message with trade pair, amount, price, user ID, and timestamp
  • Logs every trade to Google Sheets for audit trail
  • Sends a success responseback to the calling system

Flow 2 — Weekly Summary Report (Auto, Every Monday 9AM)

  • Reads the entire week's trade log from Google Sheets
  • Calculates: Total Trades, BUY vs SELL count, Total Volume (USD), Top traded pair
  • Sends a formatted **summary report to Telegram** automatically

Nodes Used

  • Webhook — receives POST requests from exchange backend
  • IF— routes BUY vs SELL trades
  • Set— formats alert messages
  • Telegram— sends real-time alerts + weekly reports
  • Google Sheets— logs trade data + reads for reports
  • Code— calculates weekly stats
  • Schedule Trigger— fires every Monday 9AM
  • Respond to Webhook— sends JSON response back

Sample Webhook Payload

Send this to your webhook URL to test:

json

{

"trade_type": "BUY",

"pair": "BTC/USDT",

"amount": "0.5",

"base_currency": "BTC",

"price": "68500",

"user_id": "USR_10234",

"status": "COMPLETED"

}

Setup Instructions

  • Import the workflow JSON into your n8n instance
  • Telegram Bot — create a bot via @BotFather, get token + chat ID, add credentials
  • Google Sheets — connect your Google account, create a sheet with columns:

`Timestamp | Trade Type | Pair | Amount | Price (USD) | User ID | Status`

  • Replace `YOUR_TELEGRAM_CHAT_ID` and `YOUR_GOOGLE_SHEET_ID` in the nodes
  • Activate the workflow — webhook URL will be generated automatically
  • Point your exchange backend to fire POST requests to that webhook URL

Use Cases

  • Crypto exchange platforms needing real-time admin monitoring
  • DeFi platforms that want trade logging without complex infrastructure
  • Fintech teams who want lightweight alerting without building custom dashboards
  • Anyone building a **custom crypto exchange** and wants operational automation from Day 1

What You Can Extend This With

  • Add email alerts alongside Telegram (just add Gmail or SMTP node)
  • Connect to Slack instead of Telegram for team channels
  • Add a threshold alert — e.g., alert only if trade volume > $10,000
  • Plug in CoinGecko API to attach real-time price data to each alert
  • Route large trades to a separate high-value alert channel

We've been building crypto exchange platforms for a while and this kind of lightweight n8n automation has genuinely saved hours of manual monitoring every week. Happy to answer questions if anyone wants to adapt this for their stack!