AI Barbershop Assistant (n8n + OpenAI + NocoDB + GoogleCalendar)

Developed an intelligent #AI-assistant for a barbershop that automates client appointments, request processing, and management of master schedules. The system is built on n8n automation, integrates OpenAI / Gemini, Google Calendar API, NocoDB, and supports voice calls via Vapi.ai.

Main functionality:
Automatic selection of available slots
Client booking in the calendar
Processing of text and voice requests
Working with multiple masters (barbers)
Dynamic service management
Saving dialogue history (chat memory)

Solution architecture
1. Database layer (NocoDB)
The system structure is built on tables:
Calendars – master schedules
Persons – barbers
Services – list of services

2. Sub workflows (n8n)
- Get Free Slots:
Gets occupancy through Google Calendar API (Free/Busy)
Processes data via JavaScript (Code node)
Forms a list of available slots
Returns the result via Webhook
- Get Calendars & Services:
Gets current calendars and services
Sends data to the main workflow
- Book Appointment:
Creates an entry in Google Calendar
Books a slot according to the client's request

3. MCP (Model Context Protocol)
Implemented a separate workflow:
MCP – AI Barbershop Assistant
Transforms all sub workflows into tools, connects them to AI via MCP Server, allowing AI to work with the API

4. Main AI Workflow
AI assistant:
analyzes client requests
determines intent (booking / viewing / question)
calls appropriate tools (via MCP Client)
Connected:
OpenAI Chat Model / Google Gemini
Postgres Chat Memory
MCP Client
Webhook / API integrations

Voice AI (Vapi.ai)
The system supports:
receiving incoming calls
voice booking
interactive dialogue with the client

Technologies used:
#n8n (workflow automation)
OpenAI / Google Gemini
#Google Calendar API
NocoDB
Postgres
MCP (Model Context Protocol)
#Vapi.ai (voice AI)
JavaScript (Code node)

Result:
Fully automated booking process
Reduced workload on staff
24/7 client processing
Scalability for any business (salons, clinics, services)

#AI chatbot, #n8n automation, #OpenAI integration, #Google Calendar API, #booking system, #voice bot, #CRM automation, #workflow automation, #AI assistant, #MCP tools, #nocodb, #vapi ai