I am having trouble with the start and end dates on my google calendar module

Beginner Questions
1

:bullseye: What is your goal?

I want to make an appointment through retell and send the information to make, have it go through my google sheet, and through google calendar to make an appointment on google calendar. I have all of the information correct but I cant seem to get the appointment scheduled on google calendar.

:thinking: What is the problem?

The start and end dates arent working on google calendar no matter what I put.

:test_tube: What have you tried so far?

I have tried almost everything I have seen, so many variations of parseDATE and addHOURS and so on. I have a screen shot attached to show what I have most recently tried. If this attempt looks horribly wrong I have tried many others so I would love for someone to get back to me.

4

This is a very common (and frustrating) Google Calendar issue in Make and 90% of the time it comes down to date format + timezone + structure mismatch

My solution: UNDERSTAND YOUR INPUT (From Retell) then COMBINE DATE + TIME make sure to then PARSE INTO REAL DATE ensure to FIX TIMEZONE (CRITICAL) then CREATE END TIME and MAP INTO GOOGLE CALENDAR

5

Hey Kenneth,

can you reupload your screenshot? Its missing.