{"product_id":"google-sheets-inventory-reorder-points-telegram-alerts-n8n","title":"Google Sheets Inventory Reorder Points + Telegram Alerts (n8n)","description":"\u003ch3\u003eNever run low on stock again—automate reorder points and Telegram alerts from Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow calculates per-SKU safety stock and reorder points from your Google Sheets inventory + movement history every morning, updates your \u003cstrong\u003eInventory_Master\u003c\/strong\u003e tab, and can send a \u003cstrong\u003eTelegram\u003c\/strong\u003e digest when items are out of stock or need reordering.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cp\u003eScheduled daily at \u003cstrong\u003e07:00\u003c\/strong\u003e, the workflow:\u003c\/p\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads data\u003c\/strong\u003e from your Google Sheet tabs: \u003cstrong\u003eInventory\u003c\/strong\u003e (e.g., \u003cem\u003esku\u003c\/em\u003e, \u003cem\u003ename\u003c\/em\u003e, \u003cem\u003estock_qty\u003c\/em\u003e, \u003cem\u003elead_time_days\u003c\/em\u003e) and \u003cstrong\u003eMovements\u003c\/strong\u003e (e.g., \u003cem\u003edate\u003c\/em\u003e, \u003cem\u003esku\u003c\/em\u003e, \u003cem\u003eqty_out\u003c\/em\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCombines the datasets\u003c\/strong\u003e and calculates demand signals using the \u003cstrong\u003elast 90 days\u003c\/strong\u003e of outbound movements.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eComputes key inventory metrics per SKU\u003c\/strong\u003e, including:\n    \u003cul\u003e\n      \u003cli\u003eaverage daily usage,\u003c\/li\u003e\n      \u003cli\u003esafety stock,\u003c\/li\u003e\n      \u003cli\u003ereorder point,\u003c\/li\u003e\n      \u003cli\u003edays of cover,\u003c\/li\u003e\n      \u003cli\u003eand a suggested order quantity.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates or appends results\u003c\/strong\u003e back into the \u003cstrong\u003eInventory_Master\u003c\/strong\u003e tab, matching rows by \u003cem\u003esku\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters SKUs needing action\u003c\/strong\u003e: out of stock, at\/below safety stock, or at\/below reorder point.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds a single digest\u003c\/strong\u003e summarizing those SKUs and sends it to \u003cstrong\u003eTelegram\u003c\/strong\u003e \u003cem\u003eif enabled\u003c\/em\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSmall warehouses or SaaS ops teams that track inventory in Google Sheets and want automated reorder thresholds.\u003c\/li\u003e\n  \u003cli\u003eTeams that need a daily low-stock summary in Telegram without manually checking spreadsheets.\u003c\/li\u003e\n  \u003cli\u003eOperators who want to maintain an always-current \u003cstrong\u003eInventory_Master\u003c\/strong\u003e sheet of reorder recommendations.\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\/workflow components\u003c\/strong\u003e: \u003cem\u003eGoogle Sheets\u003c\/em\u003e, \u003cem\u003eif\u003c\/em\u003e, \u003cem\u003ecode\u003c\/em\u003e, \u003cem\u003emerge\u003c\/em\u003e, \u003cem\u003etelegram\u003c\/em\u003e, plus supporting notes.\u003c\/li\u003e\n  \u003cli\u003eRuns on a \u003cstrong\u003edaily schedule\u003c\/strong\u003e at \u003cstrong\u003e07:00\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eRequires a \u003cstrong\u003eGoogle Sheets credential\u003c\/strong\u003e; set your spreadsheet ID in the Google Sheets steps.\u003c\/li\u003e\n  \u003cli\u003eOptional: configure \u003cstrong\u003eTelegram bot credentials\u003c\/strong\u003e and \u003cstrong\u003eTELEGRAM_CHAT_ID\u003c\/strong\u003e to enable alerts.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46172950888627,"sku":"N8N-20564","price":63.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/gwufO5f11RxLi2OkhaSqE_fcf90KTz.png?v=1791364917","url":"https:\/\/buyflowscripts.com\/products\/google-sheets-inventory-reorder-points-telegram-alerts-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}