How to create spreadsheet with header row

[jay.singh]

How can I create google spreadsheet with first row as header key such as
R0C0- header1
R0C1-header 2

[MutedJam]

Hey @jay.singh, check out this example:

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: [image] This will result in a Google Sheet looking like this: [image] Hope t…

Simply create a fresh sheet before running the operation from the above example and you should be good to go.

[ihortom]

New Google Sheet node is quite different from the older version and appears to be more sophisticated. To be able to add headers to the new spreadsheet I have come up with the following solution

Hopefully it is helpful.