Google Sheets row update problem

Questions
1

version 1.18

now i can update GS row, but i need to update only one column. if i leave rest columns empty it will delete those columns which is not nice. how can i fix it?

sheet
sheet1345Ă—545 25.9 KB

2

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
3

i fixed this by reading rows and then copying data for upadte but it should be fixed

1 Like
4

Hi @Edmunds_Priede, you can achieve this behaviour by using Map Automatically as the “Mapping Column Mode”:

image
image469Ă—664 35.4 KB

With this setting, n8n will only overwrite the columns it actually finds. For example with a sheet like this:

image

And a node like this:

image
image1920Ă—895 68.6 KB

Only the “Second column” in my example sheet would be overwritten, leading to this result:

image

1 Like
5

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