E-commerce & Dropshipping · n8n

Draft Purchase Orders Automatically When Warehouse Stock Runs Low

Keep shelves stocked without spreadsheets — when inventory dips below its reorder point, auto-draft a purchase order to the right supplier for review.

difficulty Intermediatesetup 40 minresult Low stock triggers a ready-to-send purchase order, preventing stockouts while keeping a human in control.
  1. 1

    Schedule Stock Checks

    Add a Schedule Trigger running daily over your inventory sheet.

  2. 2

    Find Items Below Reorder Point

    Add a Code node selecting SKUs whose stock has fallen below their reorder threshold.

  3. 3

    Group by Supplier

    Add a Code node grouping the low items by supplier so each PO covers one vendor.

  4. 4

    Draft the PO

    Add a Gmail node creating a draft purchase order per supplier with SKUs and reorder quantities for your approval.

  5. 5

    Activate and Test

    Activate the workflow and set a test SKU below its reorder point. Confirm a supplier-specific PO is drafted.

Frequently asked questions

Why draft instead of auto-send?

A quick review prevents ordering against a data glitch and lets you adjust quantities for promotions or seasonality.

Can it factor in lead times?

Yes — set reorder points based on each supplier's lead time so stock arrives before you run out.

About this recipe. Recipes on FlowRecipesHub are written for business owners, not developers, and are tested before publishing — how recipes get made. Some ingredient links are affiliate links that cost you nothing — full disclosure.