Hi Jasmin,
Welcome to the Wix Code forums.
What component are you using for the URL? $w.HtmlComponent or $w.Text ?
The HtmlComponent is used for embedded HTML code. You can read the article Working with the HTML Component in Wix Code for more information.
The Text component can be set to a URL as follows:
$w("#text1").html = '<a href="http://wix.com" target="_blank">Stunning web sites</a>';
It seems that what you are trying to do is create a link to a Google sheet, which could easily be done with the Text component. If you are trying to “embed” the Google sheet in the page, then you’ll need to use an HtmlComponent, and pass the URL to the HTML code in the component as described in the article I referenced above.
Good luck,
Yisrael