Google sheets Filters

Questions
1

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?

n8n-filters-google
n8n-filters-google538×899 56.1 KB

(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
2

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

3

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

4

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.

image
image371×263 3.71 KB

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

image
image1318×627 43.2 KB

Hope that helps.