FREE N8N TEMPLATE · OPERATIONS & HR

This n8n workflow checks your Shopify inventory every weekday morning, finds tracked variants at or below your reorder threshold and groups them by supplier. An AI chat model drafts a reorder email for each supplier, which is saved as a Gmail draft for you to review, and a Slack message lists every low-stock item so nothing runs out unnoticed.

DIFFICULTY
Beginner
SET-UP TIME
About 30 minutes
NODES
10
CHECKED AGAINST
n8n 2.41
  • Shopify
  • OpenAI or Anthropic
  • Gmail
  • Slack

LAST REVIEWED OCTOBER 2026

shopify-low-stock-reorder-alerts.n8n.jsonLOCKED

Get the free workflow

Leave your email to copy the workflow and paste it straight onto your n8n canvas.

FREE · NO CREDENTIALS INCLUDED · CLOUD OR SELF-HOSTED

001 / HOW IT WORKS

Step by step, node by node

  1. 01Run every weekday morning

    A Schedule Trigger with a cron expression starts the workflow at 7am Monday to Friday in the workflow's Australia/Sydney timezone.

  2. 02Get your products

    The Shopify node fetches all products with their variants, SKUs and inventory quantities using an Admin API access token.

  3. 03Find low-stock variants

    A Code node skips inactive products and untracked variants, compares each variant's quantity with a default or per-SKU threshold, and calculates a suggested reorder quantity.

  4. 04Group by supplier

    A second Code node groups low-stock lines by the product's Vendor field and looks up each supplier's ordering email from a list you maintain.

  5. 05Draft the reorder email

    A Basic LLM Chain with an OpenAI or Anthropic chat model writes a short, polite reorder email per supplier, using the exact quantities and no invented prices or dates.

  6. 06Return subject and body

    A Structured Output Parser makes the model return the email subject and body as separate fields for Gmail.

  7. 07Save a Gmail draft

    The Gmail node creates a draft addressed to the supplier. It is not sent, so you can check quantities and add details first.

  8. 08Alert the team in Slack

    A Code node builds one summary of every low-stock line grouped by supplier, and Slack posts it with a reminder to review the Gmail drafts.

SHOPIFY LOW STOCK ALERTS WITH AI SUPPLIER REORDER DRAFTS
◷Every WeekdayMorningSGet Products{}Find Low StockVariants{}Group by Supplier✦Draft ReorderEmail◆OpenAI Chat Model{}Email FormatParser@Save Gmail Draft{}Build SlackSummary#Send Slack Alert

THE REAL WORKFLOW YOU IMPORT · NODE NAMES AS THEY APPEAR IN N8N

002 / WHY IT EXISTS

Running out of a best seller is one of the more avoidable ways a small online store loses sales. Shopify shows stock levels, but someone still has to look, work out what is low, and write to each supplier. In a busy week that check gets skipped, and the first sign of trouble is a sold-out badge or a customer email.

This template is for Shopify store owners and operations staff who order stock from a handful of suppliers and want a daily nudge with the reorder emails already written. It does not send anything to suppliers by itself: the emails sit in Gmail drafts so you can adjust quantities, add pricing and send when ready.

WHO IT'S FOR

  • →Shopify store owners who reorder stock themselves from a few suppliers
  • →Operations or warehouse staff responsible for keeping best sellers in stock
  • →Product brands that use the Shopify Vendor field to record each supplier
  • →Teams that want a daily low-stock list in Slack without opening Shopify

003 / WHAT YOU NEED

Tick them off as you go. Nothing is saved; it's just a checklist.

004 / SET IT UP

  1. 01

    Import the workflow JSON into n8n and read the Setup Instructions sticky note.

  2. 02

    Create an app for your store from the Shopify admin or Dev Dashboard with read access to products and inventory, then add its access token to a Shopify Access Token credential in n8n.

  3. 03

    Make sure each product's Vendor field names the supplier you reorder from.

  4. 04

    In Find Low Stock Variants, set DEFAULT_THRESHOLD and add per-SKU thresholds for fast or slow sellers.

  5. 05

    In Group by Supplier, map each Vendor name to that supplier's ordering email.

  6. 06

    Edit the system message in Draft Reorder Email with your business name, your name and phone number.

  7. 07

    Add your OpenAI key, or swap the chat model for an Anthropic Chat Model connected to the same chain.

  8. 08

    Connect Gmail and Slack, set the #inventory channel to your own, run a test, check the drafts, then activate.

Get the workflow↑

005 / MAKE IT YOURS

  • +Keep thresholds, lead times and supplier emails in Google Sheets instead of the Code nodes.
  • +Base suggested quantities on recent sales by pulling the last 30 days of Shopify orders.
  • +Add a Shopify trigger on inventory level updates for real-time alerts on best sellers.
  • +Skip public holidays by adding a date check after the schedule trigger.
  • +Create a draft purchase order in your inventory or accounting system alongside the email.

FOR AUSTRALIAN BUSINESSES

Inventory and supplier data is mostly business information rather than personal information, but supplier contact names and emails can still be personal information under the Privacy Act 1988 if your business is covered, so share only what the email needs with the AI provider. Shopify, Gmail and the AI provider may store data overseas; if that matters, self-host n8n in an Australian cloud region and choose providers with clear data handling terms. The cron schedule runs in Australia/Sydney time and still fires on public holidays, so adjust it for your state and for suppliers in other timezones; Queensland and Western Australia do not observe daylight saving. Many Australian suppliers quote prices excluding GST, so confirm pricing and GST in their reply rather than relying on anything in the draft.

Need it hosted in Australia? →

006 / TOOLS IN THIS WORKFLOW

007 / QUESTIONS

Anything else is quicker to answer on a call. Thirty minutes, free, with the people who would build it.

Yes. n8n's Shopify node can fetch every product with its variant inventory quantities, and a Code node can compare those with your thresholds. This template runs on a schedule and posts the low-stock list to Slack with reorder drafts in Gmail.

We set up n8n end to end: hosting in Australia, connecting your systems, testing with real data and handing over documentation.

Book a free call→