Automated inventory management with Airtable PO creation & supplier emails

by iamvaar ✓ · 531 views · created 2025-07-09 · Document Extraction

What this workflow does

This workflow has 13 nodes and runs on a schedule (every day) (plus 1 other trigger). Along the way it connects Airtable and Brevo.

How it runs

Trigger: On a schedule (every day) (plus 1 other trigger).

1. Get Products with low stock (Airtable): uses Airtable
2. Get Purchase Orders which are pending (Airtable): uses Airtable
3. Get supplier Details for those low stock products (Airtable): uses Airtable
4. Group products with suppliers (Code): runs custom JavaScript code
5. Calculate Dynamic Re-order Quantity (Code): runs custom JavaScript code
6. Send PO to suppliers via Email (Brevo): uses Brevo
7. Get the record id's of PO (Code): runs custom JavaScript code
8. Search records (Airtable): uses Airtable
9. Update the PO status to sent (Airtable): uses Airtable
10. Remove Duplicate Product Orders (Code): runs custom JavaScript code

…plus 1 more step. See the full node list below.

Services it uses

AirtableBrevo

Before you upgrade to n8n 3.0

Nodes used (4)

• Airtablen8n-nodes-base.airtable
• Coden8n-nodes-base.code
• Schedule Triggern8n-nodes-base.scheduleTrigger
• Brevon8n-nodes-base.sendInBlue

From the author

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…

View the original on n8n.io → Check your own copy