Issue with Incorrect Booking Time and Random Calendar Entries in Vapi to Google Calendar Integration

Hello guys, I have two problems when integrating Vapi with Google Calendar, mainly when booking appointments.

Problem 1: Incorrect booking time When I test the payload from Vapi, the lead is added to Google Calendar, but with the wrong time. Instead of the appointment being added on Friday at 7:00 PM, it will be entered on Friday at 5:00 PM (5:00 PM). I checked the time zone settings in both Vapi and Google Calendar, but the error still persists. It could be a time conversion problem, but I don’t know exactly where.

Problem 2: Random dates in the calendar When I test the AI ​​assistant to book dates, various random dates start to be added to Google Calendar. Although the assistant arranges a meeting, the calendar starts to fill up with random dates. I don’t know if it’s an API problem or something is not working properly with the sync between Vapi and Google Calendar.

I have Google Calendar linked in Make.com, but I don’t know if there is anything special to set up or verify.

Details:

Time Zone: Europe/Prague (I use it in Make.com and Google Calendar)
Error: “Failed to map ‘timeMax’: Function ‘addMinutes’ finished with error! Invalid date.”
Integration: Vapi → Google Calendar (Reservation of appointments)








Can anyone advise me where the problem might be and how to fix it? Thank you!

Hello,

For your first problem, yes it really looks like a timezone issue, since the date entered (5pm) seems to be the conversion of Prague time to GMT. Can you show us how the date appears in the output of your webhook? And the way you set it in GCalendar?

For the second error, can you show us what 2.result looks like? It’s possible you need to use the parseDate function with the relevant date pattern so that Make recognizes it as a date.

Benjamin



Hello Benjamin, I currently have a problem with the fact that when I tested a call with an assistant in vapi, it showed me in make.com that the operation was successful, but the wrong date was entered in my google calendar and several times on the same day, as you can see on the screenshot.

I am also sending a screenshot from vapi calls, where we can see that the function should work correctly.

unction": {
“name”: “Booking”,
“arguments”: “{\n "name": "Jozef",\n "BookingTime": "2023-10-10T11:00:00"\n}”

Where could the problem be this time, please?

Hello,

i’m not sure it’s this, but maybe try to add the function parseDate when you map the date returned by ChatGPT, to make sure it’s interpreted correctly.
It’s because ChatGPT returns a string, so Make can’t interpret its value as a date. And once you did a parseDate with the format of the date returned by ChatGPT, you may need to wrap it with a formatDate function, forcing the pattern Google Calendar expects.

I don’t understand why Calendar repeats the same appointment many time?!?!?

Benjamin

Okay, I made a new scenario, where it already correctly books time, writes both the name and the description in google calendar, but the only problem now is that it cannot find out the information about availability, because when I asked about the date 16.10 at 12:00 pm, it said that it is free and he reserved it, even though it was already booked.

Where, please, could the problem be in this case? I sent screenshots of how I have it set up in Make











Hello, I think,here is the problem,in the filter before itterator step. I dont know how to change that callendar from blueprint. If i deleted it,I cannot find mine calendar there.

@Artemina it’s empty (not colored) because the fields returned by Calendar are dynamic. So it’s more complex to do a mapping. When you did it the first time, there was this field, but not at this execution.
Anyway, is this field an array? You are going through this filter if the array is not empty; is that what you want to achieve?

By the way, it’s very difficult to help you without testing the scenario, checking the behavior of the different modules, running and debugging. May I suggest that you ask for consultancy by one of the Make partners? I’m sure that if someone has a look at your scenario, it will help a lot.

Kind regards,

Benjamin