{"product_id":"automate-shopify-stock-alerts-with-google-sheets-slack","title":"Automate Shopify Stock Alerts with Google Sheets \u0026 Slack","description":"\u003cp\u003eNever run out of stock again! This powerful n8n workflow automatically monitors your Shopify inventory, calculates sales velocity, and predicts when products will sell out—sending intelligent alerts via Slack and Gmail before it's too late.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cp\u003eRunning daily at 7:00 AM UTC, this automated system performs comprehensive Shopify inventory analysis. It fetches recent paid orders and active product variants, then calculates daily sales velocity for each item to predict days until stockout. The workflow intelligently categorizes urgency levels and uses Google Sheets to log alerted variants, preventing duplicate notifications. You'll receive a concise Slack summary with urgency breakdowns plus a detailed HTML email report via Gmail. Built-in error handling ensures you're notified in Slack if anything goes wrong.\u003c\/p\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eE-commerce inventory management\u003c\/strong\u003e - Automatically track stock levels across hundreds or thousands of Shopify product variants without manual monitoring\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eSupply chain optimization\u003c\/strong\u003e - Get advance warning of potential stockouts to coordinate with suppliers and prevent lost sales\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eTeam coordination\u003c\/strong\u003e - Keep your operations team informed via Slack while providing detailed reports to managers through email\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eSeasonal planning\u003c\/strong\u003e - Monitor sales velocity changes during peak periods to adjust inventory strategies proactively\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cp\u003eThis workflow leverages multiple n8n integrations for seamless automation:\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eShopify OAuth2\u003c\/strong\u003e - Connects to Orders and Products APIs for real-time data\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e - Maintains alert logs with runTimestamp, variantIds, and totalVariantsAlerted tracking\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eSlack integration\u003c\/strong\u003e - Sends summary alerts and error notifications\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e - Delivers detailed HTML inventory reports\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eCode nodes\u003c\/strong\u003e - Calculate sales velocity and predict stockout timelines\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eSet nodes\u003c\/strong\u003e - Configure lookback windows and urgency thresholds\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003ePerfect for n8n users managing Shopify stores who want to automate inventory monitoring without complex custom development. Simply connect your credentials, configure your Google Sheet, and let the workflow handle the rest.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45539163799731,"sku":"N8N-15972","price":16.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Tk7_o1W7qJCg7NpRC4ujW_3624903e5f4c4647a4eb59d813b32a03.jpg?v=1779872531","url":"https:\/\/buyflowscripts.com\/products\/automate-shopify-stock-alerts-with-google-sheets-slack","provider":"N8N Commerce","version":"1.0","type":"link"}