Have I missed some documentation or am I right in thinking there is no way to @mention someone in an AppSheet Google Chat App?
We want to be able to send someone a direct message when a task is assigned to them but, from what I can see and have experimented with, the only way to do this would be to make individual Botd for each user pre-filtered for that use to send them a DM, whereas it would be handy to @mention them in a Space instead, therefore only needing one Bot.
Any suggestions appreciated.
Solved! Go to Solution.
I found a solution so I thought I'd answer my own question to benefit others and as a reminder to me.
To @mention someone in a Google Chat via an AppSheet Chat App you need to use the USER_ID as specified in the Google Chat API Documentation: Messages that @mention specific users.
As an example if you have a field called "Google User ID" then the message text you should add to the Bot would follow this format
<users/<<[Google User ID]>>>
I was dubious it would work as I thought the parsing would get confused by the closing >>> but it does work as you can see in this screenshot:
I hope others find this useful.
User | Count |
---|---|
17 | |
11 | |
7 | |
3 | |
2 |