Google Sheets - Update multiple rows

[dima14]

Hi
i’m trying to use this step: Google Sheets (Update Multiple Rows), v0.12.0.

When using the “+Item” from the UI everything works, but i’d like to use dynamic values to update few of them and i can’t figure it out the correct payload to pass?

the plugin was suggesting me something like
[{“rowId”:“”,“A”:“”,“B”:“”,“C”:“”,“D”:“”,“E”:“”,“F”:“”,“G”:“”,“H”:“”,“I”:“”,“J”:“”,“K”:“”,“L”:“”,“M”:“”,“N”:“”,“O”:“”,“P”:“”,“Q”:“”,“R”:“”,“S”:“”,“T”:“”,“U”:“”,“V”:“”,“W”:“”,“X”:“”,“Y”:“”}]

but for some reason it’s not working

can someone help me?

I’m trying to update an excel file from a previous steps that output the row that i have to change

[kishanprmr]

@dima14

[{“rowId”:“”,“A”:“”,“B”:“”,“C”:“”,“D”:“”,“E”:“”,“F”:“”,“G”:“”,“H”:“”,“I”:“”,“J”:“”,“K”:“”,“L”:“”,“M”:“”,“N”:“”,“O”:“”,“P”:“”,“Q”:“”,“R”:“”,“S”:“”,“T”:“”,“U”:“”,“V”:“”,“W”:“”,“X”:“”,“Y”:“”}]

This is the correct format. Can you share the step configuration and how you are passing the above value for rows?

[dima14]

Hi
thanks for answering, even with manual input the step doesn’t seems to accept the format. It works only when i don’t use dynamic values. Am i doing something wrong?

[kishanprmr]

We have released inline items for this use case. Let us know if you face any issues.

Inline Items

Inline Items Hello there our lovely community We noticed how hard it is when you have a list of items that you want to insert into a specific storage like Google Sheets and the names of properties don’t exactly match the column names, like in here: [webhook content] You would have had to use a code step to do some form of mapping to get past this hurddle. Not anymore though as we are introducing a way to inline items now, all you need to do is clic…