How to select Google Sheets rows by their ID

[Josip_Sare]

Describe the problem/error/question

I want to get a row in Google Sheets if the certain cell column is equal to a certain number. The problem is that that Sheet doesn’t have column names in the first row, but second, so I want to map the column by their ID (ie. AB) and I am wondering how to do that. In my case that column would be D

What is the error message (if any)?

Please share your workflow

Share the output returned by the last node

Information on your n8n setup

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

[Olek]

You can specify the params of your table. E.g.

The only downside, in the filters you will need to put column names manually as the node mechanism will not suggest columns for you to pick among.

If this answers your question, please mark this post as a Solution.