Help

Append row to Google Sheets error: "Row Data" could not be converted to a string

Topic Labels: Automations
2129 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Myanmar_Witness
4 - Data Explorer
4 - Data Explorer

I have an automation that converts input data into MD5 using custom script and the script’s output along with a field from the table is appended to the Google Sheet. All steps work when testing. But when running all at once using ‘rerun’ or through the form (the trigger is when “When a record is created”), all steps work except appending into Google Sheet, with the error "Row Data" could not be converted to a string..

Any help is much appreciated.

3 Replies 3
Nate_Hughes
5 - Automation Enthusiast
5 - Automation Enthusiast

Same. I am having a similar issues.

kennypurnomo
7 - App Architect
7 - App Architect

Same issue here. … I did run the test and it is success though

NCamper
4 - Data Explorer
4 - Data Explorer

Got the same error at first, but noticed I didn't have my primary field filled out. Once I ran the automation again with the primary field filled it worked!