# Low-Stock Purchase Order Automation

**Category:** Manufacturing  
**Tools:** Google Sheets, Gmail, Code  
**Nodes:** 12  
**Built by:** Forgent Systems

Finds products below their reorder level every day, generates purchase orders, emails suppliers and keeps a PO log in Google Sheets.

![Workflow](preview.webp)

## How it works

1. A daily trigger reads low-stock products.
2. Existing purchase orders are checked to avoid duplicates.
3. A PO and a supplier email are generated for each item.
4. The order is emailed and the PO is stored in the sheet.

## Use cases

- Manufacturers and workshops
- Wholesalers and distributors
- Retail back-office

## Data setup

**Google Sheets** (tab: columns)

- **Inventory Management → Inventory_Stock**: `Inventory Status`
- **Inventory Management → Purchase Order**: `SKU`, `Order Status`, `PO Number`, `Supplier`, `Supplier Email`, `Item Name`, `Available`, `Order Qty`, `Order Date`

## Setup

1. In n8n open **Workflows → Import from File** and choose `workflow.json`.
2. Connect these credentials:
   - Gmail account
   - Google Sheets account
3. Point the Sheets / Airtable / Drive / Slack nodes at your own resources (structure above).
4. Replace placeholder emails, phone numbers and `YOUR-FORM-ID` links with your own.
5. Times use the America/New_York timezone and dates use MM/DD/YYYY. Adjust if needed.
6. Run a test execution, then activate.

## Nodes

- **Send Order to Supplier** — `n8n-nodes-base.gmail`
- **Switch Email & PO** — `n8n-nodes-base.switch`
- **Generate Email & PO** — `n8n-nodes-base.code`
- **Order Handling** — `n8n-nodes-base.code`
- **No Operation, do nothing** — `n8n-nodes-base.noOp`
- **Loop Over Items** — `n8n-nodes-base.splitInBatches`
- **Trigger Everyday** — `n8n-nodes-base.scheduleTrigger`
- **Get Low Stock Product** — `n8n-nodes-base.googleSheets`
- **Get Purchase Order** — `n8n-nodes-base.googleSheets`
- **Check Record Exists Or Not** — `n8n-nodes-base.if`
- **Store a Purchase Order** — `n8n-nodes-base.googleSheets`
- **Sticky Note** — `n8n-nodes-base.stickyNote`
