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

Questions
1

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.

2

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?

4

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

image
image457×264 16.1 KB

there are 5 places in JSON like that.

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

Digital_Assets 6
7

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

image
image750×220 11.6 KB

For each fields which contains the expression.

Here is a doc about it, just in case:

8

Much appreciated Ill make the change and see how it executes

9

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