Google Sheet Node overwrites collumns that are not selected to send

Questions
1

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.

image
image2356×100 18.6 KB

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
3

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:
    image

  2. Sheets node:

    image
    image1920×895 70.1 KB

  3. After:
    image

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

4

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