Google Sheet sync to Google Calendar using personal account

[TER]

Your Task History ID

IjU3NjYwNTZhMDYzNjA0MzQ1MjZjNTUzMTUxMzIi_pc

Hi i'm getting error message in creating an event in Google calendar.
Step 1 - the tool extension has been added onto Google sheet.
Step 2 - the test data is not sending thru
please help. thanks

This is my workflow

Pabbly

connect.pabbly.com

 

[Preeti Paryani]

Hello @TER,

Thank you for sharing the details.

Upon checking, the issue appears to be with the date that’s being mapped in the action step, it isn't in the required format. We attempted to format it correctly using the Date/Time Formatter, but the date received from the trigger lacks complete information, particularly the year, which is resulting in an incorrect date being generated.

Could you please ensure that the date from the trigger is either in the format 2020-04-28T09:30:00Z (YYYY-MM-DDTHH:mm:ss[Z]) or includes the full date and time details? This will allow us to assist you more effectively.

Looking forward to your response.

 

[TER]

hi i've update the format as suggested.
ALso including the T and Z as per your sample text but its still an error

question,
i have headers, date - start, date - end and remarks
And the column of of the dates are already pre-filled. & when one of the cells under remarks. are added.
Only at this point i want a calander event to be created.

What setup would you suggest?

 

[ArshilAhmad]

The date you were trying to map had a space after the year. We've removed that space from both the Start and End dates, and it seems to have resolved the issue.