{"product_id":"n8n-google-sheets-low-stock-alerts-to-slack-daily-route-workflow","title":"n8n Google Sheets Low-Stock Alerts to Slack (Daily Route Workflow)","description":"\u003ch3\u003eNever miss a low-stock moment—this n8n workflow checks Google Sheets daily and posts alerts to Slack\u003c\/h3\u003e\n\u003cp\u003eKeep your team ahead of inventory shortages with an n8n automation that reads your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e inventory levels every morning and automatically sends \u003cstrong\u003elow-stock\u003c\/strong\u003e and \u003cstrong\u003eout-of-stock\u003c\/strong\u003e notifications to a \u003cstrong\u003eSlack\u003c\/strong\u003e channel—plus supplier contact details—then updates the sheet to prevent duplicate alerts on the same day.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily\u003c\/strong\u003e at your scheduled time via the workflow’s scheduler.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads all inventory rows\u003c\/strong\u003e from your configured Google Sheets document (sheet name defaults to \u003ccode\u003eInventory\u003c\/code\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates stock status\u003c\/strong\u003e for each item (healthy, \u003cstrong\u003elow_stock\u003c\/strong\u003e, or \u003cstrong\u003eout_of_stock\u003c\/strong\u003e) using the row data (including \u003ccode\u003ecurrent_stock\u003c\/code\u003e and \u003ccode\u003ereorder_threshold\u003c\/code\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSkips\u003c\/strong\u003e healthy items and any items already alerted \u003cem\u003etoday\u003c\/em\u003e by checking \u003ccode\u003elast_alert_date\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePosts to Slack\u003c\/strong\u003e with urgency:\n    \u003cul\u003e\n      \u003cli\u003eOut-of-stock: urgent Slack message\u003c\/li\u003e\n      \u003cli\u003eLow-stock: lower-urgency Slack message\u003c\/li\u003e\n    \u003c\/ul\u003e\n    Messages include \u003cstrong\u003esupplier contact details\u003c\/strong\u003e (e.g., \u003ccode\u003esupplier_name\u003c\/code\u003e, \u003ccode\u003esupplier_contact\u003c\/code\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates the Google Sheets row\u003c\/strong\u003e by setting \u003ccode\u003elast_alert_date\u003c\/code\u003e to today’s date to avoid repeat alerts until the next day.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eDaily inventory monitoring for SaaS operators managing stock-backed fulfillment.\u003c\/li\u003e\n  \u003cli\u003eProcurement teams receiving immediate Slack reminders when items drop below \u003ccode\u003ereorder_threshold\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003eSupplier follow-up workflow: Slack messages include the exact contact info to speed up reordering.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Google Sheets (OAuth2) + Slack\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes \/ tools used:\u003c\/strong\u003e \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003ccode\u003eslack\u003c\/code\u003e, \u003ccode\u003efilter\u003c\/code\u003e, \u003ccode\u003esticky note\u003c\/code\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequired sheet columns:\u003c\/strong\u003e \u003ccode\u003erow_id\u003c\/code\u003e, \u003ccode\u003eitem_name\u003c\/code\u003e, \u003ccode\u003ecurrent_stock\u003c\/code\u003e, \u003ccode\u003ereorder_threshold\u003c\/code\u003e, \u003ccode\u003eunit\u003c\/code\u003e, \u003ccode\u003esupplier_name\u003c\/code\u003e, \u003ccode\u003esupplier_contact\u003c\/code\u003e, \u003ccode\u003elast_alert_date\u003c\/code\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003eIdeal if you want a reliable \u003cstrong\u003en8n Google Sheets low-stock alerts to Slack\u003c\/strong\u003e setup—simple, daily, and designed to prevent duplicate notifications.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45742789689523,"sku":"N8N-17624","price":28.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/9qzDY5XoSQ-4t04WG5Dub_11SvIUUx.png?v=1785402575","url":"https:\/\/buyflowscripts.com\/products\/n8n-google-sheets-low-stock-alerts-to-slack-daily-route-workflow","provider":"N8N Commerce","version":"1.0","type":"link"}