Want to append the first row of newly created Sheet using create sheet node

[Digital_Grooming]

Hey there,
I want to add the leads into a newly created Google Sheet, that I create with the create sheet node.

I am just facing the problem, that this sheet obviously doesn´t contain any headers (because its new), so i can´t add any information in there, as the append row node needs headers to match the data to.
Please Help @jabbson

[jabbson]

Hey @Digital_Grooming hope all is good. Thanks for tagging.

The way you can do this is by updating the row with new key value pairs, which you can send from another node or set manually using the Edit (Set) node. Then in the update rows Sheet node you can choose to use automatic mapping - it should allow that for the first time - if the sheet is empty and will set the header row for you.

Here i used a new empty sheet:

then I set the values I want to be appended in the set node:

Finally I allow the Sheet node to figure the headers out:

Which it does:

and the sheet now looks like this:

[Digital_Grooming]

Thanks Man!! it worked