Create Low-Stock Purchase Orders with Airtable and Brevo

### 📦 Automated Purchase Order Creation – n8n Workflow This n8n automation checks products with low stock every night, calculates smart reorder quantities, avoids duplicate POs, and creates fresh purchase orders automatically. ✅ Steps: 1. Run Every Midnight – Scheduled daily trigger. 2. Get Products with Low Stock – Fetch products below reorder threshold from Airtable. 3. Get Supplier Details – Fetch related supplier info. 4. Calculate Dynamic Reorder Quantity – Uses average daily sales × lead time × safety margin. 5. Search Existing POs – Checks if there are active pending/sent orders. 6. Remove Duplicate Product Orders – Filters out products already covered by existing POs. 7. Create Purchase Records – Generates new purchase order records in Airtable with supplier email, product name, reorder quantity, etc. ⚙ Fully automated daily process — keeps your stock healthy and your suppliers notified.