12

Is there a way to make phone numbers clickable in Google Docs similar to MS Word like here?

Please note that this can be done in Google Sheets using:

=HYPERLINK("tel:1234567890", "Call Me")

I am asking for Docs.

Thank you.

Ahmet
  • 908
  • 1
  • 17
  • 26
  • 1
    does not seem to work on Google Sheets – Frederic Bazin Jun 06 '21 at 08:45
  • 1
    @FredericBazin is right, it is not working in Google Sheets. Help explains why: «Only certain link types are allowed. http://, https://, mailto:, aim:, ftp://, gopher://, telnet://, and news:// are permitted; others are explicitly forbidden. If another protocol is specified, link_label will be displayed in the cell, but will not be hyperlinked.» – Serhii Kheilyk Feb 08 '22 at 08:20
  • Yes, you are right, `=HYPERLINK("tel:1234567890", "Call Me")` doesn't work anymore. – Ahmet Nov 07 '22 at 15:29

2 Answers2

11

Google Docs now supports call/telephone links by adding a hyperlink with tel followed by the phone number.

Example

  • U.S. - tel:1234567890
  • Int'l - tel:+11234567890

When clicking the link the browser displays a call prompt.

AdamHurwitz
  • 9,758
  • 10
  • 72
  • 134
  • Google Docs was already supporting this at the time of my question. I'm asking for Sheets. – Ahmet Mar 23 '23 at 14:32
8

Unfortunately, there's no direct way of doing this, but you can use Apps Script and deploy a web application that will solve your issue.

You will have to use this script using Apps Script script editor:

function doGet(e) {
  return HtmlService.createHtmlOutput("<script>window.location.href='tel:" + e.parameter.tel + "';</script>");
}

The code contains a doGet(e) function which sends an HTTP GET request and returns a new HtmlOutput object, which has as a parameter the phone number of your choice.

Afterwards, you have to deploy this script as a web application and after that, you will get a URL corresponding to it.

If you want to use it in Google Docs, you can create a link made out of the following link:

your-web-application-URL+?tel=the-phone-number-you-want .

Furthermore, here are some links for you that might be of help:

  1. Apps Script;

  2. Google Web Apps;

  3. HtmlService Class;

  4. Create a link in Google Docs.

ale13
  • 5,679
  • 3
  • 10
  • 25
  • while the following works on desktop, it does not work on mobile (neither iOS nor Android) :( do you have any idea why, just in case? – grreeenn Mar 10 '21 at 12:47