AI agent Tool with Google Sheet Node

[Ah_Fu]

I am trying to append a new row in google sheet by using ai agent tool but it is not working.

[Naufal_Fayyadh]

Hello Ah_Fu, welcome to n8n Community!

Can you show what the error looks like?

[Ah_Fu]

main ai agent send data to ai agent tool but it can’t append row in the google sheet

[Naufal_Fayyadh]

In my opinion, you dont need to add an AI Agent Tool, simply connect it directly to your sheet from the AI Agent’s existing tools. Thats my first suggestion.

Then, if you’re still using the AI Agent Tool, in the description section, explain that it has tools in the form of sheets that can do… (fill in what it can do and what is does). You should also add an introduction to the AI Agent’s tools in the System Message/Prompt section so it can use them.

So overall, this seems to be just a matter of prompting the AI Agent, we need to let it know it has the tools it needs.

Maybe thats all i can suggest, hope this is will be works for you!

[Ah_Fu]

Thanks bro, but i already tried with using google sheet under the main ai agent. but not working.

[Senel_Gul_Guzel]

I think, instead of adding the ai agent tool1 to the reservation related system message after the ai agent2 node, you should add the google sheet node to add or update the node after that.