{"product_id":"n8n-workflow-multi-asset-price-alerts-sheets-siftingio-telegram","title":"n8n Workflow: Multi-Asset Price Alerts (Sheets + SiftingIO + Telegram)","description":"\u003ch3\u003eReal-time Multi-Asset Price Alerts in n8n (Google Sheets + SiftingIO + Telegram)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow checks a multi-asset watchlist every 20 minutes, pulls live quotes from the \u003cstrong\u003eSiftingIO\u003c\/strong\u003e API, and instantly notifies you on \u003cstrong\u003eTelegram\u003c\/strong\u003e and via \u003cstrong\u003eemail\u003c\/strong\u003e when your bid\/ask midpoint crosses your set threshold—then enforces a cooldown automatically in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a schedule\u003c\/strong\u003e every 20 minutes.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads a watchlist from Google Sheets\u003c\/strong\u003e using rows containing: \u003cem\u003esymbol\u003c\/em\u003e, \u003cem\u003evenue\u003c\/em\u003e, \u003cem\u003edirection\u003c\/em\u003e, \u003cem\u003ethreshold\u003c\/em\u003e, and \u003cem\u003elast_alert_at\u003c\/em\u003e (with each symbol unique).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches the latest quote\u003c\/strong\u003e for each item from the \u003cstrong\u003eSiftingIO API\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates the bid\/ask midpoint\u003c\/strong\u003e, then checks whether price meets the configured \u003cem\u003eabove\/below\u003c\/em\u003e threshold based on \u003cem\u003edirection\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApplies a 60-minute cooldown\u003c\/strong\u003e: if the symbol is within cooldown determined by \u003cem\u003elast_alert_at\u003c\/em\u003e, alerts are suppressed.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends Telegram alerts\u003c\/strong\u003e for each qualifying breach, including symbol, threshold direction, current price, and quote time.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends email alerts\u003c\/strong\u003e for the same qualifying breaches with the same details.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates Google Sheets\u003c\/strong\u003e (matching row by symbol) with a new \u003cem\u003elast_alert_at\u003c\/em\u003e timestamp to enforce future cooldown behavior.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eMonitor \u003cstrong\u003estocks, forex, crypto, or commodities\u003c\/strong\u003e prices using a simple Sheets-based watchlist.\u003c\/li\u003e\n  \u003cli\u003eGet alerting without building a custom backend—ideal for SaaS operators and automation engineers.\u003c\/li\u003e\n  \u003cli\u003ePrevent alert spam with automatic cooldown tracking per symbol.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes:\u003c\/strong\u003e Code, HTTP Request, Google Sheets, Telegram, Email Send, plus support notes (Sticky Note).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSiftingIO authentication:\u003c\/strong\u003e HTTP Header Auth using \u003cstrong\u003eX-API-Key\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets:\u003c\/strong\u003e OAuth2 credentials; separate steps for reading and updating the same spreadsheet\/sheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTelegram:\u003c\/strong\u003e configure credentials and chat ID for receiving alerts.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46192813244595,"sku":"N8N-20694","price":50.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/N-y6uO_lavNTE9_S71WM7_VXSdeuze.png?v=1791536453","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-multi-asset-price-alerts-sheets-siftingio-telegram","provider":"N8N Commerce","version":"1.0","type":"link"}