This n8n template lets you automatically pull market data for the cryptocurrencies from CoinGecko every hour, calculate custom volatility and market-health metrics, classify each coin’s price action into buy/sell/hold/neutral signals with risk ratings, and expose both individual analyses and a portfolio summary via a webhook. It’s perfect for crypto analysts, DeFi builders, or portfolio managers who want on-demand insights without writing a single line of backend code. --- 🔧 How it works - Schedule Trigger fires every hour (or interval you choose). - HTTP Request (CoinGecko) fetches the top 10 coins by market cap, including 24 h, 7 d, and 30 d price change percentages. - Split In Batches ensures each coin is processed sequentially. - Function (Calculate Market Metrics) computes: - A weighted volatility score - Market-cap-to-volume ratio - Price-to-ATH ratio - Composite market score - IF & Switch nodes categorize each coin’s 24 h price action (up >5%, down >5%, high volatility, or stable) and append: - signal (BUY/SELL/HOLD/NEUTRAL) - riskRating (High/Medium/Low/Unknown) - recommendation & investmentStrategy guidance - NoOp & Merge nodes consolidate each branch back into a single data stream. - Function (Generate Portfolio Summary) aggregates all analyses into: - A Markdown portfolioSummary - Counts of buy/sell/hold/neutral signals - Risk distribution - Webhook Response returns the full JSON payload with individual analyses and the summary for downstream consumers. --- 👤 Who is it for? This workflow is ideal for: - Crypto researchers and analysts who need scheduled market insights - DeFi and trading bot developers looking to automate signal generation - Portfolio managers seeking a no-code overview of top assets - Automation engineers exploring API integration and data enrichment --- 📑 Data Structure When you trigger the webhook, you’ll receive a JSON object containing: - individualAnalyses: Array of { coin, symbol, currentPrice, priceChanges, marketMetrics, signal, riskRating, recommendation } - portfolioSummary: Markdown report summarizing signals, risk distribution, and top opportunity - marketSignals: Counts of each signal type - riskDistribution: Counts of each risk rating - timestamp: ISO string of analysis time --- ⚙️ Setup Instructions - Import: In n8n Editor → click “Import from JSON” → paste this workflow JSON. - Configure Schedule: Double-click the Schedule Trigger → set your desired interval (default: every hour). - Webhook Path: Open the Webhook node → choose a unique path (e.g., /crypto‐analysis) and “POST”. - Activate: Save and activate the workflow. - Test: - Open the webhook url to other tab or use cURL You’ll get back a JSON payload with both portfolioSummary and individualAnalyses. --- 📝 Tips - Rate-Limit Handling: If CoinGecko returns 429, insert a Delay node (e.g., 500 ms) after the HTTP Request. - Batch Size: Default is 1 coin at a time; you can bump it to parallelize. - Customization: Tweak volatility weightings or add new metrics directly in the “Calculate Market Metrics” Function node. - Extension: Swap CoinGecko for another API by updating the HTTP Request URL and field mappings.
