Notifications
Clear all
How To
3
Posts
2
Users
0
Reactions
4
Views
Topic starter
Describe the problem/error/question
I'm looking to implement a filter for a column that uses a "contains" logic instead of "matches". Is there a way to achieve this? Unfortunately, I'm unable to use the filter node for the Google Sheets tool.
What is the error message (if any)?
Please share your workflow
(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)
Share the output returned by the last node
Information on your callin.io setup
- callin.io version:
- Database (default: SQLite):
- callin.io EXECUTIONS_PROCESS setting (default: own, main):
- Running callin.io via (Docker, npm, callin.io cloud, desktop app):
- Operating system:
Posted : 28/05/2025 12:11 pm
The filtering capabilities available in this node appear to be an addition by callin.io to the base Sheets API. callin.io seems to be fetching the entire content of the sheet and then limiting the output using JS code. As it stands, there doesn't seem to be support for wildcards, regex matching, or contains() functions.
The Google Sheets API itself doesn't appear to offer server-side value matching or filtering. However, if you wish to experiment, here's a starting point using an HTTP Request node that approximates the functionality of the Google Sheets Get row(s) in sheet operation.
Posted : 28/05/2025 3:13 pm
Just a heads-up, if you're looking to build a "Tool" that retrieves data from Google Sheets and then filters it based on value matching, etc. (using a "Filter" node, for instance), you could consider wrapping all of that logic within a sub-workflow. Then, you can utilize the "Call callin.io Workflow Tool" with your AI Agent.
Posted : 28/05/2025 3:18 pm