Issue with Google Calendar Event Times Using Pabbly Connect

[Wmorkan]

Hello,

I’m encountering an issue with creating events in Google Calendar via Pabbly Connect. Here’s the situation:

I want to generate an event in Google Calendar based on a date received from an email.

Steps I’ve Followed:​

1. Format Conversion:
The email provides the date in the format MMMM DD YYYY HH:mm:ss (e.g., January 22 2006 23:04:05). I convert this to the format required by Google Calendar: YYYY-MM-DDTHH:mm:ss[Z] (e.g., 2018-11-29T13:00:46Z), which works and gives a positive result.

2. Adjusting End Time:
I add 1 hour to the Start Date Time to generate the End Date Time in the same format: YYYY-MM-DDTHH:mm:ss[Z] (e.g., 2018-11-29T14:00:46Z). This also works and provides a positive result.

3. Adding Data to Google Calendar Action:
I input the formatted Start Date Time and End Date Time into the respective fields for the Google Calendar action in Pabbly Connect.

The Issue:​

Instead of scheduling the event for the correct time (e.g., 8:00 AM - 9:00 AM), Google Calendar sets all events to 12:00 AM - 1:00 AM.

Additional Testing:​

• I’ve tried using other Date-Time formats, but they all result in errors (negative values or invalid format messages). The only format that works without an error is YYYY-MM-DDTHH:mm:ss[Z], but it doesn’t correctly read the time.

​

Request:​

Could you please help me resolve this issue? How can I ensure that the correct time is reflected when creating events in Google Calendar via Pabbly Connect?

Thank you in advance for your support!

 

[ArshilAhmad]

Hi @Wmorkan,

Could you please share the Workflow URL where you have this concern? Also, specify the time zone of the time you are inputting into the Date/Time formatters.

 

[Wmorkan]

Hi @ArshilAhmad ,

The workflow URL:

Pabbly - Online Marketing & Sales Software

Automate your sales and marketing with Pabbly. Unite email marketing, lead capture, WordPress themes, subscription all at one place.

connect.pabbly.com

The Time Zone:
America / Vancouver

 

[ArshilAhmad]

Google Calendar API expects the time to be provided in UTC format. So, when you input 2024-11-15T08:00:00Z, it is interpreted as UTC time. Since, 8:00 AM UTC corresponds to 12:00 AM Vancouver time, it appears as such in your Google Calendar.

We suggest using a Date/Time Formatter to add 8 hours to your time (2024-11-15T08:00:00Z), which will give you 2024-11-15T16:00:00Z. You can then feed this updated time to Google Calendar, and it will display as 8:00 AM in your calendar.

 

[Wmorkan]

Hi @ArshilAhmad! Thank you so much! The solution you provided is working perfectly now.

I have another question regarding the workflow:

Pabbly - Online Marketing & Sales Software

Automate your sales and marketing with Pabbly. Unite email marketing, lead capture, WordPress themes, subscription all at one place.

connect.pabbly.com

Unlike the previous case where the date was provided in the format MMMM DD YYYY HH:mm:ss (e.g., January 22 2006 23:04:05), this time the date is given in the format MM/DD/YYYY hh:mm:ss A (e.g., 12/13/2020 05:30:41 PM).

This is the result I’m currently getting. Is there anything I should adjust to ensure the output is in a positive format?

 

[ArshilAhmad]

Please try setting up the Date/Time Formatter in this manner:

 

[Wmorkan]

Thank you so much, @ArshilAhmad ! It worked perfectly. I’ll continue monitoring to ensure people keep booking appointments and that everything runs smoothly.

On another note, I’d like to implement the option for appointments to be added directly from Pabbly Connect to Go High Level, as connecting through Google Calendar has many limitations for Go High Level.

I’m using the "Create Appointment" option:

For "Timezone," I’ve set it to "America/Vancouver." I also tried the timezone displayed in Go High Level, but I keep getting the same error message.

This is the Go High Level account Timezone:

The workflow link:

Pabbly - Online Marketing & Sales Software

Automate your sales and marketing with Pabbly. Unite email marketing, lead capture, WordPress themes, subscription all at one place.

connect.pabbly.com

How do you think I could resolve this?

Thank you, Arshin, for your help!

 

[ArshilAhmad]

Please try using the Date/Time Formatter to convert the time zone of your date from UTC to Vancouver time. Then, pass it to the 'Create Appointment' action step and check if that resolves your issue.

 

[Wmorkan]

Thanks @ArshilAhmad ! I already completed this step, and I got the same result:

When I add that data to the action in Go High Level, this result appears:

I tested it with the personal form, and I still get the same error message.

Is there anything I need to change to keep using the same action, or should I switch to LeadConnector V2?

 

[ArshilAhmad]

Please try using 'LeadConnector V2: Create Appointment' action step.