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.