Handle Spanish-speaking vet clinic bookings with GPT-4o, Sheets, Calendar and Gmail

Overview Meet Maria, a sophisticated AI Booking Agent designed for Veterinary Clinics (but easily adaptable to any service business). This workflow transforms a simple chat interface into a full-scale administrative assistant that handles client lookups, lead generation, and scheduling without human intervention.

Key Features Intelligent CRM Lookup: Automatically checks Google Sheets to see if a customer is a "New" or "Existing" client.

Automated Lead Capture: If the client doesn't exist, the agent collects their details and creates a new entry in real-time.

Full Calendar Management: Maria can Get, Create, Reschedule, and Delete appointments directly in Google Calendar.

Smart Escalation: Uses a "Human-in-the-loop" logic; if a query is medical or complex, Maria triggers a Gmail notification to alert the professional staff.

Dual-Model Reliability: Powered by OpenRouter, utilizing GPT-4o for complex reasoning with built-in fallback support.

How it works Normalization: Incoming phone numbers are cleaned to ensure database consistency.

The Brain: The AI Agent uses a Window Buffer Memory to maintain context throughout the conversation.

Tooling: Maria is equipped with custom tools for Google Sheets (Database), Google Calendar (Booking), and Gmail (Escalation).

Confirmation: No appointment is finalized until the agent confirms the date and time with the user in natural language.

Setup Instructions Credentials: Connect your Google Sheets, Calendar, and Gmail accounts.

API: Add your OpenRouter API key to the AI Agent node.

Sheet ID: Update the Google Sheets nodes to point to your specific Spreadsheet.

Timezone: Ensure your n8n Workflow settings match your local clinic's timezone.