How to add a formula to a Google Sheets cell?

[Pilar]

Hello!

I try to add a formula to a Google Sheets cell.
I add =row() to the field value and if I run the node immediately, the formula is successfully added.
But if I save the workflow first, the “=” disappears.

The same is when I use a “Set” node.

• n8n version: 0.217.2
  
  

[pigri]

Hello!

If you can try this? {{ JSON.stringify(=row()) }}

[Pilar]

@pigri

{{ JSON.stringify(=row()) }}

I get “[invalid syntax]” when I add {{ JSON.stringify(=row()) }}

[Pilar]

but I can use it so:
{{ JSON.stringify(‘=row()’).replace(/^.|.$/g,“”)}}

It’s not the prettiest solution, but it works☺️

[pigri]

Great! In my solution, I made a mistake.

[Pilar]

Thank you so much!

but there is a question how to add a formula like :
=indirect(“R[0]C[-2]”;false)&“”&indirect(“R[0]C[-1]”;false)

I get in my cell