The low-stock alert I wish I'd had: a Google Sheet that emails you before you run out

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:

  1. A schedule trigger fires the check (ships weekly, Mondays at 09:00 — daily is a two-click change).
  2. It reads every row of a Google Sheet with four columns: Item Name, Stock, Threshold, Supplier.
  3. 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.
  4. 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.
  5. 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

Quick note for anyone who found this useful: this little alert is the small example. The bigger production systems we actually run the shop on — the support agent, the upload pipeline, the whole Bench — live on our Gumroad: https://gearspawn.gumroad.com — if you’re wondering what the full builds look like, that’s where they are.