In my case:
- I want to add an ID to new row in google sheet.
- I generate a random ID by “function” node.
- search my table in google sheet to find that I have that generated id or not by google sheet" node.
- if there isn’t that id I create new row with that random id.
my problem is:
after search my table in google sheet (by lookout in google sheet node) how can I use null output in “if” node.
How can I use something like this:
if search results = 0 then true
I think One Option is add “empty” and “not empty” in string in “if” node.