Inventory Low Stock Alerts

1. Prepare your Google Sheet with columns: Item Name, SKU, Current Stock, Reorder Threshold, Supplier Email. 2. Create a new workflow and add a Schedule trigger node. Set it to run every hour or at your preferred check frequency. 3. Add a Google Sheets node — use the "Read Rows" action. Select your inventory spreadsheet and the correct sheet tab. 4. Add a Filter/IF node — set the condition to check where Current Stock is less than Reorder Threshold. Only items that fail the check should continue. 5. Add a Slack node — use the "Send Message" action. Post to your #inventory-alerts channel with the item name, current stock level, and reorder threshold. 6. Add a Gmail node — use the "Send Email" action. Send an alert to the purchasing manager (or the Supplier Email from the sheet) with the low-stock item details. 7. Test by temporarily setting a high reorder threshold for one item so it triggers, then reset it after confirming the alerts arrive.