Send crypto price alerts, daily digests and /price replies with CoinGecko, Telegram and Sheets

Quick overview This workflow tracks a configurable crypto watchlist using the CoinGecko API, sends Telegram alerts when price, % change, or volume-spike conditions are met (with optional RSI filtering), optionally logs triggered alerts to Google Sheets, and also provides a daily Telegram digest plus a /price command bot. How it works 1. Runs every hour on a schedule, loads your watchlist, and loops through each configured asset. 2. Fetches current price, 24h change, 24h volume, and market cap from the CoinGecko API and normalizes the response (including optional portfolio value from holdings). 3. Loads per-asset saved state from n8n static data and, on the first run, stores a baseline price without sending alerts. 4. For subsequent runs, optionally pulls 15 days of daily prices from CoinGecko to calculate a 14-period RSI and then evaluates alert conditions (price threshold, % move since last check, and 24h volume spike) with RSI as a suppression filter. 5. If an alert should fire and the per-asset cooldown has passed, formats and sends a Markdown Telegram alert and optionally appends an alert row to Google Sheets. 6. Updates the saved per-asset state (price, last alert time, and rolling 7-period average volume) so future checks can enforce cooldowns and detect volume spikes. 7. Separately, runs daily at 8:00 UTC to fetch bulk prices from CoinGecko and the Fear & Greed Index from alternative.me, then sends a Telegram daily digest. 8. Separately, listens for incoming Telegram messages and replies to /price