Automated Shopify Dead Inventory Alerts via Gmail & Slack

Transform your Shopify inventory management with this powerful n8n workflow that automatically identifies dead stock and delivers actionable reports directly to your Gmail inbox and Slack channels. Stop letting unsold inventory drain your cash flow and warehouse space.

What this workflow does

This automated Shopify dead inventory detector runs daily at 7:00 AM to keep your stock management razor-sharp. The workflow pulls your recent paid Shopify orders and compares them against current product variants with available stock. It identifies products that haven't sold within your configured timeframe, then sorts results by total inventory value to prioritize your attention on high-impact dead stock.

When dead inventory is detected, the system generates a comprehensive CSV report and automatically emails it via Gmail to your specified recipients. Simultaneously, it uploads the same report to your designated Slack channel for team visibility. If no dead inventory is found, you'll receive a clean status message. Built-in error handling ensures any workflow issues are immediately posted to Slack with detailed failure information.

Use cases

• E-commerce operations teams monitoring inventory turnover and identifying slow-moving products
• Retail managers planning clearance sales and discount campaigns for stagnant stock
• Warehouse coordinators optimizing storage space and reducing carrying costs
• Financial analysts tracking inventory efficiency and cash flow optimization
• Product buyers making data-driven decisions about future procurement

Technical details

Built with essential n8n nodes including Shopify OAuth2 integration for secure order and product data access, Gmail OAuth2 for automated email delivery, and Slack integration for team notifications. The workflow utilizes if, set, code, merge nodes for intelligent data processing and conditional logic.

Setup requires Shopify Admin permissions, Gmail OAuth2 credentials, and Slack channel configuration. Customize detector settings including days without sales threshold, order fetch period, recipient emails, and Slack escalation channels to match your business requirements. Perfect for automation engineers and SaaS operators seeking reliable inventory intelligence.