Inventory Tracking Automation for Airtable

Video Introduction [](https://youtu.be/4CQ3o7qChIs)

Want to automate your inbox or need a custom workflow? [📞 Book a Call](https://smoothwork.ai/book-a-call/) | [💬 DM me on Linkedin](https://www.linkedin.com/in/mil%C3%A1n-v%C3%A1s%C3%A1rhelyi-3a9985123/)

---

Overview

This workflow automates the complete purchase order cycle for Airtable-based inventory management using n8n. It continuously monitors your stock levels, automatically creates purchase orders when inventory falls below reorder thresholds, and sends formatted order emails to suppliers—eliminating manual tracking and reducing stockout risk.

The system handles three critical automation processes: ensuring each supplier always has a draft purchase order ready, intelligently adding products to those orders based on forecasted stock levels versus threshold quantities, and automatically emailing suppliers when orders are approved for sending.

Key Features

- Automated stock monitoring: Hourly checks identify products that need reordering based on customizable threshold levels - Smart purchase order management: Automatically creates and maintains draft purchase orders for each supplier - Supplier email automation: Sends formatted order details directly to suppliers when purchase orders are ready - Movement-based ledger: Tracks every stock-in and stock-out transaction for complete audit trails - Test data generator: Includes a manual-trigger workflow to simulate random sales orders for testing