Hey there n8n community!
I’m using the Google Sheets node as an agent tool, and I’ve got some output data that looks something like this, and, despite there not being a contains filter, I’m fine with it for now:
However, the bigger problem is that, regardless of what I do, the agent can only seem to view the first row!
Is this a limitation of the Google Sheets node? It can only filter exact matches, and agents can only read the first row (first json element)?
I did find this point in the help docs: “In sub-nodes, the expression always resolves to the first item. For example, given an input of five name values, the expression {{ $json.name }} always resolves to the first name.”
Thanks!
