AI Inventory Reorder & Supplier Notification

Daily workflow that analyzes inventory levels across 15+ SKUs, identifies critical reorder needs, calculates costs, and sends purchase orders to suppliers automatically.

n8nClaude AIOpenRouterGmail APIGoogle Sheets APISlackWholesale Distribution

Problem

Wholesale distributors manage inventory manually — someone checks stock each morning, decides what to reorder, emails suppliers, and logs it somewhere. At 15–50 SKUs across multiple suppliers, that's 30–60 minutes of daily procurement work that follows the same logic every time. Stockouts are expensive. Over-ordering ties up cash. The data to make better decisions already exists — it just isn't automated.

Solution

A scheduled workflow that runs every morning. It loads current inventory levels across all SKUs, sends the dataset to Claude AI, and receives back a structured reorder analysis — which items are critical, quantities needed, why each was flagged, and total PO value per supplier. It then generates purchase orders, emails suppliers, logs the run, and posts an ops summary to Slack. All before the workday starts.

Demo

Results

8 of 9 reorder items correctly identified
$4,889.77 in PO value calculated automatically
20.4-second execution including AI analysis
15 SKUs across 5 suppliers analyzed daily

Tech Stack

n8nClaude AIOpenRouter APIGmail APIGoogle Sheets APISlackJavaScriptScheduled Triggers

Want something like this for your team?

Fixed-price engagements. No retainers. Most projects ship in 1–6 weeks.

Book a Discovery Call