Automated inventory management with Airtable PO creation & supplier emails
n8n13 modulesv1.0In-depth description of this automation: This is a fully automated daily supply chain and procurement workflow that keeps product stock levels healthy and suppliers updated, by automatically generating and emailing purchase orders (POs) and syncing PO statuses in Airtable. --- 📅 Daily triggers Two Schedule Trigger nodes run: One runs at midnight (00:00) to manage low stock and new purchase order creation. Another runs at 1:00 AM to process existing pending POs and em
At a glance
Automated inventory management with Airtable PO creation & supplier emails is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Airtable, Brevo. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- Airtable, Brevo
- Modules
- 13
- Price
- Free
- Version
- v1.0
About this workflow
In-depth description of this automation: This is a fully automated daily supply chain and procurement workflow that keeps product stock levels healthy and suppliers updated, by automatically generating and emailing purchase orders (POs) and syncing PO statuses in Airtable. --- 📅 Daily triggers Two Schedule Trigger nodes run: One runs at midnight (00:00) to manage low stock and new purchase order creation. Another runs at 1:00 AM to process existing pending POs and email suppliers. --- 🚦 Step-by-step breakdown 1️⃣ Get Products with low stock Searches the “Products Table” in Airtable for items where {stocklevel} <= {reorderthreshold}. Detects products that need restocking. 2️⃣ Get supplier details Fetches supplier data for each low-stock product using its supplierid. 3️⃣ Calculate Dynamic Reorder Quantity JS code calculates an optimal reorder quantity: Uses averagedailysales × (leadtime × 1.5) × safetymargin (1.2) Adds extra buffer so the new order covers both immediate demand and next cycle. 4️⃣ Search existing POs Looks in the “Purchase Orders” table for active POs (status Pending or Sent) matching each product. Prevents duplicate orders. 5️⃣ Remove duplicate product orders JS node compares current low-stock products with existing POs. Filters out products already covered, so new POs are only created for truly uncovered products. 6️⃣ Create new purchase orders For filtered products, creates new PO records in Airtable with: productname productid calculated reorderqty supplier info and email initial status Pending --- 📧 Process existing pending purchase orders and email suppliers 7️⃣ Get Purchase Orders which are pending Searches Airtable for all POs with status Pending. 8️⃣ Group products with suppliers JS code groups these POs by supplierid. Builds a summary (total products, total quantity) and an HTML email with a styled table of items. 9️⃣ Send PO emails to suppliers Uses Brevo (SendInBlue) to send emails. Subject and content include supplier-specific order details. 🔄 Update PO statuses to Sent Extracts Airtable record IDs of the sent POs. Updates those POs in Airtable, changing status from Pending → Sent. --- 📌 Summary ✅ Runs every day ✅ Dynamically calculates reorder needs ✅ Avoids duplicate purchase orders ✅ Automatically creates purchase orders in Airtable ✅ Groups & emails daily PO summaries to suppliers ✅ Updates PO status after sending email --- ⚙ Tables involved Products Table: stores products, stock levels, reorder thresholds, average daily sales, supplier references. Suppliers Table: stores supplier emails and metadata. Purchase Orders Table: tracks product orders with supplier IDs, status, quantities, etc. --- This workflow makes daily procurement fully automated: detects risk of stockouts, creates POs smartly, keeps suppliers in sync by email, and updates order statuses in one closed loop — perfect for any small or mid-sized business using Airtable + N8N.
How to import this n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n → click the menu → Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 5
Click Execute Workflow to test, then activate.
Setup guide
Setup guide included
Purchase to unlock the full step-by-step guide
Related N8n workflows
Automate responses to business emails with ChatGPT and Airtable
Send messages to Anthropic Claude and update records in Airtable using a custom webhook
Create a Revolut Business draft payment and send an Email notification from a new WooCommerce order
Extract and qualify local business leads and draft cold emails with OpenAI, Apify and Hunter
Content summarizer via Webhook (ApyHub)
Get phone numbers of people in Airtable from Data24
Generate social videos with AI avatars using VEED, Claude, and OpenAI
Automate outbound lead follow-up & qualification
Reviews
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
- JSON blueprint — instant download
- Setup guide PDF included
- 5 downloads · valid 30 days
- Works with n8n
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you