Error 400 - Sheets to G. Calendar

[GuiWeb]

Your Task History ID

IjU3NjAwNTY0MDYzMjA0M2Q1MjY5NTUzZDUxMzU1MTY2NTQzMyI_3D_pc

Hellos people!!

I'm trying to send data from my Google Sheets to my Calendar but getting error 400. The weird part is: When I'm send the test on the setup page, everything works fine, but when comes to the Sheets, it gets the error. Even if I try to send the same data (A1 from sheets) gets the same error
The prints:

 

[ArshilAhmad]

Hi @GuiWeb,

Based on your Task History, I can see that the data you have mapped in Google Calendar is not coming from Google Sheets, which is why you are facing this error.

Please try to re-establish the connection with your Google Sheets spreadsheet and attempt to capture the correct response.

If you are entering the data in your Google Sheets through an API or through another application, then make sure that 'Auto Send on Schedule' is also enabled.

Also, make sure that the Trigger Column is the last column in your spreadsheet where the data is entered, so that the data entered in columns before it is also sent.