AI Customer Support, Consultation Booking & CRM System

AI Customer Support, Consultation Booking & CRM System workflow

An AI-powered customer support system that turns a website conversation into a connected business process — from understanding a prospect’s needs and recommending a solution to scheduling a consultation, updating the CRM, and notifying the relevant people.

The Business Problem

A consultation request can involve much more than simply finding an open time on a calendar. Someone needs to understand what the prospect is actually trying to solve, determine whether the business can help, suggest an appropriate direction, collect the relevant information, schedule the meeting, record what was discussed, and make sure the team has enough context before the conversation takes place.

When those activities are handled across separate conversations, calendars, CRMs, and email threads, the process becomes fragmented and dependent on someone manually moving information from one system to another.

The opportunity was therefore not simply to automate appointment booking. It was to connect the entire path from initial enquiry to a prepared consultation, while keeping the customer experience conversational and the underlying business records structured.

What I Built

At the center of the system is an n8n-based AI customer support agent that acts as the conversational and orchestration layer. A website visitor can describe a business problem in natural language, answer discovery questions, receive a practical solution direction, and move into consultation scheduling without having to navigate a separate booking process.

The agent is also given business-specific context about M-Automations, so its recommendations are grounded in the services and capabilities of the business rather than coming from a generic chatbot. Through n8n MCP, it can also access relevant workflow and node information when reasoning about possible automation approaches.

Behind the conversation, specialized systems handle memory, historical context, scheduling, CRM records, and communication. This keeps the AI responsible for interpretation and orchestration while the connected systems remain responsible for persistent operational data.

01

Conversational Discovery

Understands the visitor’s business problem, asks clarifying questions, and gathers enough context to identify an appropriate next step.

02

Context-Aware Automation Guidance

Uses business-specific context and connected n8n knowledge to identify relevant automation approaches for the problem being discussed.

03

Consultation Scheduling

Interprets requested dates and times, checks availability, confirms the details, and creates the appointment.

04

Connected Records & Context

Connects active memory, historical conversation data, CRM records, calendar events, and notifications into the same customer journey.

The Customer Experience

From the visitor’s perspective, the system begins simply: open the website chat and start a conversation. The interface stays lightweight while the discovery, reasoning, scheduling, and business-system coordination happen behind it.

How the System Works

The architecture separates conversational intelligence from the systems responsible for persistent data and operational actions. The AI agent interprets the conversation, determines what information is needed, and selects the appropriate tools, while the connected systems remain responsible for the records and actions they manage.

Website
Visitor
n8n Chat
Trigger
AI Customer
Support Agent
Specialized
Tools
Business
Systems

The agent is powered by OpenAI GPT-5.4-mini and is configured around customer discovery, automation services, solution qualification, consultation booking, business hours, timezone handling, returning customers, appointment changes, CRM requirements, notification requirements, and use of its connected tools.

PostgreSQL
Active conversation memory
Supabase
Searchable historical conversation context
Current Time Tool
Africa/Nairobi date and time reference for scheduling
Google Calendar
Availability and appointment lifecycle
Airtable
Structured customer and appointment records
n8n MCP
Workflow and node information for automation guidance
SMTP
Client-facing appointment communication
Gmail
Founder and internal notifications

From Conversation to Business Action

The live demonstration shows the full path from a business problem to a completed operational process. The visitor does not need to understand the systems behind the chat; the workflow coordinates them as the conversation progresses.

1
Understand the Problem

The visitor explains what they are trying to improve. In the demonstration, I describe a bakery workflow where I’m using Google Sheets and want to automate order-reminder follow-ups.

2
Find a Relevant Direction

The agent uses the business context it has been given together with connected n8n workflow knowledge to identify a practical automation direction for the problem.

3
Move Into Consultation

Once a consultation is appropriate, the agent collects and confirms the required contact and scheduling details before taking the booking action.

4
Check Availability & Create the Appointment

The system checks the requested time against the calendar. Once the slot is confirmed, the appointment is created and the resulting calendar information is captured for the rest of the workflow.

5
Record the Customer Context

The CRM record stores the customer’s details, booking information, proposed solution, conversation summary, and calendar Event ID so the appointment remains connected to the business record.

6
Confirm & Notify

The customer receives appointment communication while the founder or relevant team member receives the context needed to prepare for the consultation.

Conversation Memory & Historical Context

Conversation context is deliberately separated into active memory and historical retrieval. PostgreSQL maintains the active conversation, while Supabase provides searchable access to previous conversation history when additional context is needed.

This keeps conversational history from becoming a substitute for the CRM. Customer records, appointment information, and conversation history remain distinct data layers that can be brought together when the agent needs them.

Supabase tables showing historical chat data used by the AI customer support system

Beyond the Initial Booking

The workflow was designed around an appointment lifecycle rather than treating a successful booking as the end of the process. The demonstration also tested what happens when the customer needs to change an existing appointment.

RESCHEDULING FLOW
Identify customer Find CRM record Retrieve Event ID Delete original event Collect updated details Check availability Create replacement event Update CRM

In the demonstration, I moved my consultation from 9:00 AM to 11:30 AM. The original calendar event was removed, a replacement event was created, the CRM was updated with the new appointment information, and updated notifications were sent.

The existing CRM record remained the record for that appointment lifecycle rather than creating a second customer record. The calendar Event ID provides the connection between the structured customer record and the operational appointment.

Key Capabilities

AI customer discovery

Natural-language discovery and clarification around the visitor’s business problem.

Business-aware automation guidance

Business-specific context and n8n knowledge help the agent identify relevant automation approaches for the problem being discussed.

Conversational memory

Active conversation context is maintained separately from searchable historical conversation data.

Calendar-aware scheduling

Date and time requests are interpreted with timezone and business-hour considerations before calendar actions are taken.

CRM synchronization

Customer and appointment information is stored in Airtable and connected to the calendar through the Event ID.

Returning customers

Existing CRM records and historical conversation data can be retrieved when continuing a customer interaction.

Appointment lifecycle

Booking, appointment changes, replacement-event creation, and CRM synchronization are handled as connected operations.

Operational context

Internal notifications provide customer, appointment, challenge, proposed-solution, and conversation context needed for the consultation.

Separated system responsibilities

AI handles interpretation and orchestration while external systems remain responsible for persistent operational data.

DEMONSTRATED RESULT

The conversation becomes a completed business process.

In the live demonstration, a visitor described a real business problem, received a relevant automation direction, moved into consultation booking, and triggered the connected operational workflow. The system then handled a rescheduling scenario and propagated the change across the calendar, CRM, notifications, and conversation.

Business-problem discovery Relevant automation direction Calendar appointment CRM record Conversation history Client confirmation Founder notification Appointment rescheduling

Tech Stack

n8n OpenAI GPT-5.4-mini PostgreSQL Supabase Google Calendar Airtable n8n MCP SMTP Gmail
ENGINEERING TAKEAWAY

The strongest AI workflows give the model context, then give the systems responsibility.

The core design decision here was to avoid making the AI responsible for everything. The agent handles natural-language understanding, discovery, decision-making, scheduling interpretation, summaries, and tool selection, while calendars, CRM records, conversation history, and communication systems remain responsible for the operational data and actions they manage. Giving the agent business-specific context and relevant workflow knowledge makes its recommendations more useful, while keeping the underlying systems responsible for the actions that actually change the business state.

Explore the Build

) give the complete new code, position the ‘swipe horizontally’ in the center