Skip to main content
Question

Extracting simple text link from Google Sheets


I’m totally new to Zapier so, please, bear with me :)

There is a cell in a Google Sheets that is a clickable link.  It is not a HYPERLINK formula but rather a simple clickable text.  Client made it this way, it’s out of my control.

The result of my “Lookup Spreadsheet Row” gives me the text of the link but what I need is the URL linked to that text.  I tried different Formatter but none works.  I feel it’s something that should be done inside “Lookup Spreadsheet Row” to say “Hey, that cell is a clickable link.  I want the link, not the text!”.  Is it at all possible?

Did this topic help you find an answer to your question?

4 replies

Troy Tessalone
Forum|alt.badge.img+14

Hi ​@Lyverbe 

For us to have more info, post screenshot about what you are referring to in the GSheet.


  • Author
  • New
  • 2 replies
  • February 11, 2025

Hi Troy,

I’m referring to this button on the toolbar.

When looking at the edit box, we see that the text is indeed “Example”…

...but that I want is “www.google.com”, not “Example”


JammerS
Forum|alt.badge.img+6
  • Zapier Staff
  • 2188 replies
  • February 12, 2025

Hi ​@Lyverbe,

 

The icon you point out on your screenshot is an Insert Link. This feature allows you to create a clickable hyperlink within a cell, making it easier to access external websites or other locations within the sheet. When you insert a link, the cell displays the text you choose, but when clicked, it directs you to the specified URL.

 

You can type in www.google.com on the Google Sheet cell.


  • Author
  • New
  • 2 replies
  • February 12, 2025
  1. I know exactly what this button is for.  That’s not the question.
  2. As I said in the original post, “Client made it this way, it’s out of my control.” so I can’t change to www.google.com

I think you only read my last post and replied to it.  Reading the entire thread (especially the original post) would have been a good idea.