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 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?
- 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