Google Sheet Append first row (no header)

Questions
1

Hi there,
I am currently building a LeadGen System with n8n and I am encountering a problem. 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. How can I automatically add headers in my Google Sheet, did I miss something?

I am not sharing the workflow here, because it obviously isn´t built yet, as I need this info to keep building.

I self-host n8n via easypanel and aws lightsail, on version 1.78.0.

Thanks in advance for your time.

2

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
3

version: 1.78.0
database: SQLite
n8n EXEXCUTION PROCESS setting: main
running via Docker
Operating system: AWS Lightsail, easypanel

4

Same here I cant add the header

5

I foung a hacky solution:

in this page, you can see a node that is not available in my n8n, just copy to clipboard from that page(right click copy) and paste it in your n8n is going to create a node that is not available in the google sheet nodes

that worked for me.