Google sheets Filters

Good day.

In Node Google shield get row there are filters
Select a column and value. If you need to filter the “Price” column by a specific value (1 or 10 or 50) or by an empty value - I understand that. But how to filter by:
price is greater than 20?
or the price is not equal to an empty value?

(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)

Share the output returned by the last node

Information on your n8n setup

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

The filters in google sheets are very simple. I suggest to use fetch all rows from the sheet and use either a Filter or a Switch node

Thank you. Is it possible to do this with filters inside the Google Sheets node?

Hi @koordinator7 ,

I agree with Franz’s solution.

For more complex filters, another workaround I’ve found useful is to add a helper column directly in the Google Sheet (here with the example ‘Filter 20’). In this column you can add your complex formula and have a Boolean as an output.

Then in the n8n Google Sheets node, just filter based on that helper column being TRUE.

Hope that helps.