Add new header/ column name in a blank google worksheet

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

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!


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

1 Like

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