Description
Title: Vapi AI + Google Calendar API + Make.com Automation for Appointment Booking Description: I am Hugo Rojas, a MetLife insurance advisor in Mexico. I need help finishing an automation system for my personal insurance advisory business. The system uses Vapi AI to call existing clients in Spanish and schedule appointments for a dividend withdrawal process. I need a reliable workflow that checks my real Google Calendar availability, prevents double-booking, creates the event, updates Google Sheets, and later supports WhatsApp confirmations through Make.com. Current setup: * Vapi assistant is already created. * OpenAI API is connected. * Google Calendar is connected. * Google Sheet is already created. * WhatsApp Business Cloud is connected to Make.com. * WhatsApp templates are already approved by Meta. * Vapi’s native calendar tools caused timezone and double-booking issues, so I need a more reliable solution. Main task: Build a reliable booking tool using either Make.com or a small custom API. The tool must: 1. Receive appointment data from Vapi: * customer name * policy number * date * time * product * phone number if available 2. Handle Chihuahua, Mexico timezone correctly. 3. Check Google Calendar for 30-minute availability. 4. Prevent overlapping appointments. 5. Create the event only if the time slot is free. 6. If the requested time is busy, return a busy response and ideally suggest 2 available alternatives. 7. Send a structured response back to Vapi. 8. Update Google