๐Ÿ“ˆ 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

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 last_alert_price and last_alert_time 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)

ColumnDescription
Asymbol (BTC, ETH, SOL, etc.)
Bupper_limit (e.g., 45000)
Clower_limit (e.g., 40000)
Ddirection (both / above / below)
Ecooldown_minutes (e.g., 10)
Flast_alert_price (auto-updated)
Glast_alert_time (auto-updated)

How to Use

  1. Import the workflow into n8n.

  2. Configure Google Sheets credentials and link your watchlist sheet.

  3. Add your CoinGecko API endpoint in the Fetch Price node (Free tier).

  4. Set up Email, Telegram, and Discord credentials for notifications.

  5. Test with sample data:

    • Example: BTC, upper_limit=45000, lower_limit=40000, direction=both.
  6. Execute the workflow and monitor alerts.

Requirements

Customizing This Workflow

๐Ÿ”— Nodes Used

Cron, Send Email, Google Sheets, HTTP Request, Telegram, Discord

๐Ÿ“ฅ Import

Download workflow.json and import into n8n: Workflow menu โ†’ Import from File

๐Ÿ“– Importing guide ยท ๐Ÿ”‘ Credential setup