Automation · AI Agent

WooCommerce Store Built Around Seven Product Collections for a Salon

Clients text the salon the way they always have. Behind the message an agent reads the service list, checks opening hours, suggests a stylist, takes the booking and writes it back to the sheet the salon already uses.

Results at a Glance

7
Tools available to the agent
2
Channels on one number
1
Sheet as source of truth

A booking system the salon could keep using without learning new software

Salons run on messages. Asking staff to move into booking software they did not choose usually means the software gets ignored and the messages continue anyway.

So the agent sits on the channel clients already use, and writes to the Google Sheet the salon already keeps. Nothing new to learn on either side.

Industry Health & Beauty
Primary Result Booking, rescheduling and recommendation over SMS
Platforms
n8nOpenAITwilioGoogle Sheets
Services
Agent designtool wiringbooking data model

The brief, and where the difficulty sat

An agent that can only answer questions is not a booking system. This one needed to read reference data, write a booking, and update an existing one, which means giving it a set of tools and being precise about what each is allowed to do.

Clients will not change channel

They text. A booking system that needs an app or a portal simply does not get used.

Returning clients expect to be known

Being asked the same questions every visit is the fastest way to feel like a stranger.

The sheet is the real system

The salon already runs on a Google Sheet, so the automation had to write there rather than somewhere new.

Reads and writes are not the same

Separate tools for looking and for changing, so a query cannot accidentally alter a booking.

The challenge was real, and it was costing time, money, and client experience.

How it was built

A Twilio trigger passes the message to an agent running on an OpenAI chat model with simple memory attached, so a conversation holds together across several messages and a returning client is recognised.

The agent has seven Google Sheets tools: read services, suggest a stylist, read a specific stylist, read opening hours, read a booking, append a booking and update a booking. Reads and writes are separate tools, so the agent cannot overwrite something while it is only supposed to be looking.

The solution was designed from the ground up to fit this exact business.

Take the message

A Twilio trigger picks up SMS and WhatsApp on the salon’s existing number.

Give the agent memory

Simple memory keeps the thread coherent and lets a returning client be recognised.

Wire seven tools

Services, stylists, opening hours and bookings, with reading and writing kept apart.

Confirm back

The booking is written to the sheet and confirmed on the same thread.

Tools Used

Each tool chosen specifically for reliability, integration depth, and ease of use for the client.

n8n

Agent and tool orchestration.

OpenAI

Conversation and intent.

Twilio

SMS and WhatsApp in and out.

Google Sheets

The salon’s existing booking record.

What shipped

Bookings taken by message and written straight into the salon’s own sheet.

7
Tools

Read services, stylists, hours and bookings; append and update.

1
Memory

Enough to recognise a returning client mid-conversation.

0
New systems

The salon kept its own sheet and its own number.

Before
Every booking typed in by a person
Returning clients asked the same questions
Double bookings when messages crossed
Reference data held in memory
After
Bookings taken and written automatically
Returning clients recognised in the thread
Reads and writes separated by design
The salon’s own sheet still the record

Next Case Study

Multi-Region Service Site with a Customer Portal
Home Services · Recurring
Multi-Region Service Site with a Customer Portal
A recurring home service operating across four regions, where the site has…

Need a build like this delivered for your agency?

Send me the brief, a Figma file, a reference site or a rough outline, and you'll have a fixed quote with a delivery date within 24 hours.