Extract URLs from Google Sheets

Do you have to run the code first? Cause i am getting an “Error Exception: Argument cannot be null: a1Notation” when I run the code. The formula also is not working

Tqs a lot bro. It's Working

Thank you so much! This is a lifesaver! I would just suggest you add the formulas so they're ready to copy and paste.

I got range not found error.

Thank you for sharing the video! I had heard of this script a while ago but was never able to get it working because I don't know how to use scripts. Your video showed me clearly what to do and it's working!

If you want to call the function without double quotes, try this GETLINK(A2)


function GETLINK() {
var sheet = SpreadsheetApp.getActiveSheet();
var formula = SpreadsheetApp.getActiveRange().getFormula();
var cellAddress = formula.match(/\((.*?)\)/)[1]; // Extracts the cell address from the formula
var range = sheet.getRange(cellAddress);
var richTextValue = range.getRichTextValue();
var url = richTextValue.getLinkUrl();
return url;
}

The website unfortunately did not work for me. So if you for some reason absolutely can't type the code from screen, here it is:

function GETLINK(input){
var sheet = SpreadsheetApp.getActiveSheet();
var range = sheet.getRange(input);
var value = range.getRichTextValue();
var url = value.getLinkUrl();
return url;
}

And then to actually use it in the sheet:
=GETLINK(cell("Address",A63))

just replace the "A63" in my case with your relevant cell reference

Thanks, Brillant the example!

just save my evening with this!!, thank you and thank you for sharering Tyler Robertson's work

Script function not found: GETLINK

Awww yeah! Thanks!

Not working. Error. Syntax error. Done every step 100%

Amazing. THank yoU!

Thanks but I cant RUN the code in Apps script. Notice null line 3. Pls help

Thanks super helpful 👍

Your tutorial SUCKS, thanks for telling us how to set up this script

tysm

Wondering if this still works. I'm having issues where the cell that should be returning the url is blank

thank you . even chatGPT couldn't give me this code. u saved me so much time.

Amazing.

You rock! Straight to the point and great presentation.

Hi! I need to create a formula or script. Which will return me a url to a cell in a given sheet. for example: =GET.URL(a1)
result: url

Perfect, thanks for the tip!

This is great! Thank you both for sharing!

Don't make any sheet. Make better sheet. Clever

man I spent the whole day trying to find this solution via chatGPT, only to have it repeatedly apologizing and giving me an even more wrong result. YOU ARE A LIFE SAVER!!

thanks for sharing, but this doesn't work when the URL doesn't contain "www"

Thank you so much! This is exactly what I was looking for.

It's not working

Awesome saved me lot of time

I spent the whole day trying to batch extract individual image links from Dropbox files for over 1000 images by using all these fancy automation tools, looked through dozens of videos and YOU are the only one who brought me straight to the solution! THANK YOU! <3

I save a lot of time with this. Thanks!

Thank you for sharing this...much help!!

This is awesome!! I just tried it out and it worked. Thanks

I always get TypeError: Cannot read properties of null (reading 'getLinkUrl') (line 5). Why is that?

Am using the formula =GETLINK(CELL("Address";R2))

Brilliant sir, thank you so much.

Is possible create a GETDATE from a url? Which variables can I use?

Thank you very much!!

Thank you!! Saved me lots of time.

thanks

BRILLIANT!! Thanks for taking the time to share this!

thank you so much for such a quick and effective solution!

Thank you so much! ❤