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