Smart inventory & expiry tracker

Manually tracking expiry dates across an inventory doesn't scale — items get missed, stock ends up wasted, and every update means opening a spreadsheet by hand.

A Telegram-based inventory assistant: staff add, update, or remove stock just by messaging the bot — text or voice — and an AI agent parses the request and updates a Google Sheet accordingly. Separately, a daily automated check scans the inventory for items expiring within a month, sends a Telegram alert, and flags the item as "alerted" in the sheet. Alerted items are automatically cleared out a week later, so the sheet never fills up with stale entries.

Click to zoom ↗

Actual production workflow, built in n8n

Inventory updates (via chat):
Telegram message (text or voice)
   → If (route by type)
   → [voice → transcribe]
   → AI Agent (OpenAI + MongoDB memory + structured output parser)
   → Switch (append / update / delete row)
   → Google Sheets updated
   → Confirmation sent on Telegram

Expiry monitoring (daily):
Schedule trigger → scan sheet → items expiring within 1 month
   → Telegram alert → mark row as "alerted"

Cleanup (scheduled):
Schedule trigger → find rows alerted 7+ days ago
   → delete from sheet