Add headers to new Google Sheet

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.

Information on your n8n setup

  • **n8n version: 1.78.0
  • **Database (default: SQLite): SQLite
  • **n8n EXECUTIONS_PROCESS setting (default: own, main): main
  • **Running n8n via (Docker, npm, n8n cloud, desktop app): Docker
  • **Operating system: Easypanel/AWS Lightsail
1 Like
3

Use an HTTP request node. Here you go:

:point_right: If my reply solves you problem, please remember to mark it as the solution.

3 Likes
4

See post How to Create google sheet and add data? - Questions - n8n Community

1 Like
5

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