title: Retrieve value of links from Google Sheet?
body: <p>I have some values in a Google Sheet, some of which are hyperlinked, like the third one here:</p>
  
  <p><a href="https://i.stack.imgur.com/2ArrK.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/2ArrK.png" alt="enter image description here"></a></p>
  
  <p>I want to retrieve the text value of each cell, and the hyperlink if present. </p>
  
  <p>I am able to access the sheet easily enough with <a href="http://gspread.readthedocs.io" rel="nofollow noreferrer">gspread</a>:</p>
  
  <pre><code>import gspread
  from oauth2client.service_account import ServiceAccountCredentials
  
  scope = ['https://spreadsheets.google.com/feeds']
  credentials = ServiceAccountCredentials.from_json_keyfile_name(
      './credentials.json', scope)
  gc = gspread.authorize(credentials)
  key = 'xxxxx'
  wks = gc.open_by_key(key).worksheets()
  for wk in wks:
      links = wk.col_values(3)
      for l in links:
         print l.value
  </code></pre>
  
  <p>However, this only prints the string value of the links, not the actual href that the link is pointing to. </p>
  
  <p>Does anyone know if it's possible to retrieve this programmatically, using gspread or another library?</p>