How to address case when Google Sheet lookup fails


I have a node for Google Sheet Lookup. It’s looking for a value in a certain column. I have an IF node based on whether on not a value is found in that column. However, the Google sheet Lookup Node fails when there is no value. I tried setting Always Output Data too.
When data is not returned

When data is returned

How do I set this up?


I guess you can do in the expression something like your expression || "". Probably the expression is resolving to undefined that is why the node is erroring.