Google Sheets - Add Multiple Rows

[dan90]

I am trying to get the "add multiple rows" event to work in my workflow but it keeps throwing back json errors.
I have tried structuring the data in many different ways. I even manually wrote it all out as a test and it threw back same errors:

Error code 400
Invalid JSON payload received. Unknown name "0" at 'data.values[0]': Cannot find field.
Invalid JSON payload received.
INVALID_ARGUMENT
type.googleapis.com/google.rpc.BadRequest
data.values[0]

And it repeats that for every single value I am trying to add.
The test data isn't complex, its simple names and numbers.

This is the new layout of pabbly I am using.

 

[ArshilAhmad]

Hi @dan90,

Could you please share the Workflow URL where you have this concern?

 

[dan90]

Pabbly Connect

connect.pabbly.com

 

[Preeti Paryani]

Hello @dan90,

I tested the issue both under your account and on mine. However, due to some ongoing updates in the new beta version, I wasn’t able to complete the testing. From what I can see, this seems to be working fine in the classic version.

In the meantime, I recommend continuing with the classic version or waiting until the temporary issue with the new UI is resolved. Once it is fixed, I will test it again and update you accordingly.

 

[dan90]

Thanks Preeti
I appreciate you looking into this for me.

 

[Preeti Paryani]

Hello @dan90,

The issue with the Add Multiple Rows action for Google Sheets in the new UI has been resolved. You can now use this action in the new UI as well. Please give it a try at your end and let us know if you face any issues.