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.
1 Like
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
1 Like
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 
@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
is there anyone solve this issue?
It is not allowing mapping of fields, when dragging and dropping it allowed in the first 2 fields, I have several, from the third onwards it does not allow, you drag and n8n does nothing.
This issue still happening, the only thing it created is a row with spreadsheet ID and sheet ID
Is this a call to another workflow or it is in your main one ?
I have a workflow that is working - output is from the ai agent to the append row sheets node, I didn’t have any issue setting this up - worked straight away, however make sure you use a JSON output from the AI node, you select this in settings.
The columns were mapped manually :
I tried setting map column mode to automatic for the tool and it never really worked out. So I just made a separate workflow that takes in the formatted JSON data from the agent and pass it to the basic Google Sheets append node with automatic column mapping mode. I use this tool in place of the sheet tool for the agent.
So far it works fine, but make sure your agent formats the JSON correctly, so each field maps to the correct column name in your sheet.
i am facing similar problem with Google sheets, hey do you remember how you resolved it?
