What is your goal?
I want an AI agent module search a row into a specific sheet from a payload scenario input.
For example, AI Agent get the payload from my payment solution and then searching into my sales database to change status to « paid ».
What is the problem & what have you tried?
How to do so? Should I add « Google Sheets - Search a row » as an AI Agent module skill?
Also, should I add « Google Sheets - Update a cell » to change the status column on its own ?
HI Garry, add as a tool to the Make AI Agent (New) for search row and a separate tool for update row if you need it to update also. Specify each tool name clearly in your Agent prompt and what the agent needs to look for and update via which tool specifically
Thank you. I will try and back to you.
Why an agent though? What is the input like and cant you use the Search module directly?
You’re right @Stoyan_Vatov . It would be too long to explain, in few words, at least 50% of inputs for Search module are writing from humans. For those inputs including spelling mistake, guideline error… I have to fix them manually (around 10-15 minutes everyday).
In my opinion, only AI Agent might do the job. What do you think?
Yeah, if the input is messy I 100% agree with you. If the list is static, you can add it as a knowledge file as well to tell the AI what to look for in the incoming text.