Anyone successfully used the AI Agent with the Google Sheets Tool to Append Data

Has anyone got a workflow demonstrating how to use an AI Agent with the Google Sheets Tool to append data to an existing sheet. I have got the agent to get the data needed and it says that it has appended the data but in all cases the input is empty, but from the chat log of the agent (using open ai) I can see the data was prepared.

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:

I am also seeing the same problem. My AI Agent is passing empty input into the Google Sheets tool, although the logs and output of the AI agent looks correct. It can write to a Google Doc, but not Google Sheets

I am also seeing a problem. The input is always empty unless you can manually map columns.

Did you fix it by manually mapping the columns

It is the only solution that I have found to work so far :woozy_face:

@ZSEA_Banham @Paul_FowlerAI
Unfortunately looks like I am still getting empty input into the Google Sheets tool even after selecting “Map Each Column Manually” under “Mapping Column Mode”


I’m having the same issue here. I’ve tried both methods of mapping columns, but the GoogleSheet Append and Update doesn’t receive any parameters.
I’ve tried using Ollama, OpenAI (gpt-4) and Anthropic. Same results with all.

  • n8n version: Tried with the latest 1.77.1 and 1.76.2
  • Database (default: SQLite): Default
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app): Tried with Docker and n8n cloud
  • Operating system: Windows 11 Pro