Problem in Get Row(s) in Google Sheets node

[ferriblima]

Bug Description

I'm using n8n version 1.90.2.

When we try to use the Google Sheets node to Get Row(s) with mode than one spreadsheet id input, it always output the data from the first spreadsheet id only as many inputs as we have.

To Reproduce

1. Create two or more spreadsheet files in google drive and create the access credentials in n8n.
2. Create a Code node to return two or more spreadsheets ids.
3. Connect it to a Google Sheets node to retrieve data from the previous node spreadsheet id. ({{ $json.id }})
4. Run

{ "nodes": [ { "parameters": {}, "type": "n8n-nodes-base.manualTrigger", "typeVersion": 1, "position": [ 1440, 1380 ], "id": "76c41461-6af6-4b48-9ea7-5cd2a2dd5918", "name": "When clicking ‘Test workflow’" }, { "parameters": { "jsCode": "return [\n {\n json: {\n id: \"111111\"\n }\n },\n {\n json: {\n id: \"222222\"\n }\n }\n];\n" }, "type": "n8n-nodes-base.code", "typeVersion": 2, "position": [ 1640, 1380 ], "id": "76f8f254-7ada-43b1-b715-e95a9b5fec3d", "name": "Insert Spreadsheet Ids" }, { "parameters": { "documentId": { "__rl": true, "value": "={{ $json.id }}", "mode": "id" }, "sheetName": { "__rl": true, "value": "=Example name", "mode": "name" }, "options": {} }, "id": "a7732695-d9bf-4627-b124-0736e6f205fe", "name": "Get Data from both spreadsheets", "type": "n8n-nodes-base.googleSheets", "typeVersion": 4.5, "position": [ 1860, 1380 ], "alwaysOutputData": false, "executeOnce": false, "credentials": { "googleSheetsOAuth2Api": { "id": "pfD2tgKAOCrCgl0E", "name": "Google Sheets OAtuh2 API (838537817582)" } } } ], "connections": { "When clicking ‘Test workflow’": { "main": [ [ { "node": "Insert Spreadsheet Ids", "type": "main", "index": 0 } ] ] }, "Insert Spreadsheet Ids": { "main": [ [ { "node": "Get Data from both spreadsheets", "type": "main", "index": 0 } ] ] } }, "pinData": {}, "meta": { "templateCredsSetupCompleted": true, "instanceId": "7dcb374634a987ef53826c12daca117d2e99b7cf55151c1d0f05fcc0520f9258" } }

Expected behavior

Retrieve data from both spreadsheets.

Operating System

Mac ARM - Sequoia 15.3.2

n8n Version

1.90.2

Node.js Version

20.19.1

Database

MySQL

Execution mode

main (default)

[Joffcom]

Hey @ferriblima,

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

[TheAnh1811]

i have same proplem. When using 'Get Row(s)' with multiple Google Spreadsheets, i only receive data from the first spreadsheet.

[michael-radency]

Hi @ferriblima , thanks for the report!
We're closing this issue as it's working as intended.

The documentId and sheetId parameters serve as stable identifiers for the target resource and are not meant to change once set. This is consistent with how we handle operation and resource parameters, which are also not changeable.

Many UI components and logic—such as filters used in GET operations—depend on these fixed identifiers. For example, if a user sets filters and the sheetId changes, it could lead to errors due to schema mismatches (e.g., different columns). This becomes even more critical for operations like append or upsert, where data consistency is essential.