Google sheet update/append erases formula on certain columns where data isn't mapped

Questions
, , , ,
#1

Hi! We’re using the google sheet module to update/append products from shopify into our google sheet. We have some columns on the google sheet with some formulas that we don’t want the N8N update to touch.
The

Describe the issue/error/question

The problem is that when N8N updates a row, it deletes the content on all the rows even on columns that shouldn’t be updated, which therefore deletes our formula.

I thought that with the setup of “Handling extra fields in input > ignore data” it would be fixed but it’s not working. The update removes all info on the whole row … how to get a way around this please?

Please share the workflow

Share the output returned by the last node

Information on your n8n setup

  • n8n version: Running version [email protected]
  • Database you’re using (default: SQLite):
  • Running n8n with the execution process [own(default), main]:
  • Running n8n via [Docker, npm, n8n.cloud, desktop app]: N8N CLOUD
#2

Hi @oly-dev, I am sorry you’re having trouble. Unfortunately it’s not clear to me what exactly you are doing here as your example workflow relies heavily on external data.

Perhaps you can simplify it a bit, down to two nodes (one of which mocks your data structure, the other performing the unwanted update) and also share a spreadsheet using which the problem can be seen?