Extract Hyperlinks from Text in Google Sheets using Google Apps Script | Aryan Irani

2 months ago
1

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

Loading comments...