How can I write header labels to a google sheet with n8n V1.1.1?
I try to rebuild a functioning workflow fetching data from YouTube and writing it into a Google worksheet. I created this workflow by adapting the Template " Read XML file and store content in Google Sheets". With the old google sheet node this workflow works like a charm. Now I try to change the google nodes to the latest version as recommended (I get a message “New node version available: get the latest version with added features from the nodes panel.” in the node).
With the new node I cannot find a way to create a new sheet and fill it with my data. There is a node action to append/update a sheet, which works only, if you have already column labels in your google sheet. And there is another action to create an empty sheet. But I don’t see any possibility to fill this empty sheet, as it has no headers.
Did I miss something or does the new version of the google sheet node really lack some essential functionality the old had?
Could you share the workflow that’s working for you? There may indeed be a change in the node that could have affected this, depending on the previous version of the older Google sheet node.
You can copy and paste your workflow by hitting cmd/ctrl + A and then cmd/ctrl + C, and then placing it between two sets of three backticks (```). Alternatively, you’re free to link me to the template That works too.
Hi @Monsterelfe Sorry for the delay but this took a bit of digging! You’d have to create the sheet, and then append the columns afterwards - the auto-map should take care of the columns.
Just found out that you don’t have to make a new sheet. You can make a new spreadsheet file (a node I called “Create new spreadsheet file”) and then use the first and only sheet with “Sheet” - By URL - Expression - {{ $(“Create new spreadsheet file”).first().json[“spreadsheetUrl”] }}#gid=0
Welcome to the community! 
That works too.