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
-
1:04:29
BonginoReport
12 hours agoFDA Vax Pusher Needs to Look in the Mirror - Nightly Scroll w/ Hayley (Ep.16) - 03/31/2025
138K110 -
3:27:31
SquallRush
1 day agoBrawlhalla Mondays!
39.8K1 -
9:14:37
Misfit Electronic Gaming
11 hours ago $5.42 earned"LIVE" It's So Monday So lets Perk it up. Lets Earn Gears"Party Animals" & R.E.P.O. Who will join me????
59.2K -
54:13
Sarah Westall
11 hours agoCIA Disclosures: Ark of the Convenient, the Pyramid Code, Ley Lines & Earth’s Energy w/ Jason Shurka
102K25 -
1:16:28
Kim Iversen
12 hours agoThere Was No COVID Virus! How We've All Been Duped By The Medical Establishment
165K339 -
2:58:42
Crossplay Gaming!
8 hours agoLet's Check Out MORE Metroid Prime Remastered! (With the RTX 5090!)
50.1K3 -
14:24
AlaskanBallistics
17 hours ago $1.72 earnedMDT HNT26 Chassis on A Remington 700 7mm Remington Magnum
40.9K9 -
13:34
T-SPLY
12 hours agoCNN Is Now Accusing Trump Staff Of War Crimes
61K27 -
1:33:25
2 MIKES LIVE
12 hours ago2 MIKES LIVE #199 Deep Dive Monday!
47.2K5 -
54:40
LFA TV
16 hours agoThe World Realigns Against America | TRUMPET DAILY 3.31.25 7PM
42.2K18