๐ Real-time cryptocurrency price monitor with CoinGecko & multi-channel alerts
โก 725 views ยท ๐ Crypto Trading & Stock Market
Description
This automated n8n workflow monitors real-time cryptocurrency prices using CoinGecko API and sends smart alerts when price conditions are met. It supports multi-coin tracking, dynamic conditions, and instant notifications via Email, Telegram, and Discord.
Good to Know
- Reads crypto watchlist data from Google Sheets.
- Monitors prices at defined intervals (24/7 monitoring).
- Handles upper and lower price limits with direction-based alerts (above, below, both).
- Implements cooldown logic to avoid duplicate alerts.
- Updates last alert price and timestamp in Google Sheets.
- Supports multiple alert channels: Email, Telegram, Discord.
- Uses CoinGecko API for price data (Free tier supported).
How It Works
-
24/7 Crypto Trigger โ Runs every minute (or custom interval) to check latest prices.
-
Read Crypto Watchlist โ Fetches symbols and conditions from Google Sheets.
-
Parse Crypto Data โ Converts Google Sheet data into structured JSON.
-
Fetch Live Crypto Price โ Uses CoinGecko API to get latest market price for each coin.
-
Smart Crypto Alert Logic โ Compares live price with upper/lower limits and evaluates conditions:
- Above โ Trigger alert if price > upper_limit.
- Below โ Trigger alert if price < lower_limit.
- Both โ Trigger alert if either condition is met.
- Implements cooldown_minutes to prevent repeated alerts.
-
Check Crypto Alert Conditions โ Validates alerts before sending notifications.
-
Send Crypto Email Alert โ Sends email alert if condition is true.
-
Send Telegram Crypto Alert โ Sends Telegram alert.
-
Send Discord Crypto Alert โ Sends Discord alert.
-
Update Crypto Alert History โ Updates
last_alert_priceandlast_alert_timein Google Sheet. -
Crypto Alert Status Check โ Ensures alert process completed successfully.
-
Success Notification โ Sends confirmation message on success.
-
Error Notification โ Sends an error alert if something fails.
Google Sheet Columns (A-G)
| Column | Description |
|---|---|
| A | symbol (BTC, ETH, SOL, etc.) |
| B | upper_limit (e.g., 45000) |
| C | lower_limit (e.g., 40000) |
| D | direction (both / above / below) |
| E | cooldown_minutes (e.g., 10) |
| F | last_alert_price (auto-updated) |
| G | last_alert_time (auto-updated) |
How to Use
-
Import the workflow into n8n.
-
Configure Google Sheets credentials and link your watchlist sheet.
-
Add your CoinGecko API endpoint in the Fetch Price node (Free tier).
-
Set up Email, Telegram, and Discord credentials for notifications.
-
Test with sample data:
- Example: BTC, upper_limit=45000, lower_limit=40000, direction=both.
-
Execute the workflow and monitor alerts.
Requirements
-
n8n environment with execution permissions.
-
Google Sheets integration (with API credentials).
-
CoinGecko API (Free tier supported).
-
Notification channels:
- Email (SMTP settings in n8n).
- Telegram Bot Token.
- Discord Webhook URL.
Customizing This Workflow
- Add more coins in Google Sheet.
- Modify alert conditions (e.g., percentage change, moving averages).
- Add SMS or WhatsApp notifications.
- Integrate with Slack or Microsoft Teams.
- Use AI-based price predictions for smarter alerts.
๐ Nodes Used
Cron, Send Email, Google Sheets, HTTP Request, Telegram, Discord
๐ฅ Import
Download workflow.json and import into n8n:
Workflow menu โ Import from File