Lookup google Sheets - Multiple Values - not adressable in follow up node

Hey there,
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

Hello @timbo, welcome to the community!

Sorry to hear that you have problems! Can you please explain to me what you mean with “However, I am not able to address the multiple lines of the result in the following node.”. How do you want to address them? Do you mean with the expression editor? If so then it should all be fine. It always just displays as example output the value of the first item but will replace the value for each item with a different value. Meaning if you do an HTTP Request it would use each of the values like in this example:

Hope that helps!