edit: I guess I figured it out. The “isEmpty()” is a boolean function and has no output it just checks in the node if it’s true or not. For my workflow I got it running with a setup that looks like this
Now I need to figure out how I can get this loop to auto run, because I have to check the google sheets every single time before I delete it. If anyone has any idea how to improve upon this please feel free to share
I want to delete rows in a google sheet when the column “expired” is not empty but I can not get the filter function within the google sheets node to work.
I’m sorry it took us a bit to get to your question, but I’m very glad you managed to make it work on your own!
What do you mean when you say you want to get the loop to auto run? Do you mean what would be the best way to trigger an execution with the workflow in active mode?
well the question still remains can I filter in the google sheets “get rows” node a column that is not empty? I know how to filter for empty but I need only rows that have a value in the “expired” column. I could not find a expression that works.
If I can filter right there I can simplify my workflow and do not have to add a filter node
