I have a question:
I try to lookup specific values (1 to n results) in google sheets with the google sheets node lookup functionality.
This works pretty well.
However, I am not able to address the multiple lines of the result in the following node.
I am only able to address the first line (as in a “standard lookup” with the first matching result).
If it doesn’t work at all, is there another workaround? The read functionality cannot be pre-filtered, correct?
My goal is to just receive a set of rows where column X has value Z.
thanks in advance