Alert Slack When Google Sheets inventory Stock Runs Low
On a schedule this checks Google Sheets inventory inventory levels and pings Slack the moment any product drops below your reorder point — so you restock before you sell out.
- 1
Step 1 — Schedule the stock check
Add a
Schedule Triggerto run a few times a day (busy stores) or daily (steadier ones). - 2
Step 2 — Read inventory
Add a
Google Sheetsnode to fetch products with their current quantities. - 3
Step 3 — Find the low ones
Add a
Filter/Ifnode keeping only SKUs where quantity is below your reorder threshold (a per-product column works best). - 4
Step 4 — Alert Slack
Add a
Slacknode. SetResourcetoMessageandOperationtoSend. 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.