Skip to main content
Maleek Odesanya

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

Workflow 1

The chat

  1. 1A message from the website chat reaches an n8n webhook.
  2. 2The input is cleaned up, and empty messages stop with a polite reply.
  3. 3An AI agent reads the message alongside the store's products, prices, stock and policies, and remembers the conversation.
  4. 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.
  5. 5The reply, with product cards, goes back to the chat.
  6. 6The conversation is logged to a sheet, and when a ticket is created the team is emailed through Gmail.
Workflow 2

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.

Workflow 1 (Editor Canvas) — Website Chat Webhook -> Prepare Input -> Has message? -> AI Support Agent (OpenAI Chat Model, Conversation Memory, lookup_order, create_ticket) -> Format Reply -> Respond, Log conversation, and Notify Team.
n8n Execution Run (Succeeded in 7.615s) — Top: Workflow 2 knowledge pipeline (Clean Old Vectors -> Search KB Folder Files -> Download File Text -> Supabase Vector Store with OpenAI embeddings & Recursive Character Text Splitter). Bottom: Workflow 1 chat nodes all green.

05 · Connected Interfaces & Outputs

Other Project Images

Supporting database records, team notifications, and client-facing outputs connected to the workflow.

Google Sheets (Nova Skin Operations) — Conversations log capturing customer messages, structured agent replies, and timestamps alongside Orders and Tickets tabs.
Supabase Vector Store (`nova_skin_documents`) — chunked product and policy documents with JSON metadata and vector embeddings.

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.

Watch on YouTube

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.

Back to projects