Vapi AI + Google Calendar API + Make.com Automation for life Insurance Appointment Booking

Posted 6 days ago

Worldwide

Summary

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
  • Intermediate
    Experience Level
  • Remote Job
  • One-time project
    Project Type
Skills and Expertise
Mandatory skills
Python
vapi ai
Make.com
Activity on this job
  • Proposals:15 to 20
  • Last viewed by client:4 days ago
  • Hires:
    1
  • Interviewing:
    10
  • Invites sent:
    10
  • Unanswered invites:
    6
About the client
Member since May 22, 2026
  • MEX
    Delicias, Chihuahua5:41 PM
  • 1 hire, 1 active
  • Sales & Marketing
    Individual client

Explore similar jobs on Upwork

LLM and Prompt Engineering ExpertHourly‐ Posted 1 month ago
Python
LLM Prompt Engineering
Artificial Intelligence
Machine Learning
Computer Vision
Natural Language Processing
Generative AI
Large Language Model
Model Optimization
Hugging Face
OpenAI API
Deep Learning
Multimodal Large Language Model
Web Scraping
LangChain
LLM Prompt
LLM Prompt Engineering
Graph Neural Network
Research Papers

How it works

  • Post a job icon
    Create your free profile
    Highlight your skills and experience, show your portfolio, and set your ideal pay rate.
  • Talent comes to you icon
    Work the way you want
    Apply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
  • Payment simplified icon
    Get paid securely
    From contract to payment, we help you work safely and get paid securely.
Want to get started? Create a profile

About Upwork

  • Rating is 4.9 out of 5.
    4.9/5
    (Average rating of clients by professionals)
  • G2 2021
    #1 freelance platform
  • 49,000+
    Signed contract every week
  • $2.3B
    Freelancers 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

  • Microsoft Logo
  • Airbnb Logo
  • Bissell Logo
  • GoDaddy Logo