AI Agents / Customer Support Automation (E-commerce)
Website AI Support Agent
An AI assistant for an online beauty store that answers product, stock, delivery and discount questions, checks orders, and turns problems into support tickets for the team. Built with n8n on two workflows and three Google Sheets.
01 · Overview
System Overview
An AI support assistant built for NOVA SKIN, an online store selling skincare, haircare and fragrance. It lives in the website chat and answers customer questions at any hour. It checks order status against the store's order sheet, and it passes problems that need a person to the team as support tickets, with an email alert.
Tools Used
- n8n
- OpenAI
- Supabase (vector database)
- Google Drive
- Google Sheets
- Gmail
- Webhooks
- React chat widget
02 · Problem
Why the manual process broke down
Online stores get the same questions all day: is it in stock, how much is delivery, where is my order.
- A small team can't answer every question all day, and at night nobody answers at all.
- Slow answers lose sales, and careless ones—like a wrong policy or a promised refund—create returns and angry customers.
- The store needed fast, consistent answers without giving up control of the decisions that need a person.
03 · Solution
How the system works
The chat
- 1A message from the website chat reaches an n8n webhook.
- 2The input is cleaned up, and empty messages stop with a polite reply.
- 3An AI agent reads the message alongside the store's products, prices, stock and policies, and remembers the conversation.
- 4The agent has two tools: look up an order in the Orders sheet, shown only when the order number and phone number both match, or create a ticket in the Tickets sheet.
- 5The reply, with product cards, goes back to the chat.
- 6The conversation is logged to a sheet, and when a ticket is created the team is emailed through Gmail.
The knowledge pipeline
Product and policy files in Google Drive are split into chunks, turned into embeddings, and stored in Supabase, a vector database. This lets the assistant search by meaning as the catalogue grows. Today the chat carries its knowledge directly, and this pipeline is built for when the catalogue outgrows that.
Google Sheets
- Orders: Status, courier, tracking and delivery date.
- Tickets: Every issue the assistant can't resolve, with details, type and priority.
- Conversations: A record of what customers actually ask.
Guardrails
- It answers only from the store's own information and says "I'm not sure" instead of guessing.
- It never promises refunds, because that decision belongs to the team.
- If a customer reports a skin reaction, it tells them to stop using the product and seek medical advice, and flags the ticket as high priority.
04 · Workflow Architecture
Workflow Images
Click any workflow image to inspect individual nodes, branches, and connections at full size.
05 · Connected Interfaces & Outputs
Other Project Images
Supporting database records, team notifications, and client-facing outputs connected to the workflow.
06 · Video Walkthrough
End-to-End Walkthrough
Website AI Support Agent — NOVA SKIN Walkthrough
Live walkthrough of the NOVA SKIN chat assistant, order verification, ticket creation, Google Sheets logging, and Supabase vector pipeline.
07 · Outcome
What the system delivers
- The assistant works end to end on the NOVA SKIN storefront, answering product, delivery, discount, payment and return questions from the store's own information.
- In testing, replies arrive within a few seconds.
- It looks up orders only when the order number and phone number match, keeping order data protected.
- Issues that need judgment reach the team as a ticket with the customer's details and an email alert.
- Every conversation is saved, giving the store a clear view of what customers ask, and when the assistant doesn't know something, it says so and escalates.
Build Something Similar
Want this level of automation in your workflow?
Book a free 30-minute discovery call and we'll map out what can be automated in your stack.