Our own product, not client work n8n workflow template

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.

Customer message Webhook Sort message Text classifier Find order Shopify API Return window Policy check Reply Gmail Returns log Google Sheets Support queue Person checks
  • Input
  • AI step
  • Logic and services
  • Output
  • Data
  • People

How it flows

  1. 1 A customer message arrives by webhook and the AI text classifier sorts it.
  2. 2 Order status questions look up the order in Shopify and reply with tracking only if the email matches.
  3. 3 Return requests are checked against the return window, logged in Google Sheets and answered with instructions.
  4. 4 Damaged items, unclear messages and failed checks go to a person, and the customer gets a holding reply.

Tech stack

n8n Webhook Text Classifier node OpenAI chat model Shopify Admin API Google Sheets Gmail

Project planner

How we would set it up for your store

A typical plan for connecting this template to your own systems. Durations depend on the tools you use.

How we would set it up for your store

Typical time to launch: about 4 weeks, then support

  1. 01

    Discovery

    2 days

    Your channels, Shopify setup, return policy and what must always go to a person.

  2. 02

    Design

    2 days

    Categories, reply wording and the hand-off rules.

  3. 03

    Build

    1 to 2 weeks

    Connect Shopify, your inbox and sheets; tune the classifier on past messages.

  4. 04

    Test

    About 1 week

    Shadow run on real messages with replies held for review.

  5. 05

    Launch

    1 day

    Switch on replies for the safe categories first.

  6. 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.

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.

Book a free 20-minute call