Automate Inventory Reorder with n8n & Google Sheets

Stop manual inventory tracking and never run out of stock again. This n8n workflow automatically monitors your Google Sheets inventory, generates professional purchase orders via OpenAI, and sends reorder notifications to Slack—keeping your business running smoothly 24/7.

What this workflow does

This intelligent inventory automation runs every 4 hours (or on-demand) to streamline your reorder process:

• Scans all active products in your Google Sheets inventory database
• Evaluates each product's stock level against predetermined reorder thresholds
• Skips products with sufficient stock and prevents duplicate daily orders
• Uses OpenAI to generate professional Purchase Order messages for items needing restock
• Posts purchase orders directly to your designated Slack channel
• Updates your inventory sheet and appends detailed reorder logs automatically
• Delivers comprehensive summary reports after each monitoring cycle
• Includes error handling that sends Slack alerts if issues occur

Perfect for these use cases

• E-commerce businesses managing product inventory across multiple SKUs
• SaaS operators tracking license quotas and subscription limits
• Small retailers automating supplier communications and stock management
• Procurement teams standardizing purchase order generation and approval workflows
• Operations managers maintaining optimal inventory levels without manual oversight

Technical details

Built with proven n8n nodes including Google Sheets integration, Slack messaging, OpenAI API, conditional logic (if), custom code execution, sticky notes for configuration, and robust error trigger handling. The workflow connects seamlessly with your existing Google Workspace and Slack infrastructure.

Setup takes approximately 15 minutes—simply connect your OpenAI API key, authenticate Google Sheets and Slack via OAuth2, configure your Products and Reorder Log spreadsheet tabs, select your notification channels, and activate. Your automated inventory management system will be running immediately.