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!
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!
HI @aya
Have the same issue, and in error message system can see that Header rows were changed, but in the interface part “Values to Send” there are no changes no matter how many times I try to refresh.
What version are you on @romanl?
The fix for this issue was released with [email protected] (as it was mentioned in description of this released PR#13116) so if you’re on a version before that, could you try upgrading?