Help Needed: Integrating Google Chat Directly into AppSheet Action Buttons

[Bhavana1991]

Dear Community,

I've stumbled upon a promising approach to integrate Google Chat directly into AppSheet action buttons, similar to the functionality we have with WhatsApp. However, I seem to be encountering a hiccup and could use some assistance.

Here's the situation: I've successfully integrated both WhatsApp and Google Chat into my client management table within AppSheet. However, while the WhatsApp button seamlessly takes users to a direct message with the intended recipient, the Google Chat button leads to the Google Chat website instead of opening a direct message with that person.

Below is the code I've utilized:

CONCATENATE( "https://mail.google.com/chat/u/0/#chat/dm/", [Email], "?text=", EncodeURL(concatenate( "Hi ", [Client Name], " This is John, Site Manager for your project at", [Project Name], "I'm reaching out to discuss our ongoing project and any updates or questions you might have for the construction progress.", " Please let me know when you are available to chat. Thank you!", )) )

Could anyone kindly point out where I might be mistaken in this code or suggest any alternatives to ensure the Google Chat button directs users to the direct message of the intended recipient?

Your expertise and guidance would be greatly appreciated!

[SkrOYC]

Well, seems like you already know the how-to from the AppSheet side. You will need to go over GChat's deeplink capabilities

[Bhavana1991]

Can you pls explain me in more detail?

[SkrOYC]

I mean it's not an AppSheet issue but a GChat one. So I suggest to look for answers on a forum with GChat users that may have encountered your use case with deep links rather than AppSheet where maybe less than, 10% (?) of people use GChat

[VarunChandran]

In this link "https://mail.google.com/chat/u/0/#chat/dm/"  After "dm/" there should be some code for every user. because when i checked all individual chat links are having linke like this "https://mail.google.com/chat/u/0/#chat/dm/Alphanumeric Code". I don't know how to get that code.

But When I checked with some user's code its actually went to that individual Chat.

[Bhavana1991]

Yeah even I saw that, but how to get that I didn't understand.

[Scott_Nesbitt]

const user = AdminDirectory.Users.get(email);

The user object will have an id field that conains this value.

[OptimiX_XcrY]

I found no easy way to construct a google space message link, even when I know the ThreadKey of the message that I use with webhooks.

Maybe this can help you (it'a above my paygrade but I saved the page when I studied)

https://script.gs/link-to-a-specific-conversation-thread-in-google-hangouts-chat/

https://developers.google.com/workspace/chat/api/reference/rest/v1/users.spaces.threads/getThreadRea...