Alert Slack When Airtable inventory Stock Runs Low

On a schedule this checks Airtable inventory inventory levels and pings Slack the moment any product drops below your reorder point — so you restock before you sell out.

difficulty Beginnersetup 20 minresult A Slack alert listing every low-stock SKU and its remaining quantity, delivered before items go out of stock.
  1. 1

    Step 1 — Schedule the stock check

    Add a Schedule Trigger to run a few times a day (busy stores) or daily (steadier ones).

  2. 2

    Step 2 — Read inventory

    Add a Airtable node to fetch products with their current quantities.

  3. 3

    Step 3 — Find the low ones

    Add a Filter/If node keeping only SKUs where quantity is below your reorder threshold (a per-product column works best).

  4. 4

    Step 4 — Alert Slack

    Add a Slack node. Set Resource to Message and Operation to Send. Choose the channel (e.g. #alerts) and drop the list of low SKUs with quantities into the message text using expressions like {{ $json.summary }}. Connect your Slack OAuth or bot-token credential.

Frequently asked questions

Different thresholds per product?

Yes — store a `reorder_point` field per SKU and compare against it in Step 3, instead of a single global number.

Can it create a purchase order too?

Extend Step 4 to also append low SKUs to a "reorder" sheet or draft a PO email to your supplier automatically.

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.