Google Sheets “Append row” writes only to first sheet when node has two inputs and sheet is selected by name #20372
Description
Bug Description
When the Google Sheets 'Append row in sheet' node receives two inputs (two wires into the node) and the Sheet is selected by name (lookup from dropdown), only the first input’s target sheet is used. Items from the second input are appended to the first sheet (or not appended), instead of their intended sheet.
To Reproduce
Below is a test workflow I created to showcase the issue:
Expected behavior
All items reaching the node should be appended according to the node configuration:
- If Sheet is fixed (chosen by name from dropdown), both inputs should append to that single sheet.
- If Sheet is set by expression (e.g. per item), each item should append to its specified sheet.
Debug Info
Debug info
core
- n8nVersion: 1.113.3
- platform: docker (self-hosted)
- nodeJsVersion: 22.19.0
- nodeEnv: production
- database: postgres
- executionMode: regular
- concurrency: -1
- license: enterprise (production)
- consumerId: 35c37a8a-6e16-471e-8303-8b8e87468280
storage
- success: all
- error: all
- progress: false
- manual: true
- binaryMode: filesystem
pruning
- enabled: true
- maxAge: 1440 hours
- maxCount: 0 executions
client
- userAgent: mozilla/5.0 (windows nt 10.0; win64; x64) applewebkit/537.36 (khtml, like gecko) chrome/140.0.0.0 safari/537.36
- isTouchDevice: false
Generated at: 2025-10-03T18:21:32.756Z
Operating System
Ubuntu 22.04.5
n8n Version
1.113.3
Node.js Version
22.19.0
Database
PostgreSQL
Execution mode
main (default)
Hosting
self hosted