How to update google sheet node automatically?

[darrell_tw]

Hi everyone!

I recently discovered that my Google Sheets node version is outdated. I want to update it, but there’s an issue: this workflow uses 10+ Google Sheets nodes.

It looks like I need to re-create each node and manually copy the configuration one by one.

Is there a faster way to do this?

I could write code to compare the two node versions in JSON and update the configuration programmatically, but I’m wondering if there’s a more elegant solution available?

[mohamed3nan]

Hi @darrell_tw

I’d just copy the workflow JSON, paste it somewhere (any text editor), then do a find and replace all:

find:

 "type": "n8n-nodes-base.googleSheets",
      "typeVersion": 4.5,

replace with:

 "type": "n8n-nodes-base.googleSheets",
      "typeVersion": 4.7,

To automate it, use the n8n API to get the JSON and do the find-and-replace part..

[darrell_tw]

Yeah thanks!

Just wonder if there is a possibility need to change some field or input value when update a node version.

[mohamed3nan]

@darrell_tw

Just wonder if there is a possibility need to change some field or input value when update a node version.

Same here.,
I still don’t know when updating a node that includes new settings or fields, maybe nothing happens and it just bumps the version, and you have to edit any new fields manually, haven’t tested this case..