Google Sheet Node overwrites collumns that are not selected to send

Describe the problem/error/question

The Google Sheets Node overwrites cells with empty values even if they are not selected to send
This only happens with append. Updating works as expected.

Information on your n8n setup

  • n8n version: 1.8.2
  • Database (default: SQLite): postgres
  • n8n EXECUTIONS_PROCESS setting (default: own, main): default
  • Running n8n via (Docker, npm, n8n cloud, desktop app): cloudron
  • Operating system: ubuntu 22

Hi @simong, welcome to the community!

I am very sorry you’re having trouble. I had a look at your example node but was unable to reproduce the problem using one of my own sheets. Only the field I am sending is actually overwritten:

  1. Before:

  2. Sheets node:

  3. After:

Can you perhaps share a Google Sheet with me using which this problem can be reproduced?

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.