Monitor futures trades and send risk alerts using Binance, Sheets, Slack and email

Description

Futures Trade Monitoring & Risk Alert Workflow
> n8n, Binance API, Google Sheets, Slack, Telegram, Jira & Email


This workflow automates futures trade monitoring by fetching live prices from Binance, calculating trade performance (PnL, ROI, fees), evaluating risk levels and sending alerts across Slack, Telegram, Jira and Email. It also stores trade history and analytics in Google Sheets.

Quick Implementation Steps

Import workflow into your n8n account.
Configure trade input (Function or Google Sheets).
Connect Slack, Telegram, Jira, Gmail credentials.
Set up Google Sheets (Trades & Analytics).
Run workflow or enable schedule trigger.

What It Does

This workflow continuously monitors futures trading positions by combining user-defined trade data with real-time market prices fetched from the Binance public API. It calculates key metrics such as profit/loss (PnL), return on investment (ROI) and transaction fees to evaluate trade performance.

Based on calculated values, the workflow applies a risk scoring mechanism to classify trades into different severity levels. These levels determine how alerts are routed across communication platforms such as Slack, Telegram, Jira and Email.

Additionally, the workflow stores all trade data and daily analytics in Google Sheets, enabling users to track performance trends and maintain a history of trades without manual effort.

Who It's For

Crypto futures traders
Trading teams and analysts
Risk management teams
Automation enthusiasts using n8n
Developers building trading dashboards

Requirements

n8n account (cloud or self-hosted)
Binance public API access (no API key required)
Google Sheets account
Slack workspace (optional)
Telegram bot (optional)
Jira account (optional)
Gmail account (optional)

How It Works & Setup Instructions

Step 1: Trigger Setup

Configure Schedule Trigger to run at intervals (e.g., every 5 minutes).

Step 2: Trade Input

Use Function node or Google Sheets to define:

symbol
entry_price
quantity

Step 3: Fetch Market Data

HTTP Request node calls Binance API:

Endpoint: /api/v3/ticker/price

Step 4: Merge Data

Merge node combines trade input with live price.

Step 5: Process Trade Metrics

Function node calculates:

PnL
Fees
Net PnL
ROI

Step 6: Filter Valid Trades

IF node ensures valid calculations (e.g., non-null values).

Step 7: Risk Scoring

Assigns risk score based on loss and position size.

Step 8: Alert Routing

Switch node routes alerts:

Low → Slack
Medium → Slack + Telegram
High → Slack + Telegram + Jira + Email

Step 9: Store Trade Data

Google Sheets (Trades):

Stores trade history

Step 10: Analytics

Function node generates:

Daily trade count
Net PnL summary

Step 11: Store Analytics

Google Sheets (Analytics):

Stores summarized data

How To Customize Nodes

Modify Function node to change trade input logic.
Adjust HTTP Request node for different APIs.
Update PnL logic for leverage or futures margin.
Modify risk scoring thresholds.
Customize alert messages per platform.
Change Google Sheets structure as needed.

Add-ons (Extend Functionality)

Duplicate alert prevention using Google Sheets lookup
Dashboard integration (Google Data Studio / Power BI)
Auto trade sync via exchange APIs
Webhook-based real-time alerts
Error handling and retry logic

Use Case Examples

Monitor crypto futures trades in real time.
Receive instant alerts for high-risk positions.
Track daily profit/loss automatically.
Manage multiple assets without manual checking.
Enable centralized monitoring for trading teams.

Note: This workflow can be adapted for many other financial monitoring and automation use cases.

Troubleshooting Guide

| Issue | Possible Cause | Solution |
|------|--------------|---------|
| PnL is null | Incorrect field mapping | Ensure correct price field is used |
| Telegram error | Formatting issue | Set Parse Mode to NONE |
| No alerts triggered | Risk condition not met | Check Switch node logic |
| Empty rows in Sheets | Wrong data source | Connect correct node to Sheets |
| API error | Invalid request | Verify Binance endpoint |

Need Help?

If you need help setting up, customizing or extending this workflow, feel free to reach out our n8n workflow developers at WeblineIndia.

We can help you:

Customize workflows
Integrate additional APIs
Build scalable automation systems
Add advanced analytics and dashboards
And so much more.