2025 · Retail & inventory
Automated inventory monitoring and low-stock alerts (n8n)
A weekly workflow that reads stock levels from Google Sheets, filters items below their thresholds, aggregates them and uses an AI agent with Google Gemini to send a clear low-stock alert by Gmail.
- Year
- 2025
- Industry
- Retail & inventory
- Platform
- n8n workflow automation
- Client region
- International
- Status
- Delivered to client
The brief
What the client needed
Stock was checked by eye, so items ran out before anyone reordered and purchasing reacted too late.
What we delivered
Shipped to the client
- Weekly schedule reading stock from Google Sheets
- Threshold filter detecting low-stock items
- Aggregation of affected products into one list
- AI agent (Google Gemini) writing a structured Gmail alert
Key features
Fewer stockouts
Low items flagged before they run out.
No manual checks
The sheet is checked automatically every week.
Better purchasing
One clear list of what to reorder.
Technology
Next step
Tell Us Your Problem. We'll Help You Build the Solution.
Tell us what you are working on. You will get a considered reply from an engineer — with questions, a suggested approach or an honest “we are not the right fit”.