Google Sheets "Bad Request" error when writing to Sheet

Thanks for the workflow @Nicolai, I think I have an idea as to what’s going on here.

The Update operation would require an array representing each row (which itself is represented by an array containing field of the row).

Unfortunately I don’t have your binary file, so can’t modify your exact workflow, but I hope this example helps:

The Create Rows node would return data looking like so:

This will result in a Google Sheet looking like this:

Hope this helps! If you need help with your data transformation it’d be great if you could share the data returned by your Move Binary Data node.

1 Like