{"product_id":"n8n-ozon-low-stock-alerts-to-telegram-via-google-sheets-thresholds","title":"n8n Ozon Low-Stock Alerts to Telegram via Google Sheets Thresholds","description":"\u003ch3\u003eGet notified on Telegram when Ozon stock runs low—using Google Sheets thresholds\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow pulls daily stock levels from your \u003cstrong\u003eOzon Seller API\u003c\/strong\u003e, compares them to per-offer minimums stored in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and sends a \u003cstrong\u003esingle low-stock summary message\u003c\/strong\u003e to \u003cstrong\u003eTelegram\u003c\/strong\u003e—at 09:00 every day.\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 executes once daily at \u003cstrong\u003e09:00\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches stock from Ozon:\u003c\/strong\u003e requests product stock levels via the \u003cstrong\u003eOzon Seller API\u003c\/strong\u003e and paginates through results.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads thresholds from Google Sheets:\u003c\/strong\u003e loads a worksheet that includes \u003cstrong\u003eoffer_id\u003c\/strong\u003e and \u003cstrong\u003emin_stock\u003c\/strong\u003e, then matches rows to products by \u003cstrong\u003eoffer_id\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates available quantity:\u003c\/strong\u003e sums available stock across warehouses for each product.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApplies default fallback:\u003c\/strong\u003e uses a default minimum stock value when no \u003cstrong\u003emin_stock\u003c\/strong\u003e entry exists for a given offer.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters low-stock items:\u003c\/strong\u003e keeps only products where \u003cstrong\u003eavailable quantity ≤ min_stock\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends one Telegram summary:\u003c\/strong\u003e formats a single message listing low-stock items (sorted by lowest stock) and limits output to a configured maximum number of lines.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003ePrevent stockouts by automatically monitoring Ozon inventory and alerting your team before items run critical.\u003c\/li\u003e\n  \u003cli\u003eMaintain per-offer safety stock levels in Google Sheets without changing workflow logic.\u003c\/li\u003e\n  \u003cli\u003eGive SaaS operators and automation engineers a reliable daily inventory watchdog using n8n.\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 \/ building blocks:\u003c\/strong\u003e \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003emerge\u003c\/code\u003e, \u003ccode\u003efilter\u003c\/code\u003e, \u003ccode\u003esplit out\u003c\/code\u003e, \u003cstrong\u003etelegram\u003c\/strong\u003e, and \u003cstrong\u003esticky note\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e \u003cstrong\u003eOzon Seller API\u003c\/strong\u003e (Custom Auth with \u003cem\u003eClient-Id\u003c\/em\u003e and \u003cem\u003eApi-Key\u003c\/em\u003e headers), \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (OAuth), and \u003cstrong\u003eTelegram\u003c\/strong\u003e (bot credentials + chat ID).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExpected sheet columns:\u003c\/strong\u003e \u003ccode\u003eoffer_id\u003c\/code\u003e, \u003ccode\u003emin_stock\u003c\/code\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003eConfigure credentials, select your spreadsheet\/worksheet, and deploy. Your low-stock signals will start flowing to Telegram automatically every day.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46203575402675,"sku":"N8N-20741","price":20.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/LQBx6E0gabv-ULyfmt0C6_xr1akEsf.png?v=1791709909","url":"https:\/\/buyflowscripts.com\/products\/n8n-ozon-low-stock-alerts-to-telegram-via-google-sheets-thresholds","provider":"N8N Commerce","version":"1.0","type":"link"}