---
title: "Everything a Google Apps Script Developer wanted to know about reading hyperlinks in Google Sheets … but was afraid to ask"
author: "Sourabh Choraria"
date: 2020-04-15T15:55:23+00:00
canonical_url: https://pulse.appsscript.info/p/2020/04/everything-a-google-apps-script-developer-wanted-to-know-about-reading-hyperlinks-in-google-sheets-but-was-afraid-to-ask/
markdown_url: https://pulse.appsscript.info/p/2020/04/everything-a-google-apps-script-developer-wanted-to-know-about-reading-hyperlinks-in-google-sheets-but-was-afraid-to-ask.md
categories:
  - "Sheets"
  - "Solutions"
tags:
  - "@mhawksey"
  - "hawksey.info"
featured_image: https://pulse.appsscript.info/files/2020/04/hyperlink.gif
description: "The problem: hyperlinks in Google Sheets can be in three different formats so if you have a script or add-on that relies on handling links in cells it can cause some headaches. This article covers..."
---

# Everything a Google Apps Script Developer wanted to know about reading hyperlinks in Google Sheets … but was afraid to ask

![Everything a Google Apps Script Developer wanted to know about reading hyperlinks in Google Sheets … but was afraid to ask](https://pulse.appsscript.info/files/2020/04/hyperlink.gif)

[![](https://pulse.appsscript.info/files/2020/04/hyperlink.gif)](https://mashe.hawksey.info/2020/04/everything-a-google-apps-script-developer-wanted-to-know-about-reading-hyperlinks-in-google-sheets-but-was-afraid-to-ask/)

> The problem: hyperlinks in Google Sheets can be in three different formats so if you have a script or add-on that relies on handling links in cells it can cause some headaches.

This article covers a thorough walkthrough of using Advanced Sheets Service to read hyperlinks from cells with different link formats.

Source: *[Everything a Google Apps Script Developer wanted to know about reading hyperlinks in Google Sheets … but was afraid to ask*](https://mashe.hawksey.info/2020/04/everything-a-google-apps-script-developer-wanted-to-know-about-reading-hyperlinks-in-google-sheets-but-was-afraid-to-ask/)

---

*Published by [Sourabh Choraria](https://pulse.appsscript.info/p/author/scriptgs/) on [Pulse](https://pulse.appsscript.info/). Original article: [https://pulse.appsscript.info/p/2020/04/everything-a-google-apps-script-developer-wanted-to-know-about-reading-hyperlinks-in-google-sheets-but-was-afraid-to-ask/](https://pulse.appsscript.info/p/2020/04/everything-a-google-apps-script-developer-wanted-to-know-about-reading-hyperlinks-in-google-sheets-but-was-afraid-to-ask/)*