Real-time cryptocurrency price monitor with CoinGecko & multi-channel alerts

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

1. 24/7 Crypto Trigger – Runs every minute (or custom interval) to check latest prices. 2. Read Crypto Watchlist – Fetches symbols and conditions from Google Sheets. 3. Parse Crypto Data – Converts Google Sheet data into structured JSON. 4. Fetch Live Crypto Price – Uses CoinGecko API to get latest market price for each coin. 5. 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. 6. Check Crypto Alert Conditions – Validates alerts before sending notifications. 7. Send Crypto Email Alert – Sends email alert if condition is true. 8. Send Telegram Crypto Alert – Sends Telegram alert. 9. Send Discord Crypto Alert – Sends Discord alert. 10. Update Crypto Alert History – Updates lastalertprice and lastalerttime in Google Sheet. 11. Crypto Alert Status Check – Ensures alert process completed successfully. 12. Success Notification – Sends confirmation message on success. 13. Error Notification – Sends an error alert if something fails.

Google Sheet Columns (A-G)

| Column | Description | | ------ | ---------------------------------- | | A | symbol (BTC, ETH, SOL, etc.) | | B | upperlimit (e.g., 45000) | | C | lowerlimit (e.g., 40000) | | D | direction (both / above / below) | | E | cooldownminutes (e.g., 10) | | F | lastalertprice (auto-updated) | | G | lastalerttime (auto-updated) |