Using AI agent tool for syncing Google spreadsheet
r
rajesh.ad45
I want to save my chat details like user question, AI response into Google spreadsheet.
Below is the approach which I had used to acheive this with automation:
- Give input parameters Date, User Question, AI response in AI Agent Tool
- Mapped these input parameters to spreadsheet columns
Issues I am facing:
- When posted a question all the details like date and user question are being inserted inside the date column instead of date and user question columns.
- AI agent is not returning the response for my question
Video Recording:
Log In
j
jiawei.kek
Hi there. Thanks for reaching out.
It seems here that your AI agent used the default "addrow" tool, instead of the one you created.
You need to check a few things:
- Have you enabled the tool you created, on the AI Agent?
- If so, you may also want to specify in your prompt, for the AI to use that tool. This will ensure the AI knows to use that particular tool in response.
e.g "Using the __ Tool, do ___"
I've found that making a command with this initial prompt (and adding the other instructions when you use the command) is the most consistent and easy way for the Agent to call the correct tool.