I’m using google sheets in my case to append data to an existing sheets.
I would like to know if there’s a way to modify the Header row number in the “Value to Send” options (like, I don’t want the node to select the row number one, but the row number 2)
If your headers are not in row 1, you can select Map Automatically mode for mapping column. Then, set Header Row option to 2. You can use Set or Code node to prepare your data.
I believe Header Row option should effect columns that in Map Each Column Manually mode… I never noticed this because I always use Map Automatically mode. I’l try to contribute.
It looks like @giulioandreini has taken a look and found the same issue, We have created an internal bug ticket to look into this which we are tracking as N8N-6666