Lookup google sheet empty value

I found the information here Google sheets - searching for empty values and making unique ids
Currently, n8n supports searching for empty values in ggsheet
But I don’t know how to declare it.
I leave the value blank, but get no results

Hey @admtpu!

I just tested it and it is working for me. Which version of n8n are you using? Can you please upgrade to the latest and try it?

Let me know if you still face issues :slight_smile:

I’m using the latest version n8n docker

Hey @admtpu!

Were you able to resolve this? If not, can please tell if the row is completely or does it have some data in other columns?

Actually this is a bug, I have tried it over and over again
If column is the last column, an empty value cannot be found.
The column on the left is active
I’ve moved that column to the left, and it works

Yeah, it seems like if the field next to the empty field is also empty it does not work. Example:

image

This does not work

This works

image

@admtpu got fixed. We will let you know when is released.

Got released with [email protected]

Are you sure you’ve fixed the bug, I’ve updated to the latest version, and it still doesn’t work.
I will describe with photos
Screen Shot 2021-04-26 at 8.44.14 AM
If I lookup for the value “aaa” then it works

Yes, I fixed it for the first use case. Believe it or not, this is a different use case. Google, for some reason, responds differently depending on how the data is structure. Anyways, I just fixed the issue with this use case as well.

We will let you know when it is released.

Thanks for fixing this, I will follow up and check it out. I will report the error if it still occurs

1 Like

Fix got released with [email protected]