Auto PO creation on low stock + supplier emails

# Automatically create POs on low stock and send supplier emails via Brevo

This automation template helps business owners and logistics teams minimize manual work in procurement management. The system regularly checks inventory levels in Airtable, calculates reorder quantities, and sends formatted purchase orders to suppliers via Brevo, ensuring full traceability and operational efficiency.

## Who it´s for
- SMB owners using Airtable for inventory tracking
- Logistics managers automating supplier procurement
- Inventory teams needing regular synchronization with suppliers
- Entrepreneurs aiming to reduce manual ordering tasks

## What the automation does
- Triggered daily via cron schedule (midnight and 1:00 AM)
- Analyzes low-stock products in Airtable
- Calculates reorder quantity based on sales data and lead time
- Checks for existing active POs to prevent duplicates
- Groups pending orders by supplier
- Sends HTML-formatted emails via Brevo
- Updates order status to ´Sent´ in Airtable

## What´s included
- Ready-to-use n8n workflow
- Cron-based trigger and handler logic
- Integrations with Airtable, Brevo (SendInBlue), and Email API
- Basic text instructions for setup and adaptation

## Requirements for setup
- n8n account (cloud or self-hosted)
- Airtable account with inventory and purchase order tables
- Brevo (SendInBlue) account with email sending configured
- Access to API keys for all listed services

## Benefits and outcomes
- Eliminates human error in order calculations
- Reduces risk of stockouts
- Saves time on daily inventory monitoring
- Clear audit trail with automatic status updates
- Reliable delivery of POs without manual intervention
- Maintains optimal inventory levels automatically

## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via chat