← Back to projectsAutomation · Real project
Inventory & Stock Alert System
PythonGoogle Sheets APIpandassmtplibTwilio
Automatically monitors stock levels from Google Sheets or ERP, sends email and WhatsApp alerts when a product falls below the minimum, and triggers an automatic order to the supplier when the critical level is reached.
app.dtdigital.it/magazzino● Scanning inventory
Inventory & stock alerts
Scan0%
Monitors stock · alerts on low levels · auto-orders when critical
Critical2auto-order
Low stock2alert sent
Orders sent0to suppliers
Items monitored6every 2 minutes
Stock levelsUpdated live
| Product | Stock | Min | Status |
|---|---|---|---|
| Espresso Blend 1kgSKU-001 | 8 kg | 20 kg | Critical |
| Packaging boxes (S)SKU-002 | 45 pcs | 30 pcs | Low stock |
| Cleaning suppliesSKU-003 | 120 pcs | 50 pcs | OK |
| Specialty Roast 500gSKU-004 | 12 kg | 25 kg | Critical |
| Paper cups 8ozSKU-005 | 280 pcs | 200 pcs | OK |
| Milk — full fatSKU-006 | 18 L | 40 L | Low stock |
Automation actions
ScanBelow min?AlertOrder
Daily stock scan at 07:00Email alert on low stockAuto-order on critical levelSupplier confirmation log
Activity logLive
Scanning...
Integrates with
Google Sheets, ERP, email, WhatsApp, supplier APIs