AI Agent Tool - Limiting Google Sheet Rows

I’m building an AI Agent to help categorize my transactions in Google Sheets. I want to provide a tool to the AI Agent to get a list of transactions for a category it provides. The problem is that there are thousands of rows per transaction.

It seems that tools don’t have the same chaining ability that normal nodes do, so I can’t add a “Limit” node. I could just build an “example” sheet that has limited transactions but I was wondering if this is possible somehow.

You can try playing around with the filters to find out what works best for you:

To add meaningful filters, you will have to figure out a formula and set it prior to the execution so that it can be called within the tool:

Howdy! Thanks for your reply. I don’t see how you’re able to extract the date in your workflow and present it to your Google Sheet tool. I think there’s a 404.

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.