Can this pull stock levels automatically from Shopify or my POS?

This version reads a Google Sheet. Pulling stock straight from Shopify or a POS can be set up as part of Store Automation Setup.

Will I hear about the same item every day?

It stays in the daily summary until restocked above its threshold, so it's one line in one message, not a separate alert.

Restaurant & F&BStructurally Validated

Low-Stock Inventory Alert

Every morning this reads your inventory sheet and, if anything is at or below its reorder threshold, sends one summary to Slack and one email to the manager, with out-of-stock items first and the supplier for each. On days when everything is stocked, nothing is sent.

Automation flow

Step 1

Daily Trigger

Runs every morning at 6am.

Step 2

Read Inventory Sheet

Pulls every item, quantity and reorder threshold.

Step 3

Build Low-Stock Digest

One summary of low items, out-of-stock first.

Step 4

Reorder Alert

One Slack message for the team.

Step 5

Manager Email

One email listing each item and its supplier.

How it works

1Every row with a name, a quantity and a threshold is checked. Rows with a blank quantity are skipped rather than treated as zero.
2Anything at or below its threshold goes into one summary, out-of-stock items first.
3Slack gets one message and the manager gets one email. If nothing is low, nothing is sent.

Services used

Google SheetsSlackGmail

What you'll need

An n8n Cloud or self-hosted account
A Google account (Sheets + Gmail) and a Slack workspace

What's included

One daily summary instead of a message per item
Out-of-stock items listed first
Supplier shown next to each item
Silent on days when nothing is low

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.

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.

Bad file or a duplicate charge? We'll make it right — Refund Policy.

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