# Reorder inventory and track supplier confirmations with Sheets, Gmail and GPT-4 Mini

> Quick Overview This workflow audits inventory and open purchase orders in Google Sheets, calculates reorder quantities based on measured demand and lead times, and emails purchase orders via Gmail with optional buyer approval; it also uses OpenAI to extract supplier confirmations from Gmail replies and updates the order pipeline. How it works 1. Runs every weekday morning on a schedule to start a replenishment run. 2. Reads Products, Stockouts, Sales, Purchase orders, Suppliers, and Reorder log tabs from Google Sheets and audits them to flag late deliveries, short receipts, and stock records that don’t reconcile. 3. Emails suppliers via Gmail to chase overdue/short deliveries and emails operations to investigate any stock discrepancies, while logging these actions back to the Reorder log in Google Sheets. 4. Calculates demand (excluding stockout days and sales spikes), measures supplier lead times from receipt history (or uses quoted lead time when history is thin), and builds one prop

- **Domain**: `n8n-workflow-19878.n8n.io`
- **Provider**: n8n.io (https://n8n.io)
- **Kind**: workflow
- **Live-responds (last probe)**: None
- **Signed card**: False
- **Streaming**: False
- **Quality score**: 40%

## URLs
- Agent card: https://n8n.io/workflows/19878
- Page (HTML): https://agenstry.com/agents/n8n-workflow-19878.n8n.io
- Documentation: https://n8n.io/workflows/19878