Automate Inventory Reorders with Google Sheets & Slack

Streamline Your Inventory Management with Google Sheets & Slack Automation

Effortlessly automate your inventory reorder process with this powerful n8n workflow. Seamlessly integrating Google Sheets and Slack, it optimizes stock management by reading inventory data, calculating vendor-level reorder quantities, and notifying your team instantly. With approvals and vendor notifications handled through leading platforms like Slack and Gmail, you’ll ensure that the right products are reordered with maximum efficiency.

What This Workflow Does

• Scheduled Data Retrieval: Automatically fetches product inventory and vendor catalog data from Google Sheets at scheduled intervals, ensuring your data is always up-to-date.
• Data Normalization and Calculation: Normalizes datasets, merges them by Vendor ID, and calculates precise reorder quantities based on recent sales trends and vendor lead times.
• Filtering and Grouping: Identifies items that need restocking, excluding those recently ordered, and aggregates them into a single payload grouped by vendor.
• Reorder Logging and Alerting: Logs each vendor reorder back into Google Sheets with a pending status and posts a formatted reorder alert in your designated Slack channel.
• Approval and Notification Flow: When a Slack reaction is detected, it validates the user’s authorization, retrieves the Reorder ID, emails the vendor via Gmail, and updates the reorder status to SENT in the Google Sheets log.

Use Cases

• E-commerce Inventory Management: Ideal for online store operators managing a diverse product range, ensuring timely reordering of popular items.
• SaaS Operations: Helps SaaS companies keep their promotional merchandise stocked without manual tracking.
• Supply Chain Automation: Engineers automating supply chain processes can integrate this workflow into existing systems for enhanced efficiency.

Technical Details

• Tech Stack: Built with n8n using nodes like if, set, code, merge, slack.
• Integrations: Google Sheets for inventory and vendor data management, Slack for team notifications and approvals, and Gmail for vendor communication.