Google Sheet - ERROR: Sheet parameter's value is invalid

[Romain_Mangattale]

<

Hello, I have created a workflow that allow me to import some google sheet into our product catalog. It was perfectly functionning until the June 25th.

I did not do any modification on the workflow.

I use the sheet URL to identify which google sheet I want to get. However, each time I try to get the sheet, i have the following message : “ERROR: ERROR: Sheet parameter’s value is invalid. This is likely because the URL entered is incorrect”

Strange part is, when I click on the open the sheet button on the right side of the field, I get to the desired sheet without any problem

I have tried :

• Trying a new sheet => Not working
• Removing the #gid=0 that appeared recently on google sheets urls => Not working
• Using the id => Worked so I can circumvent this issue for the moment

Please share your workflow

I sadly cannot share the workflow as I have a lot of sensible information in it. However, here is the problematic node :

Share the output returned by the last node

“ERROR: ERROR: Sheet parameter’s value is invalid. This is likely because the URL entered is incorrect”

Information on your n8n setup

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

Thanks a lot and have a good day !

[mariana-na]

Hi @Romain_Mangattale ,

Welcome to the community!

I was unable to recreate the exact error, but from the looks of it you seem to be using the same url to reach the document and the sheet. Is there only one sheet in that document?
And would it be possible to try finding the sheet by ID instead of url and if so, does an error persist?

[Romain_Mangattale]

Hello Mariana,

Yes, that is indeed the case and using the same URL with the gid for the document and the sheet was perfectly working until Tuesday.

Yes, i can circumvent with the gid but that still means that reaching the sheet with the URL is not working.

[Romain_Mangattale]

Hello,

I am still struggling to identify the correct sheet with its url, anyone can help ?

[Romain_Mangattale]

Hello,

Alright, I really need support and i can’t find my answer in your documentation.

So here again is my problem. I am trying to fetch a particular sheet on a google sheet.

I have the URL as my main key. However, each time I try to input the Sheet URL, N8N tells me that it is not a valid Sheet URL.

Here is an example of a google sheet (this a random sheet) : Example URL - Google Sheets

Here is the error node

Thanks a lot for your answer.

[mariana-na]

Hi @Romain_Mangattale ,

Apologies for the delay in getting back to you!

The error you’re seeing can be overcome by editing the url slightly, as in this example:

If you remove the search query n8n is once again able to find the requested sheet.

Another workaround is to first select the sheet From List and after changing the selection to By URL. The node will automatically pick up on the sheet’s url and do the editing for you.

I will take this feedback internally so we can work on a fix as this is not an ideal behaviour.

Thank you for your patience with this issue! I failed to track the process of this post in particular, which is absolutely on me, but might I suggest that you tag me in your future replies? you can do @ followed by my username to ensure I get notified of the replies

Let me know how you get on with this workaround!

[Romain_Mangattale]

Hello @mariana-na

Yes, it seems to fix the issue. I am using those URL in a chrome extension to exploit those URL sheets so I will try to find a workaround to remove this bit from the google sheet url.

This would be interesting to fix, i guess google change their url format not long ago.

Thanks a lot for your support