New google sheet url format causing problems

[Thiago_Borja]

Hello,

It seems that google sheet url’s have a new format. It used to be like this (with only one gid):

https://docs.google.com/spreadsheets/d/personalID/edit#gid=sheetID

but now everytime I open a google spreadsheet (even older ones) the new url format is this, with two gids:

https://docs.google.com/spreadsheets/d/personalID/edit?gid=sheetID#gid=sheetID

The thing is, if I use the newer format in the google sheets node it throws this error:

I’m currently using n8n Version 1.21.1.

Is there a way to permanently fix this? I don’t want to use regex to transform the url new format into the old format as it seems like a bad workaround.

[n8n]

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:

[Ludwig]

Hey @Thiago_Borja, thanks for reaching out and being a part of the community! I can’t find any reference by Google about a change to the normal behavior of gid’s in Sheets. I would also be incredibly surprised if they actually made that change because those sheets are meant to be the unique identifiers for the sheets within.

Instead, there might be an issue with the browser you’re using. It could be a problematic browser extension. Your best bet would be to reach out to Google’s support team (https://support.google.com/) and verify what you believe to be a new format to Google Sheets.

Best of luck and happy building!

[Thiago_Borja]

Hi Ludwig. Well I check that out and I’ll let you know. Thank you

[Thiago_Borja]

So, I still have no ideia as to why this is happening. But I don’t want to lose any more time with this, so I simply created a code node that will remove the extra gid (only allow the #gid one) and the workflow works normally.