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
001 / HOW IT WORKS
Step by step, node by node
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.
02Get your products
The Shopify node fetches all products with their variants, SKUs and inventory quantities using an Admin API access token.
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.
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.
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.
06Return subject and body
A Structured Output Parser makes the model return the email subject and body as separate fields for Gmail.
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.
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.
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
- 01
Import the workflow JSON into n8n and read the Setup Instructions sticky note.
- 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.
- 03
Make sure each product's Vendor field names the supplier you reorder from.
- 04
In Find Low Stock Variants, set DEFAULT_THRESHOLD and add per-SKU thresholds for fast or slow sellers.
- 05
In Group by Supplier, map each Vendor name to that supplier's ordering email.
- 06
Edit the system message in Draft Reorder Email with your business name, your name and phone number.
- 07
Add your OpenAI key, or swap the chat model for an Anthropic Chat Model connected to the same chain.
- 08
Connect Gmail and Slack, set the #inventory channel to your own, run a test, check the drafts, then activate.
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
n8n
AUTOMATION & AGENT PLATFORMS
A workflow automation platform that combines a visual node editor with code when you need it. It connects hundreds of apps and APIs and includes AI agent nodes that can call language models, tools and memory. Teams can self-host the free Community Edition on their own servers or use n8n's hosted cloud.
Best for australian organisations that need automation data to stay onshore
Onshore possibleFreemiumIntermediateShopify Magic
MARKETING TOOLS
Shopify's suite of AI tools built into the store admin. It writes product descriptions, blog posts and email copy, edits product photos, generates theme sections, and includes Sidekick, an assistant that can analyse store data and carry out admin tasks from plain-language requests.
Best for small Shopify retailers without an in-house copywriter
OffshoreFreeBeginnerChatGPT
OpenAI · ASSISTANTS & CHATBOTS
OpenAI's general-purpose AI assistant. It handles writing, coding, file and image analysis, data analysis and web research through a chat interface, with an API for building it into your own systems.
Best for small and mid-sized teams wanting one general assistant for everyday writing and analysis
AU optionFreemiumBeginnerClaude
Anthropic · ASSISTANTS & CHATBOTS
Anthropic's AI assistant, known for careful reasoning, long-document analysis, writing and coding. It can work through large documents and codebases in a single conversation, paid plans include the Claude Code agentic coding tool, and it is available through an API and major cloud platforms.
Best for legal, policy and consulting teams reviewing long documents
Onshore possibleFreemiumBeginner
MORE TEMPLATES
All templates →- 10 NODESAI
OPERATIONS & HR
Daily Business KPI Digest from Stripe, Shopify and GA4
StripeShopifyGoogle Analytics 4OpenAI or AnthropicIntermediate~45 minutes→ - 15 NODES
OPERATIONS & HR
Appointment Confirmations and SMS Reminders with Calendly and Twilio
CalendlyTwilioGmailIntermediate~45 minutes→ - 10 NODESAI
OPERATIONS & HR
AI Meeting Notes and Action Items to Notion
Google DriveOpenAI or AnthropicNotionGmailIntermediate~30 minutes→
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→