Can this pull stock levels automatically from my POS?

If your POS exposes an inventory API, wire it in to update the sheet automatically instead of manual counts.

Will I get alerted every day for the same item?

Yes, until restocked above threshold — add a 'snooze' column if you want to suppress repeats after ordering.

Restaurant & F&BStructurally Validated

Low-Stock Inventory Alert

Every morning, this scans your inventory sheet and automatically flags items at or below their reorder threshold, alerting your team on Slack and emailing the manager with the supplier to reorder from — so you never run out mid-service.

Automation flow

Step 1

Daily Trigger

Runs every morning at 6am.

Step 2

Read Inventory Sheet

Pulls all inventory items.

Step 3

Filter Low Stock Items

Flags anything at or below threshold.

Step 4

Reorder Alert

Slack notification for the team.

Step 5

Manager Email

Names the supplier to reorder from.

How it works

1Every morning at 6am, the full inventory sheet is read.
2Any item where quantity on hand is at or below its reorder threshold is flagged.
3Your team gets a Slack alert, and the manager gets an email naming the supplier to reorder from.

Services used

Google SheetsSlackGmail

What you'll need

An n8n Cloud or self-hosted account
A Google account (Sheets)
A Slack workspace (optional)

What's included

No-code setup in 15 minutes
Prevents mid-service stockouts
Per-item reorder threshold, fully customizable
Supplier info included in the alert

Estimate what this could save you

Times per week

Minutes each time

Your hourly value ($)

3.6 hours/month

≈ $108/month in your time

A rough estimate based on what you enter above — not a guarantee. Actual time saved depends on your process.

Make it yours

Update Quantity On Hand automatically from your POS system if it exposes an inventory API, instead of manual entry.
Add a Last Ordered column and skip alerting again if an order was placed in the last 3 days.
Group alerts by supplier into one email per supplier instead of one per item.

Works well with this automation

Catering Inquiry Router

Catering inquiries are logged, routed to sales on Slack, and auto-replied to with your menu.

$15

Ad Platform Lead Router

Meta/LinkedIn Lead Ads leads are instantly logged, auto-replied to, and pushed to sales on Slack.

$22

AI Customer Survey Insights Digest

Collects Google Forms survey responses as they arrive, then has AI write a weekly digest of sentiment, themes, and standout quotes.

$22

Save with the complete system: Real Estate, Hospitality & Events Bundle

Instead of buying separately: $177 — System: $79

View system

Questions about this template

$15one-time

Secure checkout via Polar. Delivered by email instantly.

Structurally validated: automatically checked for valid n8n format before every deploy.

Difficulty: Easy
Setup time: ~15 min
Integrations: 3
Node count: 5
Format: .json + guide