# Making hooks clickable in Google Sheets

**URL:** https://discourse.hookproductivity.com/t/making-hooks-clickable-in-google-sheets/6264
**Category:** Discussion & Help
**Created:** [January 26, 2023, 4:01pm UTC](https://discourse.hookproductivity.com/t/making-hooks-clickable-in-google-sheets/6264 "2023-01-26T16:01:56Z")
**Posts on this page:** 8
**Page:** 1

<div class="post-metadata">

### Author: ![Seth](https://discourse.hookproductivity.com/user_avatar/discourse.hookproductivity.com/seth/32/2666_2.png) [@Seth](https://discourse.hookproductivity.com/u/Seth)
#### Post date: [January 26, 2023, 4:01pm UTC](https://discourse.hookproductivity.com/t/making-hooks-clickable-in-google-sheets/6264/1 "2023-01-26T16:01:56Z")

</div>

When I paste a Link or a Markdown Link into Google Sheets, it isn’t clickable. Can someone help me either:

1. make it a live, clickable link, or
2. describe what kind of link I could paste that would make this work?

Trying to invoke “=HYPERLINK()” doesn’t work either. I know there must be an easy solution to this, I just can’t find it.

Thank you!

---

<div class="post-metadata">

### Author: ![stevelw](https://discourse.hookproductivity.com/letter_avatar_proxy/v4/letter/s/ea666f/32.png) [@stevelw](https://discourse.hookproductivity.com/u/stevelw)
#### Post date: [January 26, 2023, 6:58pm UTC](https://discourse.hookproductivity.com/t/making-hooks-clickable-in-google-sheets/6264/2 "2023-01-26T18:58:19Z")

</div>

If I’m understanding, this problem is solved with the new Universal Link feature (Google blocks non-web links for security reasons)

---

<div class="post-metadata">

### Author: ![LucB](https://discourse.hookproductivity.com/user_avatar/discourse.hookproductivity.com/lucb/32/2228_2.png) [@LucB](https://discourse.hookproductivity.com/u/LucB)
#### Post date: [January 26, 2023, 7:02pm UTC](https://discourse.hookproductivity.com/t/making-hooks-clickable-in-google-sheets/6264/3 "2023-01-26T19:02:40Z")

</div>

Thanks, @stevelw.

Welcome to the Hookmark Forum , @Seth. `Copy As Universal Link` and `Copy as Universal Markdown Link` are available if you click on **Action ☰** button menu in title bar and hold down option key. The links only work in Safari. Apple introduced universal links, but other browsers have not yet adopted it.

The feature is described in [Hookmark 5 Release Notes and Download Link – Hookmark](https://hookproductivity.com/release-notes/hookmark-5-0/) . [Making hooks clickable in Google Sheets - Discussion & Help - Hookmark Forum](https://discourse.hookproductivity.com/t/making-hooks-clickable-in-google-sheets/6264). We’ll publish a separate help page on this soon.

---

<div class="post-metadata">

### Author: ![Seth](https://discourse.hookproductivity.com/user_avatar/discourse.hookproductivity.com/seth/32/2666_2.png) [@Seth](https://discourse.hookproductivity.com/u/Seth)
#### Post date: [January 27, 2023, 5:19pm UTC](https://discourse.hookproductivity.com/t/making-hooks-clickable-in-google-sheets/6264/4 "2023-01-27T17:19:16Z")

</div>

Thank you all so much for your responses. I do have Pro, but I must have missed the release notes.

One more thing! When I am in apple mail, option-command-c does not work. I would like to use the shortcut, but when I select it and try the shortcut, it gives me the little ‘blip’ error sound. I’ve looked all over for any conflicting shortcuts, and I can’t find them.

Thanks!

---

<div class="post-metadata">

### Author: ![LucB](https://discourse.hookproductivity.com/user_avatar/discourse.hookproductivity.com/lucb/32/2228_2.png) [@LucB](https://discourse.hookproductivity.com/u/LucB)
#### Post date: [January 29, 2023, 4:51pm UTC](https://discourse.hookproductivity.com/t/making-hooks-clickable-in-google-sheets/6264/5 "2023-01-29T16:51:07Z")

</div>

that’s strange. I tested again and it works for me. I wonder if some piece of software is intercepting the keyboard shortcut in Mail.app. Or perhaps you’ve configured that keyboard shortcut in Mail.app itself to do something else. That gets configured in System Preferences.

---

<div class="post-metadata">

### Author: ![fungacta](https://discourse.hookproductivity.com/letter_avatar_proxy/v4/letter/f/c77e96/32.png) [@fungacta](https://discourse.hookproductivity.com/u/fungacta)
#### Post date: [September 29, 2024, 9:05pm UTC](https://discourse.hookproductivity.com/t/making-hooks-clickable-in-google-sheets/6264/6 "2024-09-29T21:05:46Z")

</div>

MacOS, Chrome, Google Sheets.  
I use [Tinyurl.com](http://Tinyurl.com)  
First I use Alfred for Mac.  
Then I downloaded the [workflow](https://www.packal.org/workflow/shorten-url).

Whenever I want to use a link to a file or folder on my Mac,

1. I copy the hookmark link to the file or the folder
2. I then use the Alfred box to type in “tiny”, then hit Enter
3. then paste the hookmark link
4. the “tiny url link” is automatically copied into my clipboard
5. then I select the Google Sheets Cell, [Insert Link]
6. Command-V to paste the tiny url.  
Works for me every single time

The only extra step in invoking the Alfred box, typing tiny, ENTER, then Command-V to paste.

---

<div class="post-metadata">

### Author: ![darylc](https://discourse.hookproductivity.com/user_avatar/discourse.hookproductivity.com/darylc/32/4132_2.png) [@darylc](https://discourse.hookproductivity.com/u/darylc)
#### Post date: [August 21, 2026, 5:55am UTC](https://discourse.hookproductivity.com/t/making-hooks-clickable-in-google-sheets/6264/7 "2026-08-21T05:55:56Z")

</div>

Hi @LucB , is this issue with using Hookmark in Google Sheets? I’ve check the links you provided but it doesn’t address the issue.  
Similar to @Seth , I’m trying to past a Hookmark in a cell in Google Sheet. i’ve tried add link, adding it via a formula, but Google Sheet seems to only recognise links with https

Any help on this is greatly appreciated.

With Thanks,

Daryl

---

<div class="post-metadata">

### Author: ![bchend](https://discourse.hookproductivity.com/letter_avatar_proxy/v4/letter/b/dbc845/32.png) [@bchend](https://discourse.hookproductivity.com/u/bchend)
#### Post date: [August 21, 2026, 4:24pm UTC](https://discourse.hookproductivity.com/t/making-hooks-clickable-in-google-sheets/6264/8 "2026-08-21T16:24:43Z")

</div>

Thank you for contacting us, @darylc

Have you tried Hookmark universal link? You can get the universal link via Action menu-\>Copy As Universal Link

And universal link only works in **Safari**.

 ![image](https://discourse.hookproductivity.com/uploads/default/original/2X/8/8b236ae56f750868f0ee966c0dcafb1bd764bd56.jpeg)

Thank you
