Error Using Google Sheets Tools with AI Agents to Update a Sheet: "Invalid data[0]: Unable to parse range:"

[souzagaabriel]

Bug Description

When I use the sheet tool to update a value in a spreadsheet, I get this error:

{ "message": "Bad request - please check your parameters", "timestamp": 1739971715611, "name": "NodeApiError", "description": "Invalid data[0]: Unable to parse range: TEste Nome!B20 ", "context": {}, "cause": { "message": "400 - {"error":{"code":400,"message":"Invalid data[0]: Unable to parse range: TEste Nome!B20 ","status":"INVALID_ARGUMENT"}}",

To Reproduce

Complete workflow:
Sheet_Tool_AI.json

Expected behavior

In this scenario, we would expect it to update the row, since as we can see in the following image, everything is correct in the Column to match on and Values to Update parameters:

Operating System

22.04.5 LTS

n8n Version

1.74.3

Node.js Version

20.18.1

Database

PostgreSQL

Execution mode

queue

[Joffcom]

Hey @souzagaabriel,

We have created an internal ticket to look into this which we will be tracking as "GHC-896"

[souzagaabriel]

Just a note: In the example I've put here, the name of the sheet is with a space “TEste Nome” on purpose, it was a test of mine because I had already tested the name of the sheet without a space as well.