Google Sheets Node is Not Evaluating Expressions (Writes Raw Text)

[Digital_Assets]

Hello,

My Google Sheets node is not evaluating any expressions. It writes the raw expression text (e.g., {{ $json.seriesTitle }}) into the cells instead of the actual data. This is preventing my workflow from functioning.

We have confirmed this is a bug in the node itself after extensive troubleshooting:

• The node can write static, plain text correctly. The problem is specific to {{ }} expressions.

• The issue happens with both the “Append or update row” and “Append row” actions.

• The “Append or update” action fails to find a match because it searches for the raw expression text, not the evaluated value. This causes it to incorrectly append a new row instead of updating an existing one.

• We used a Set node to pre-render all data perfectly, but the Google Sheets node still fails to evaluate even simple expressions like {{ $json.fieldName }} that point to this clean data.

• The issue occurs with both the $json.fieldName and the $nodes['NodeName'].json.fieldName syntax.

My workflow logic is correct, but the Google Sheets node itself is not functioning as expected. Any help would be greatly appreciated.

[jabbson]

Hey @Digital_Assets hope all is good.

Are the cells you put the values to of an expression type of fixed?
Could you attach your workflow or a minimal workflow illustrating the issue?

[jabbson]

The JSON you provided has issues with syntax, for example:

there are 5 places in JSON like that.

Could you instead embed the workflow. Click on the link to see how.

[Digital_Assets]

[jabbson]

Just as I suspected the fields are marked as Fixed
In order for the expression to evaluate, change the type to Expression

For each fields which contains the expression.

Here is a doc about it, just in case:

Expressions | n8n Docs

[Digital_Assets]

Much appreciated Ill make the change and see how it executes

[jabbson]

Sounds good, when you do, please come back and let us know.