Daily inventory monitoring workflow that scans Google Sheets for premium extension items below threshold and sends Slack alerts when stock falls under 5, with Gmail error reporting for failures.
n8n · workflow canvasproduction build
Context
Operations teams needed an automated way to watch premium extension inventory levels every day and get alerted immediately when stock dropped below a critical threshold.
Approach
Built two connected n8n workflows: the main flow runs on a daily schedule, reads the inventory sheet, filters for Premium Extension items with stock under 5, and posts a Slack alert only when low stock is detected; a separate error path emails the admin on failures.
Architecture
Cron schedule
Google Sheets fetch
aggregate rows
filter for category Premium Extension and stock < 5
