Hi!
I have this working wonderfully, going as far as having a very complex branching Google Form submitting to different boards based on the selections made in the form, very awesome!
However, I can’t figure out why the DateColumn is not working. I’ve tried more formats than I can count both in the active Sheet and converting it using JavaScript before using JSON.stringify(cellValue).
Going from the example, I was hoping sending the date as a string in the format of YYYY-MM-DD would work, but I get:
API results: {“error_code”:“ColumnValueException”,“status_code”:200,“error_message”:“invalid value, please check our API documentation for the correct data structure for this column. https://monday.com/developers/v2#column-values-section",“error_data”:{“column_value”:“2020-08-08”,“column_type”:"DateColumn”}}
I looked at this post, but shouldn’t JSON.stringify(cellValue) be handling the formatting automatically?
Example strings I’ve sent to JSON.stringify();:
2020-08-08
{"date":"2020-08-08"}
{“date”:“2020-08-08”}
{"date":"2020-08-08","time":"13:25:00"}
I’m sure it’s something silly that I’m missing 
Thanks!