The Values parameter isn't valid when using the Update Spreadsheet Google Sheets action

This topic was automatically generated from Slack. You can find the original thread here.

Ange B : Hello everyone, I can’t update a google sheet cell… I have an error message telling me that the parameter “values” is not valid. I tried to make an array of arrays as indicated but it doesn’t work. Does anyone have the right syntax for this cell? Thanks (The step is Update spreadsheet values)

Dylan Sather (Pipedream) : HI , let me share a workflow with you, one moment

Dylan Sather (Pipedream) : Take a look at Update Google Spreadsheet Values - Pipedream

Dylan Sather (Pipedream) : I’ve got data in the first row of my sheet - A1:C1 - in this example

Ange B : Ah yes it works now! Thanks a lot for your reactivity! Have a nice evening! :slightly_smiling_face:

Dylan Sather (Pipedream) : great, you too

Pippa Wilder : Hi i had this same issue and your link helped me address it. I had no idea i needed that node.js step. I’m not a programmer so thank you!

Pippa Wilder : Now that i got this fixed i can use pipedream even more.

Dylan Sather (Pipedream) : great! It’s funny, I just updated the workflow to your use case in the other thread :slightly_smiling_face:

Dylan Sather (Pipedream) : glad you got it working

Dylan Sather (Pipedream) : it is often easier to manipulate complex data like this in its own code step