I run a small online store, and for a long time our inventory system was me remembering to eyeball a spreadsheet. It worked right up until it didn’t — the way you find out you’re out of something is a customer asking for it, and by then the sale is already gone.
So one of the first automations I ever built was a watcher for the stock sheet. It’s small on purpose. I’m sharing it free in case it’s useful to anyone else running a small operation:
[TEMPLATE URL — added after library approval]
How it works:
- A schedule trigger fires the check (ships weekly, Mondays at 09:00 — daily is a two-click change).
- It reads every row of a Google Sheet with four columns:
Item Name,Stock,Threshold,Supplier. - A plain Filter node keeps only rows where Stock < Threshold. Each item carries its own reorder point, because a case of napkins and your top seller do not run out at the same speed.
- The low rows get aggregated into one list, and an AI agent formats a single email — item, how many are left, how many you need, and who you buy it from — and sends it via Gmail. The AI only does the wording. Detection is the filter; the list it receives is the list it sends.
- If nothing is below threshold, no email goes out. Silence means stocked. An item that stays low keeps showing up in every alert until it’s restocked — a tap on the shoulder, not a mention.
What you need: an n8n instance (Cloud or self-hosted), a Google account for Sheets + Gmail, and a Google Gemini API key from AI Studio (a free-tier key covers this — the formatting call is tiny). Setup is on the canvas in sticky notes, including the two tests to run before trusting any watcher: force one item to zero and watch the “Out of stock” email arrive, then put everything above threshold and confirm the silence.
Honest notes: this was built in February 2026 as one of my first workflows — a training-ground build from my restaurant years, built around a demo café and a sample stock sheet. Full disclosure: it never ran live in production. It sat in my n8n instance, complete and configured, until I pulled it out for this — cleaned up, generalized, and tested end to end (test sheet in, alert email out, silence when nothing’s low) before posting it here. It is a watcher, not an inventory system: it doesn’t count your stock, track sales, or place orders. It reads a sheet you keep current and tells you when a number crosses a line you drew. That one job is the whole point.
If you run a bigger store, the case studies of the full systems behind our shop — the customer assistant, the text club, the voicemail pipeline — are written up here: Automations — Built in a Real Store – GearSpawn LLC — and the packaged versions live on our Gumroad: https://gearspawn.gumroad.com
Happy to answer questions about how it’s put together, and if you adapt it to Slack or Telegram instead of email, I’d be interested to hear how it went.
— Ron, GearSpawn