Google Sheets only write certain columns

[BWS]

Is there a way to get the Sheets Append or Update to leave any columns not specifically requested alone.

As a backstory I want to paste data into a sheet using an e-mail address as a mapping so it doesn’t duplicate. But I want my arrayformula in Col E to not be messed with. Right now when a new row is appended by the node it is writing blank data into Col E.

Information on your n8n setup

• **n8n version:1.83.2
• Database (default: SQLite):
• n8n EXECUTIONS_PROCESS setting (default: own, main):
• **Running n8n via (Docker, npm, n8n cloud, desktop app)Docker
• Operating system:

[Olek]

Removing columns that I didn’t want to be altered always worked for me.

But I must admit I never mingled with array functions on the sheets I use to collect inputs. Just to separate concerns as a general rule.

It would be very helpful if you could post your workflow and maybe provide a sample shared spreadsheet to play with.

[BWS]

I will research it some more, I think it may just not be able to, I am going to just restructure my workflow to use the sheet I was pulling from independently anyway.