Google sheet: Create formula from n8n that is sent to a sheet

Hi @Barberg, you can add formula’s to a Google Sheet node when using the “Let Google Sheets format” option in the “Cell Format” field:

grafik

For example like so:

Resulting in the formula being added as expected:

grafik

I was using 0.221.2 when testing this since I didn’t have an 0.208 instance connected to Google Sheets set up. I think this will still work on 0.208.0 though, but please do give me a shout if not.

1 Like