title: How can I retrieve the hyperlink from a data cell in google apps script?
body: <p>I am using SpreadsheetApp.getActiveRange().getValues(); to get the value of a range of cells, but it doesn't return the hyperlink associated with that cell, only the text. Is there any way to get the hyperlink or do I have to add another field with the url in it?</p>
  
  <p>Thanks.</p>
  
  <p>UPDATE: This is how I ended up using it to build a link list.</p>
  
  <pre><code>&lt;ul&gt;
      &lt;?
      var range = SpreadsheetApp.getActiveRange();
      var data = range.getValues();
      var links = range.getFormulas();
  
      for(var i=1; i &lt; data.length; i++){
          if(data[i][0] !== ''){
              ?&gt;
              &lt;li&gt;&lt;a href="&lt;?= links[i][0].split("\"")[1]; ?&gt;"&gt;&lt;?= data[i][0]; ?&gt;&lt;/a&gt;&lt;/li&gt;
              &lt;?
          }
      }
      ?&gt;
  &lt;/ul&gt;
  </code></pre>