Step 2: Connect Google Sheets

Three Google Sheets nodes read inventory data and log purchase orders.

1. Open Fetch Low Stock Items and select the document ID [YOUR_ID] with the sheet Inventory_Stock (gid 0).
2. In Fetch Low Stock Items, set the filter to Inventory Status equals Low Stock.
3. Open Retrieve PO Records and select the document ID [YOUR_ID] with the sheet Purchase Order (gid 1455016343).
4. In Retrieve PO Records, set filters to SKU equals ={{ $json.sku }} and Order Status equals In Progress.
5. Open Log Purchase Order, set Operation to append, and map columns using the provided expressions such as SKU → ={{ $('Compose Email and PO').item.json.sku }} and Order Status → In Progress.

Credential Required: Connect your Google Sheets credentials.

Step 3: Set Up Processing Logic

The two code nodes calculate reorder quantities and build email/PO payloads.

1. Open Process Stock Orders and confirm the JavaScript logic uses fields like Available Qty, Min. Threshold, Min Order, and Max Order to set reorder_needed and order_qty.
2. Open Compose Email and PO and verify it generates type: "email" and type: "po" items, including po_number and order_date.
3. Ensure the execution flow follows Fetch Low Stock Items → Process Stock Orders → Compose Email and PO.

Step 4: Configure Routing and Supplier Email

Items are routed to email or PO logging based on their type.

1. Open Route Email vs PO and confirm the first rule matches ={{ $json.type }} equals email and renames output to Email.
2. Confirm the second rule matches ={{ $json.type }} equals po and renames output to Purchase Order.
3. Connect the Email output of Route Email vs PO to Dispatch Supplier Email.
4. In Dispatch Supplier Email, set Send To to ={{ $json.supplier_email }}, Subject to ={{ $json.subject }}, and Message to ={{ $json.body }}.

Credential Required: Connect your Gmail credentials.

Step 5: Log Purchase Orders and Prevent Duplicates

This path ensures only new purchase orders are logged and iterates through PO lines.

1. Connect the Purchase Order output of Route Email vs PO to Iterate Order Lines.
2. Ensure Iterate Order Lines sends items to Retrieve PO Records for lookup in the Purchase Order sheet.
3. In Verify Record Presence, confirm the condition checks that ={{ $json['Order Status'] }} exists to detect existing records.
4. Send the false branch (no existing record) to Log Purchase Order so new rows are appended.
5. Route the true branch to Idle Placeholder to skip duplicates, then back into Iterate Order Lines as configured.

Step 6: Test and Activate Your Workflow

Validate the flow end-to-end before enabling daily runs.

1. Click Execute Workflow to run Daily Schedule Trigger manually and pull low-stock items.
2. Confirm Dispatch Supplier Email sends a supplier email and Log Purchase Order appends rows to the Purchase Order sheet.
3. Check that items with existing Order Status in Retrieve PO Records are routed to Idle Placeholder and not logged again.
4. Once verified, toggle the workflow to Active to enable daily scheduling.