Clickable Zoom Phone link in Sheets

[dalkesm]

Any ideas for creating a formula/code in a Sheet cell, that would be clickable to open browser window/connect to Zoom phone/allow dialing in Zoom app?  I've tried "callto", "tel", HYPERLINK, "https://ctrlq.org/call/" etc. 

What I've thought about is creating a clickable link that includes:

1. Opening a Chrome browser window

2. Which populates the phone number in the browser search box (press enter)

3.  Open the "Zoom Meeting - Always use this app"

And once "use this app" is selected, the phone number would pop into the Zoom app for dialing. 

I can get this to work doing it in separate stages, but don't know enough about formulas/coding to create a link in a cell of my Sheet that would combine all stages.

Any ideas?  Ty!

[ajojose33333344]

@dalkesm  Here is something I got from the internet but never tested it , give it a try if you think it makes sense:

1. Zoom URL scheme: You can use the Zoom URL scheme to create a clickable link that opens the Zoom app and connects to a specific meeting. The URL scheme is "zoommtg://zoom.us/join?confno=MEETING_ID&pwd=PASSWORD". Replace MEETING_ID and PASSWORD with the actual values, and then use the HYPERLINK function in Sheets to create the clickable link. Example: =HYPERLINK("zoommtg://zoom.us/join?confno=123456789&pwd=abc123", "Join Zoom Meeting")

2. Zoom Phone: If you want to create a clickable link that allows dialing in Zoom Phone, you can use the "tel" protocol with the phone number and the meeting ID. Example: =HYPERLINK("tel:+1-555-123-4567,,123456789#", "Join Zoom Phone Meeting"). Replace +1-555-123-4567 with the actual phone number, 123456789 with the meeting ID, and ## with the meeting password if required.

3. Zoom Web: If you want to create a clickable link that opens the Zoom web client in a browser window, you can use the regular URL format for joining a meeting. Example: =HYPERLINK("https://zoom.us/j/123456789?pwd=abc123", "Join Zoom Meeting"). Replace 123456789 with the meeting ID and abc123 with the meeting password if required.

[dalkesm]

I really appreciate these solutions to try out as I'd not seen these particular solutions online.  Unfortunately, Sheets does not like "hyperlink" formulas; so they do not work.  And maybe the reason they don't work is that all three examples are for joining a Zoom meeting; whereas what I am searching for is a link to phone someone in the Zoom App.

For clarity, what I need is a clickable link that uses a person's phone number (for example, our organization uses Zoom as our "land lines" and we each have a telephone number in the Zoom App for making phone calls) and automatically launches one into the Zoom Phone app, along with the person's phone number, and the last step is to click "dial" in the Zoom App.

The search continues - but thank you for sending these examples!

[ajojose33333344]

=HYPERLINK("https://ctrlq.org/call/"&E25, "Call our support team")

where i guess the URL you can point to the zoom app, E25 is the reference to the cell containing the phone number and "Call our support team" is the custom text to display on that cell

[dalkesm]

Ty for this.  I have tried this link, and it "kinda" works lol.  It opens a web page where one then has to select an app to use ie. "Zoom Meetings". 

If I can train our team to use this two-step process, I'll be golden.  But somewhere in our phone list I would have to post the instructions; and if people "miss" the instructions, they'll be stuck at the browsing page, as the pop-up in the top right corner is not that noticeable and not that clear (those that are technically challenged will have issues lol, and we have quite a few!).

[dalkesm]

I had someone try this (they are tech savvy) and they were confused at the browser window. 

If someone can come up with additional formula/programming language to insert into the above hyperlink, which would pop one straight through the browser window and into the Zoom App, I would be super happy!

[bill_pier3]

This solution (which I haven't tried) might work, using Apps Script to open a new tab serving HTML that contains Javascript to open the target URL. 

Stackoverflow: How I Can Open URL Directly With App Script 

[dalkesm]

Ty for the option.

I'm not having an issue opening a URL.  My issue would be opening the Zoom App automatically after the URL opens.

[scheived · Accepted solution]

I've been looking for click-to-call from Sheets as well. According to google's documentation of hyperlink on sheets tel: isn't available, and there's sanity checking of the url if you try and use a phone number in the hyperlink it won't accept it.  This does work however for Excel. 

For Sheets, the workaround I've found is to turn on the Call highlighted number feature in Zoom client. 

From the Zoom client click on your profile picture, settings, Keyboard shortcuts, scroll down to Phone section and turn on "Call highlighted number/search directory" Here you can give it an alternative shortcut as well, I used Ctrl+D. Now in Google Sheets click in the cell containing the number you want to dial and press your keyboard shortcut, Zoom will open and dial the number. You're welcome 🙂

[dalkesm]

You've made my day - I think I shrieked - exhausted - going home now . . .