Unable to Sync Google Sheets to Calendar

[Dr. Deepak Rudramoorthy]

Hi I am new to pabbly. I was able to connect my google sheet to pabbly, but when i tried to save and test request it on my google calendar i get a global error. 400 error code. Please help

 

[Pabblymember11]

Hey @Dr. Deepak Rudramoorthy

As we see from your workflow, you haven't passed the Date/Time in the correct format in Google Calendars asks. Kindly make the necessary changes and then try again.

 

[Dr. Deepak Rudramoorthy]

Hi, Thank you for your response. I have changed the format. Now the date which I save in India time zone is not getting saved in the same time zone in the google calendar.

For 2022-07-14T10:30:00Z and 2022-07-14T16:30:00Z it is getting saved as 4pm to 10pm in my google calendar.

please help

Thank you

 

[Pabblymember11]

Hey @Dr. Deepak Rudramoorthy

Could you please share the task id and the screenshot or a short video on how the data & time are being changed? So that we can look into it and can assist you accordingly.

 

[Dr. Deepak Rudramoorthy]

Hi, I am sharing the screenshot of the calendar and the google calendar. I have highlighted the name Jayanthi for your reference.
Please check the time mentioned in the google sheet and the timing triggered on the google calendar
Task Id ?

 

[Pabblymember11]

Hey @Dr. Deepak Rudramoorthy

You have to change the Timezone from your "Google Calendar" action event since the data you are providing is already in IST, so you do not need to change the timezone from your Google Calendar action event. Kindly change it to UTC to balance the Timezone when the event gets created.

 

[Dr. Deepak Rudramoorthy]

Hi I am still getting the same issue. Please help
Task ID -

IjEyNzc1MDg3OCI_3D​

executed at

Apr 14, 2022 12:10:28​

 

[Pabblymember11]

Hey @Dr. Deepak Rudramoorthy

We looked into your concern and it seems like Google Calendar is changing the TImezone by itself from their end.

Though as a solution we have made some workaround in your workflow and we hope this will help you out.

Kindly try again and let us know if that works for you.

 

[Dr. Deepak Rudramoorthy]

Hey, thank you I guess it is working absolutely fine. Please tell me what you exactly did so that I can do the same in my other accounts. Facing the same issue.

Regards
Deepak

 

[Pabblymember11]

Hey @Dr. Deepak Rudramoorthy

In your workflow, we have used "Date TIme Formatter" to convert the timezone to balance out with the time which Google Calendar's API is creating.

Whereas we have used 2 of them to convert the timezone, one for Start Data TIme and another one for End Date Time.