---
title: "Interacting with multiple hyperlinks in Google Sheets cells with Google Apps Script"
author: "Martin Hawksey"
date: 2020-05-15T08:05:32+00:00
canonical_url: https://pulse.appsscript.info/p/2020/05/interacting-with-multiple-hyperlinks-in-google-sheets-cells-with-google-apps-script/
markdown_url: https://pulse.appsscript.info/p/2020/05/interacting-with-multiple-hyperlinks-in-google-sheets-cells-with-google-apps-script.md
categories:
  - "Sheets"
  - "Snippet"
  - "Solutions"
tags:
  - "GitHub"
  - "tanaikech"
description: "Before this, when a cell has only one hyperlink. In this case, the hyperlink was given to a cell using =HYPERLINK(\"http://www.google.com/\", \"Google\") but by a recent update, a cell got to be able to have..."
---

# Interacting with multiple hyperlinks in Google Sheets cells with Google Apps Script

> [https://gist.github.com/tanaikech/d39b4b5ccc5a1d50f5b8b75febd807a6](https://gist.github.com/tanaikech/d39b4b5ccc5a1d50f5b8b75febd807a6)
> Before this, when a cell has only one hyperlink. In this case, the hyperlink was given to a cell using =HYPERLINK(“http://www.google.com/”, “Google”) but by a recent update, a cell got to be able to have multiple hyperlinks … In this report, I would like to introduce the method for setting and retrieving the multiple URLs for a cell.

Hyperlinks in Google Sheets cells is a bit of an obsession of mine and it’s nice to see Kanshi TANAIKE has a similar passion. Google are rolling out multiple hyperlinks in Google Sheet cells and Tanaike has provided details on how the hyperlink values can been get/set with Google Apps Script (the official docs are still catching up with Tanaike’s discovery :)

Source: *[Updated Specification of Google Spreadsheet: Multiple Hyperlinks to a Cell*](https://gist.github.com/tanaikech/d39b4b5ccc5a1d50f5b8b75febd807a6)

---

*Published by [Martin Hawksey](https://pulse.appsscript.info/p/author/admin/) on [Pulse](https://pulse.appsscript.info/). Original article: [https://pulse.appsscript.info/p/2020/05/interacting-with-multiple-hyperlinks-in-google-sheets-cells-with-google-apps-script/](https://pulse.appsscript.info/p/2020/05/interacting-with-multiple-hyperlinks-in-google-sheets-cells-with-google-apps-script/)*