Google Sheet Node removes the "=" for formulas

[amindavid11]

Bug Description

when updating/adding a row in Google Sheets, the "=" sign will be deleted in N8N if you close and open the node editor messing up the formulas.

To Reproduce

1. Create Sheet Node
2. Add formula with "=" sign and select "expression"
3. Close node
4. Open Again

Expected behavior

The "=" sign should be left there when using expressions in the fields

Operating System

Ubuntu 22.04

n8n Version

1.68.0

Node.js Version

20.17.0

Database

SQLite (default)

Execution mode

main (default)

[Joffcom]

Hey @amindavid11,

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