Add new header/ column name in a blank google worksheet

[phuong]

I want to create a flow where an automated process generates a new worksheet. Then, I want it automatically add columns 's name (header) with default values (for example: column 1, column 2…) to that worksheet. How can I do this? Please help me. Thanks very much for your assistance.

Please share your workflow

Share the output returned by the last node

Information on your n8n setup

• **n8n version:1.0.0
• Database (default: SQLite):
• **Running n8n via (Docker, npm, n8n cloud, desktop app):docker

[MutedJam]

Hi @phuong, this is a bit tricky as n8n’s Google Sheets node does not have a specific operation for this. So you’d have to resort to making the necessary API calls through the HTTP Request node here.

Here’s a quick example of how this would look like in a workflow (based on this earlier example workflow):

Running this workflow will produce a Google Worksheet looking like this:

Hope this helps!

[phuong]

I’ll give it a try. Thanks, you have helped me a lot.