Automate Shopify Stock Alerts with Google Sheets & Slack

Never 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.

What this workflow does

Running 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.

Use cases

• E-commerce inventory management - Automatically track stock levels across hundreds or thousands of Shopify product variants without manual monitoring
• Supply chain optimization - Get advance warning of potential stockouts to coordinate with suppliers and prevent lost sales
• Team coordination - Keep your operations team informed via Slack while providing detailed reports to managers through email
• Seasonal planning - Monitor sales velocity changes during peak periods to adjust inventory strategies proactively

Technical details

This workflow leverages multiple n8n integrations for seamless automation:

• Shopify OAuth2 - Connects to Orders and Products APIs for real-time data
• Google Sheets - Maintains alert logs with runTimestamp, variantIds, and totalVariantsAlerted tracking
• Slack integration - Sends summary alerts and error notifications
• Gmail - Delivers detailed HTML inventory reports
• Code nodes - Calculate sales velocity and predict stockout timelines
• Set nodes - Configure lookback windows and urgency thresholds

Perfect 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.