title: How to insert any as a hyperlink in google sheet cell with gspread
body: <p>I am trying to insert an email address into a google sheet cell as a hyperlink, so that only the word &quot;email&quot; will appear instead of the whole email address, here an example of what I want to do <a href="https://i.stack.imgur.com/7l7ty.png" rel="nofollow noreferrer">a cell that contain a hyperlink which is actually an email address</a></p>
  <p><strong>Here is the last code I tried</strong></p>
  <pre><code>import hyperlink
  from oauth2client.service_account import ServiceAccountCredentials
  from pprint import pprint
  
  scope = [&quot;https://spreadsheets.google.com/feeds&quot;, 'https://www.googleapis.com/auth/spreadsheets',
           &quot;https://www.googleapis.com/auth/drive.file&quot;, &quot;https://www.googleapis.com/auth/drive&quot;]
  
  creds = ServiceAccountCredentials.from_json_keyfile_name(&quot;creds.json&quot;, scope)
  
  client = gspread.authorize(creds)
  
  sheet = client.open(&quot;influenceurs_35k-55k(08.07.20)&quot;).sheet1
  
  data = sheet.get_all_records()
  
  col = sheet.col_values(2)
  
  insertRow = [&quot;hello&quot;, 5, &quot;red&quot;, &quot;blue&quot;]
  
  sheet.delete_rows(14)
  
  sheet.insert_row(insertRow, 14)
  
  sheet.update_cell(14,1, &quot;seyepapeseny@gmail.com&quot;.format(&quot;email&quot;))
  
  sheet.format(&quot;A14:b14&quot;)
  </code></pre>
  <p>&quot;seyepapeseny@gmail.com&quot; is the email I want to insert as hyperlink with gspread</p>