Alert Telegram When Airtable inventory Stock Runs Low
On a schedule this checks Airtable inventory inventory levels and pings Telegram 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
Airtablenode 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 Telegram
Add a
Telegramnode. SetOperationtoSend Message, enter your chat ID, and build the message from the list of low SKUs with quantities. Create the bot with @BotFather and add its token as a 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.