Google Sheets node doesn't use Data Location on Sheets in Filters

Questions
1

Describe the problem/error/question

Google Sheets node reads first row as a headers in filters without using option Data Location on Sheet.

What is the error message (if any)?

That’s creating a problem that i don’t know which column I need to use and workflow will stop working when I’ll change text in first row.

I need first row to set an instructions to how to use sheets (people doesn’t read comments..)

Sheets →

image
image732×132 4.8 KB

Node →

As you can see filter doesn’t using data location on sheets to update it’s propostions.

image
image1186×814 68.4 KB

Information on your n8n setup

  • n8n version: 1.91.3
  • n8n EXECUTIONS_PROCESS setting: default
  • Running n8n via: docker
2

Hey @rafuru hope all is good.

The filter indeed does not account for the set data location, feel free to file a bug.

3

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