Searching Google Sheet for condtions

Questions
,
1

Coming from Make how can I replicate the Google Sheets Search module?

I have used the ‘Get Rows in Sheets’ node. But I can’t seem to get the filter right.

How do you add conditions? Such as ‘If Exists’ or ‘Contains’?

Thanks

2

It looks like your topic is missing some important information. Could you provide the following if applicable.

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

I’m not sure if this is best way to it, but I achieve it by searching the whole sheet without filters in the node being set, then using the filter node.

Hope it helps someone.

Coming from Make it takes some getting used to ‘not being Op’s conservative’

4

Hey @Rob you can do it by using nodes’ filters

image
image813×956 41.3 KB

5

@Rob Are you looking to filter rows when retrieving them or filter after getting all data?

6

Here is clear step by step solution:
In n8n’s Google Sheets node:

  1. For “Contains”: Use filter syntax Column Name contains "value" in the “Get Rows in Sheets” node’s Filter field
  2. For “If Exists” (non-empty): Use Column Name != ""

Alternatively, add a Filter node after your Google Sheets node for more complex conditions with visual configuration options.

7

Thank you. But I didn’t know what to put in the value for. If Empty, or contains ‘a’

8

Thank you. The filter node was best for me. Works great