Google Sheets - Add Multiple Rows

Status: Open · Asked by Dan Cook on · 0 views

Dan Cook — Question ·

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.

Arshil Ahmad — Reply ·

Hi @dan90,

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

Preeti Paryani — Reply ·

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.

Dan Cook — Reply ·

Thanks Preeti
I appreciate you looking into this for me.

Preeti Paryani — Reply ·

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.

Back to all forum threads · Log in to reply