Hello community,
I am using Make to create an automated booking system for a barbershop. The process works as follows:
- A customer sends a WhatsApp message to book an appointment.
- I use OpenAI GPT to extract the required details: the service, the barber, the date (in DD/MM/YYYY format), and the time (in HH:mm:ss format).
- These details are then sent to Google Calendar to create an event.
While everything else works perfectly, I have noticed that the event in Google Calendar is always posted one hour earlier than the time extracted from the customer’s message.
Google Calendar:
For example:
- If a customer books an appointment for 19/12/2024 at 15:00, the event gets posted in Google Calendar at 14:00 instead of 15:00.
Steps I have already tried to troubleshoot:
- Ensured that the extracted time from OpenAI GPT is correct and matches the intended time.
- Verified the time zone settings in Google Calendar and in Make.com.
- Checked if there’s any conversion happening within the Make.com flow.
Despite these checks, the issue persists, and I can’t figure out why the event is being shifted by one hour.
Any guidance or insights on what might be causing this issue and how to fix it would be greatly appreciated.
Thank you in advance!
Blueprint (1).json (89.0 KB)