Dynamic URL from Google Sheets not working in HTTP Request node

[Jan_Grouzer]

I’m trying to use a URL from a Google Sheets row in an HTTP Request node. The Google Sheets node successfully retrieves the URL (strona column), but when I use {{ $json.strona }} in the HTTP Request node, I get an “Invalid URL” error.

However, if I manually replace {{ $json.strona }} with the actual URL, the request works perfectly.

I have checked:
The value in strona contains a valid URL (starts with http:// or https://).
There are no extra spaces in the Google Sheets data.
Using {{ $json["strona"] }} or {{ $node["Google Sheets"].json["strona"] }} also doesn’t work.
Using String($json.strona).trim() or encodeURI($json.strona) doesn’t help.
Hardcoding the URL in the HTTP Request node works fine.

Does anyone know why n8n is failing to resolve the variable correctly?

n8n Version: 1.85.4 (Self-hosted)
Node Type: HTTP Request`

[Olek]

This

means that there is no data in the doc and sheet you refer to available to n8n

Try using doc and sheet IDs rather than picking from the list.

If this resolves your issue, please mark this post as a Solution.

If you still have issue not fixed, please reporst the workflow with some data in Google Sheets node pinned.