Order status and returns assistant: n8n, Shopify and AI sorting
A ready-to-import n8n workflow for online stores. AI sorts every customer message, the workflow finds the order in Shopify, replies with tracking or return instructions, logs returns in Google Sheets and hands damaged items and unclear messages to a person with a holding reply.
Overview
The problem
"Where is my order?" and return requests flood support from Black Friday through January. Most can be answered from data the store already has, but each one still takes a person several minutes.
Automating replies is risky if the workflow answers the wrong customer or approves a return outside the policy, so checks and a human path are essential.
What we built
What we built, piece by piece.
Webhook intake and settings
Customer messages arrive by webhook; one settings node holds the store details and return window.
AI message sorting
An n8n Text Classifier node with an OpenAI chat model sorts each message into order status, return or exchange, damaged or wrong item, or other.
Order lookup with a safety check
Finds the order through the Shopify API and only replies when the order exists and the email matches.
Return window check
Checks the order date against your return window and holiday extension, logs approved requests in Google Sheets and emails instructions through Gmail.
Human hand-off
Damaged or wrong items, unclear messages and failed checks go to a support queue sheet, and the customer gets a holding reply.
Architecture
Order status and returns workflow from the code.
- Input
- AI step
- Logic and services
- Output
- Data
- People
How it flows
- 1 A customer message arrives by webhook and the AI text classifier sorts it.
- 2 Order status questions look up the order in Shopify and reply with tracking only if the email matches.
- 3 Return requests are checked against the return window, logged in Google Sheets and answered with instructions.
- 4 Damaged items, unclear messages and failed checks go to a person, and the customer gets a holding reply.
Tech stack
Project planner
How we would set it up for your store
How we would set it up for your store
Typical time to launch: about 4 weeks, then support
-
01
Discovery
2 days
Your channels, Shopify setup, return policy and what must always go to a person.
-
02
Design
2 days
Categories, reply wording and the hand-off rules.
-
03
Build
1 to 2 weeks
Connect Shopify, your inbox and sheets; tune the classifier on past messages.
-
04
Test
About 1 week
Shadow run on real messages with replies held for review.
-
05
Launch
1 day
Switch on replies for the safe categories first.
-
06
Support
Ongoing
Review hand-offs and adjust categories through the season.
Results
Results, only what you can check.
Free template, ready to import
25 nodes including a Text Classifier, Shopify, Google Sheets and Gmail steps.
Safety checks built in
Email match before any order details are shared, and a human path for anything unclear.
No invented metrics: we do not publish traffic, revenue or user numbers we cannot show you.
The n8n workflow for Black Friday through January returns season: AI sorts every customer message into order status, return or exchange, damaged or wrong item, or other. It finds the order in Shopify, checks the email matches and replies with tracking, checks returns against your return window and holiday extension, logs return requests in Google Sheets and sends instructions, and hands damaged items and anything unclear to a person with a holding reply.
Services used in this project
Free 20-minute call
Want something like this for your business?
Book a free 20-minute call. We will look at how the work runs today, tell you honestly whether it is worth building and give you a fixed quote if it is.
More case studies
All workBookMySpot
BookMySpot helps players find courts, pitches and sports venues near them across the United States and the United Kingdom, then contact the venue directly. It is our own...
Read the case studyMakeItFlow Chrome Extension
The MakeItFlow extension grades the security headers of every page you visit, flags mixed content, insecure forms and third-party trackers, and shows a short corner alert...
Read the case studyMake It Flow Platform
makeitflow.si is our own platform and the site you are on. It runs website audits across speed, SEO, security, email and DNS, offers more than 150 free tools, serves indu...
Read the case study