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
-
LIVE
G2G Gaming Channel
2 hours agoMonday Smite Fix! #RumbleTakeOver #RumbleGaming
362 watching -
LIVE
Jeff Ahern
1 hour agoMonday Madness with Jeff Ahern (6am Pacific)
571 watching -
LIVE
PudgeTV
13 hours ago🔵Vigilante Nights - Batman: Arkham Origins | Live Playthrough Pt. 5
123 watching -
15:21
Degenerate Jay
16 hours ago $7.55 earnedThe Mystery Of Silent Hill 2's Strange Photos Has Finally Been Solved
36.4K9 -
9:47
Cooking with Gruel
20 hours agoMastering Potato Gratin
20.7K27 -
8:34
GBGunsRumble
14 hours agoGBGuns Range Report 24NOV24
15.4K4 -
2:04:09
Nerdrotic
14 hours ago $87.98 earnedNew Peruvian Megalithic Site Discovery w/ Michael Collins | Forbidden Frontier #083
184K22 -
6:40:53
Fresh and Fit
15 hours agoMyron TRIGGERED Rubi Rose, And Debating Cry Baby Blax On X Spaces!
180K129 -
4:54:16
TheSaf3Hav3n
14 hours ago $29.81 earnedCALL OF DUTY: BLACK OPS 6 | A QUIET PLACE: THE ROAD AHEAD | #RumbleTakeOver
94.1K6 -
4:05:35
TheNateVibez
13 hours agoOmni-🤖 - First Rumble Stream.🫡 - VETERAN
80K4