When you are editing your signature type the words you want as the link.
Select the words and then click on the icon of the globe and the sideways 8. It will open a window where you can paste your URL for your sheet. Makre sure you use the "published" address and not the "shared" address
Select the words and then click on the icon of the globe and the sideways 8. It will open a window where you can paste your URL for your sheet. Makre sure you use the "published" address and not the "shared" address