I have a scenario that processes almost 400 fields and adds/updates them in a Monday board and a Google Sheet. Of the hundreds of requests that are processed each day, exactly one is causing an error in a Google Sheet step that pauses the scenario. The error is cryptic:
Any field that is a date gets processed using scripting to the format we want. (See image below.) I have checked every field in the scenario and there are no non-date fields with the scripting code in them. There are also no incoming fields that are not a date. I checked the output bundle from the webhook and there are no date fields with anything other than a date in them.
I saw the phrase ‘values.348’ in the error and checked whether that was a Sheet column. Converting to column nomenclature yields NM, which is a text field and doesn’t have the date formatting in the scenario. I’m also stumped by the fact that it says ‘’ is not a valid date. We have blank dates in every request, so why would this one instance cause problems?
I have no idea what to check next. Any ideas?