Google Calendar Posting at wrong times

Hello community,

I am using Make to create an automated booking system for a barbershop. The process works as follows:

  1. A customer sends a WhatsApp message to book an appointment.
  2. 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).
  3. 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:

  1. Ensured that the extracted time from OpenAI GPT is correct and matches the intended time.
  2. Verified the time zone settings in Google Calendar and in Make.com.
  3. 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)

2 Likes

Welcome to the Make community!

Please provide the output bundles of the modules by running the scenario (or get from the scenario History tab), then click the white speech bubble on the top-right of each module and select “Download input/output bundles”.

A. Upload as Text File

Save each bundle contents in your text editor as a bundle.txt file, and upload it here into this discussion thread.

B. Insert as Formatted Code Block

If you are unable to upload files on this forum, alternatively you can paste the formatted bundles.
These are the two ways to format text so that it won’t be modified by the forum:

  • Method 1: Type code block manually

    Add three backticks ``` before and after the content/bundle, like this:

    ```
    content goes here
    ```

  • Method 2. Highlight and click the format button in the editor

Providing the input/output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.

This will allow others to better assist you. Thanks!

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

@Pagos_Puntu

You should have your timezone selected in settings.

Regards,
Msquare Automation - Platinum Partner of Make
@Msquare_Automation

2 Likes

Did this get resolved? I’m also having the same issue.

1 Like

Hi Selda, yes. Thanks to @Msquare_Automation. A bit of an oversight on my part not checking the timezone. Thanks!

1 Like

Hi @Pagos_Puntu

Glad to know that your issue is resolved now.

Best regards,
Msquare Automation
Platinum Partner of Make
@Msquare_Automation

2 Likes