Fully automated daily workflow that monitors stock levels, generates purchase orders in Airtable for low-stock items, prevents duplicates, and emails suppliers to keep inventory healthy.
This workflow automates inventory management and procurement by running daily checks at midnight and 1 AM. It identifies low-stock products in Airtable's Products table (where stock_level <= reorder_threshold), fetches supplier details, calculates optimal reorder quantities using JavaScript (average_daily_sales × lead_time × 1.5 × safety_margin 1.2), searches for existing pending POs to avoid duplicates, filters out covered products, and creates new PO records with product details, quantities, s
Platform
n8n
Category
Customer Support
Price
$24.99
Creator
Jordi Faber
inventory
airtable
purchase-orders
suppliers
procurement
supply-chain
email-automation
javascript
scheduling
ecommerce
How to import this workflow into n8n
1Purchase or download the workflow to get the n8n workflow JSON file.
2In your n8n instance, open Workflows and choose "Import from File" (or paste the JSON with Ctrl+V on the canvas).
3Open each node marked with a credential warning and connect your own accounts and API keys.
4Run the workflow once manually to verify the data flow, then toggle it to Active.