My chatbot works fine with regular text messages (like “hi” or “hello”), but when I ask something that should pull data from Google Sheets, it fails and shows an error. What should I check or fix?
I kinda did the same thing before, but dont use sheet like that. Better use node to get all the rows from sheet, then give it to ai agent to give you the specific data that you’re looking for, and make sure to add it in your prompt. Thats how i did.
But you can try something in this current workflow but im not sure if its going to work. which is specifying to the ai agent in the prompt THE TOOLS, and under it the name of the sheet node, and what to use it for, since i noticed that you didnt specify that in the prompt. you should add something like:
THE TOOLS
products_informations: (what it will do it)
If it works like that its good, if not try to add the node to get all rows from sheet before the ai agent agent, then let him analyze it and give you the right data.
