Google Sheets node 'Data location' feature not working properly

Questions
,
1

Describe the problem/error/question

Hi everyone,

I’m trying to append data to a Google Sheets form, but my data table doesn’t start at row 1—it begins at row 5. I used the ‘Data location on sheet’ options in n8n and set the ‘Header row’ to 5, expecting the column list to update accordingly. However, the column list remains unchanged, and it doesn’t reflect the headers starting at row 5.

To investigate further, I created a mock Google Sheet with the cell values labeled (e.g., A1, A2, B1, B2, etc.). Even with this simplified setup, n8n still fails to recognize the correct starting row for the column headers.

It seems that neither the ‘Header row’ nor the ‘First data row’ settings impact the column list retrieval.

Has anyone else experienced this issue or found a workaround? Any help would be greatly appreciated!

image
image520×507 18.7 KB

image
image446×827 15.1 KB

Information on your n8n setup

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

Hi @VYX,

Welcome to the community :tada:

Tip for sharing your workflow in the forum

Pasting your n8n workflow

Ensure to copy your n8n workflow and paste it in the code block, that is in between the pairs of triple backticks, which also could be achieved by clicking </> (preformatted text) in the editor and pasting in your workflow.

```
<your workflow>
```

Make sure that you’ve removed any sensitive information from your workflow and include dummy data or pinned data as much as you can!

This sounds like a bug, will report this internally and keep you posted!