Premium Only Content
Extract Hyperlinks from Text in Google Sheets using Google Apps Script | Aryan Irani
Recently, I was making a collection of all Medium articles and basically copied the links of the articles and stored them in a Google Sheet. I wanted to extract the links from the cell text and paste them into the adjacent column.
In this video we will be looking at extracting HyperLinks from Cell Text in Google Sheets using the RichTextValue Class and Google Apps Script.
Work with the sheet: https://docs.google.com/spreadsheets/d/1ozHlNwlqauIQoaSpaxlZgYwtpIxYlxk0p_eyM6T-LY4/copy
Work with the Code: https://github.com/aryanirani123/Google-Apps-Script/blob/master/ExtractURL.js
RichTextValue Class: https://developers.google.com/apps-script/reference/spreadsheet/rich-text-value
Socials :
Twitter : https://x.com/aryanirani123
LinkedIn : https://www.linkedin.com/in/aryanirani123/
Medium : https://medium.com/@aryanirani123
Website : https://www.aryanirani123.com/
Hi. I am Aryan Irani. I am a Google Developer Expert, Champion Innovator for Google Workspace, a Technical Writer, Developer.
#googlesheets #googleappscript #googleworkspace
-
8:03:17
Akademiks
1 day agoYoung Thug Declares war on Gunna? Donald Trump next President! 6ix9ine gets 60 Days in Jail.
142K1 -
58:36
LFA TV
1 day agoIt Was a Red Wave | Trumpet Daily 11.8.24 9PM EST
57.4K3 -
10:24
Guns & Gadgets 2nd Amendment News
11 hours agoBREAKING NEWS: Illinois Assault Weapons Ban STRUCK DOWN!!!
40.9K11 -
1:24:47
vivafrei
10 hours agoArizona Chicanery! Iran Plot! Canada McCarthyism AND MORE!
104K125 -
1:16:02
Candace Show Podcast
11 hours agoFormer CIA Officer Exposes The Shadow Government | Candace Ep 100
154K345 -
34:37
Stephen Gardner
10 hours ago🔥Trump sends SHOCKWAVES with TERRIFYING New Threat + Biden BACKSTABBED Kamala with POWER PLAY!!
80.5K104 -
1:52:32
2 MIKES LIVE
10 hours ago2 MIKES LIVE #140 Open Mike Friday
53.9K4 -
24:39
RealitySurvival
11 hours agoDon't Ignore The Warning Signs Of The Chaos Still To Come!
35.1K8 -
59:29
Exploring With Nug
14 hours ago $6.82 earnedHe Left Them All To Die While He Snuck Out To Save Himself!
48.3K2 -
42:41
PMG
11 hours ago $2.46 earnedHannah Faulkner and Alex Newman | Beneath Sheep's Clothing
36.1K