Vapi AI + Google Calendar API + Make.com Automation for life Insurance Appointment Booking
Worldwide
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 Sheets with the appointment result. 9. Prepare the WhatsApp confirmation flow in Make.com. Event title format: Customer Name - Policy [Policy Number] Example: Carlos Pérez - Policy 123456789 Important: The booking logic must not depend only on the AI prompt. The calendar conflict check must be enforced technically by Make.com or a custom API. The AI assistant will speak with clients in Mexican Spanish, but the technical setup and documentation can be in English. Deliverables: * Working Vapi custom tool. * Working Make.com scenario or custom API. * Google Calendar conflict checking. * Calendar event creation without double-booking. * Structured response back to Vapi. * Google Sheets update. * Basic WhatsApp confirmation structure. * Short documentation or Loom video. Please start your proposal with the word “CHIHUAHUA” so I know you read the full post. Questions: 1. Have you built Vapi custom tools before? 2. Have you worked with Google Calendar FreeBusy or conflict checking? 3. Would you build this with Make.com only or with a small API? Why? 4. How would you prevent double-booking? 5. How long would it take to deliver a working version?
$200.00
Fixed-price- IntermediateExperience Level
- Remote Job
- One-time projectProject Type
Skills and Expertise
Activity on this job
- Proposals:20 to 50
- Last viewed by client:yesterday
- Interviewing:11
- Invites sent:10
- Unanswered invites:6
About the client
- Mexico10:35 AM
- Sales & MarketingIndividual client
Explore similar jobs on Upwork
How it works
Create your free profileHighlight your skills and experience, show your portfolio, and set your ideal pay rate.
Work the way you wantApply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
Get paid securelyFrom contract to payment, we help you work safely and get paid securely.
About Upwork
- 4.9/5(Average rating of clients by professionals)
- G2 2021#1 freelance platform
- 49,000+Signed contract every week
- $2.3BFreelancers earned on Upwork in 2020
Find the best freelance jobs
Growing your career is as easy as creating a free profile and finding work like this that fits your skills.
Trusted by