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:07:19
Candace Show Podcast
2 hours agoFarewell Show: LIVE With Ian Carroll | Candace Ep 183
28.5K40 -
33:37
Kimberly Guilfoyle
5 hours agoThe First 100 Days: Interview with Bienvenido President Abraham Enriquez | Ep217
31.5K6 -
42:58
Stephen Gardner
1 hour ago🔥BOOM! Trump's NEW EO just changed EVERYTHING!!
9.15K11 -
LIVE
Dr Disrespect
6 hours ago🔴LIVE - DR DISRESPECT - TRIPLE THREAT CHALLENGE - WZ, PUBG, FORTNITE
3,636 watching -
2:12:54
The Quartering
5 hours agoAdam Schiff IN TROUBLE, Woke Lefties MELTDOWN Over Temu, Karmelo Anthony Family LIES, & Much More
119K38 -
1:12:00
RiftTV/Slightly Offensive
3 hours ago $4.99 earnedWho KILLED Virginia Giuffre? Only 11% of Black Chicago Students Can READ? | The Rift Report
35.2K23 -
1:15:01
The HotSeat
2 hours agoDeporting Illegals, Arresting Judges, and Saving Women's Sports — More, Please!
21.3K5 -
25:18
Scary Mysteries
4 hours agoSTRANGE & SCARY Mysteries Of The Month - April 2025
20.9K5 -
1:35:24
Russell Brand
5 hours agoEpstein’s Most Famous Accuser Found DEAD—Was She Silenced? – SF573
160K36 -
1:49:00
Tucker Carlson
5 hours agoCatherine Fitts: Bankers vs. the West, Secret Underground Bases, and the Oncoming Extinction Event
123K123