How can I write header labels to a google sheet with n8n V1.1.1?

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?

Information on your n8n setup

  • n8n version: 1.1.1
  • Running n8n via: npn (local)
  • Operating system: Windows 10

Hi @Monsterelfe :wave: Welcome to the community! :cake:

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 :slight_smile: That works too.

Thanks for your answer. This is the template I used:
In the screenshot you see, how one could fill the column labels with the old spreadsheet node:

This is the functionality I cannot find in the new Google spreadsheet node.

Hi @Monsterelfe :wave: 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.

Here’s an example workflow of how to do this:


Thanks a lot!
This worked!


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


This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.