Filter Google Sheets on two columns

Questions
1

Describe the problem/error/question

I would like to update rows in a Google Sheet based on values in two columns in that row. However, I only see one column to use as a filter.

What is the error message (if any)?

No error

Please share your workflow

Information on your n8n setup

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

hello @Jan_Koch
Current node supports the update operation only based on one column. You can add a new column in the sheet and join the values from two or more columns which you need to use in that column, then hide it from the view and use as a key column in the Node

1 Like
3

Hi @barn4k, sorry for the delayed response.
I’ve managed to get it work by modifying the sheet as you suggested.

Thanks!

4

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