Google Sheets Not Appending Appending

Questions
1

my Agent isn’t Appending Rows into the Google Sheet, the name of the sheet is correct. On the execution, the tool changes to the “Get Rows” instead of the “Append New Rows”.
-the tool itself works separately.
-all the credentials are %100 correct.
-the columns mapping is set to automatic(even on the manual it doesn’t work).

2

Can you share your workflow? Specially your agent and Google Sheets Node or Tool Node

3

editor mode
editor mode855×492 54.1 KB

exec mode
exec mode1178×476 99.5 KB

as you can see, on the editing mode, the tool is called “Append Row“ as it should, but after the execution, at the execution mode the tool is called “Get Row“. and now data is sent to the sheet

4

Don’t use the Google Sheets node as a tool. Remove it and add a Google Sheets node after the AI agent (it should be an action node, not a tool). I don’t know why the Google Sheets tool node changes during execution, though.