V2.16 Google Sheet - Invalid URL

Questions
1

Describe the problem/error/question

Just migrated to v2.16 from v2.15.
Google Sheet Get Rows generate an error message. It was working fine in 2.15

What is the error message (if any)?

Invalid URL

TypeError: Invalid URL at new URL (node:internal/url:819:25) at appendResumeToken

Please share your workflow

(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)


## Share the output returned by the last node

<!-- If you need help with data transformations, please also share your expected output. -->

## Information on your n8n setup

* **n8n version:** 2.16
* **Database (default: SQLite):** PostgreSQL
* **n8n EXECUTIONS_PROCESS setting (default: own, main):**
* **Running n8n via (Docker, npm, n8n cloud, desktop app):** Docker / Hostinger
* **Operating system:** Ubuntu
3

I have tried List, URL, ID, Name,… it fails during execution
Looks like a regression

4

Hi @hsteph
If it fails regardless of whether the document is selected by List, URL, ID, or Name, then as a workaround I recommend downgrade to v2.15 for now, since this strongly looks like a v2.16 regression rather than a document selection issue.

5

Oops, I’m back to 2.15.0 And I now get the same Invalid URL issue, …
How is this possible ?

6

lol

@hsteph
I sugest recreate the Google Sheets node from scratch, reselect the document and sheet manually, and reconnect or refresh the Google credential, since n8n supports selecting the sheet by List, URL, or ID and stale node/credential state is the more likely issue at this point.

7

I’m back to 2.11.4 via a full Snapshot restore (thanks Hostinger), …
Will postpone my upgrade;)

8

FYI
I have tried to upgrade to 2.16.1 from 2.11.4 and I get the same error (Invalid URL), even if I recreate the node from scratch

9

Had the same issue today. Is this already being tracked on GitHub? Couldn’t find the issue.

11

Just tried v2.17.6, … same issue !

12
13

I have forced the use of “https” in my Coolify/Docker env variables and added N8N_TRUST_PROXY=true.

  • ‘N8N_EDITOR_BASE_URL=https://${SERVICE_FQDN_N8N}’
  • ‘WEBHOOK_URL=https://${SERVICE_FQDN_N8N}’
  • ‘N8N_HOST=${SERVICE_URL_N8N}’
  • N8N_TRUST_PROXY=true

I have then migrated to 2.17.8 with success. No “Invalid URL” anymore when using the Google Sheet node. Thanks to the support