Google Sheets Append a Row - Expressions do not work with multi-line headers

[huntersneed]

Bug Description

When trying to append a row to an existing sheet, you are unable to change from a fixed input type in a field to an expression input. The expression cannot be selected in the UI of n8n if the header has a new line in it (example below). For single line header columns, this issue does not occur.

(Chapter
Qty)

To Reproduce

1. Create a google sheet with multiple headers. Ensure that a few of the headers are multi-line.
2. In n8n, once configuring the google sheets credentials, select the google sheets append a row action
3. Select manually map columns and try and change any of the multi-line header columns from fixed to expression.

Expected behavior

A column should be able to be changed to an expression regardless of whether or not the column header has a single line or multiple lines.

Operating System

MacOS

n8n Version

1.45.1

Node.js Version

Unknown

Database

PostgreSQL

Execution mode

main (default)

[Joffcom]

Hey @huntersneed,

Thanks for the report, I have managed to reproduce this and have created NODE-1427 as the internal ticket to get this resolved.