How could I track the answers of the users who access the messages of chat app in the google space

[Ruxandra]

Hello!

I created a chat application using Appsheet, integrating Google Chat, and I have also a dedicated space.

I created a table, column useremail, mesage, answer, status, but, when I tested the app with a few users, in the table, there is no tracking of the users who answered in the space (I had a message with a question, then the users clicked on a button - action, but there was no new line added).

Could you, please, help me on this issue, what is it wrong in my app?

Thank you very much!

Ruxandra

[Shourya_Tomar]

Hello @Ruxandra, Please refer to the community discussion linked below to determine if the described scenario aligns with your current situation. I hope it helps!

Appsheet integration with Google Chat

I’m trying to create an app where: when a message is created in a specific chat space, the message will be sent to a googlesheet OR when a message is created in a specific chat space, the message will be sent to a gmail account I know this will involve webhooks, and have reviewed a similar topic at Integration with Google Chat - How? Actually it was ultra easy but I’m trying to do the reverse. Is this possible?

[Ruxandra]

Thank you for your reply. I don’t use webhooks. I want to use the application to send messages as part of a training and to register each user who participates in this training by identifying them by email.

Regards!

Ruxandra

[Shourya_Tomar]

Hello @Ruxandra, you can refer to the below thread for more information.

Integration with Google Chat - How? Actually it was ultra easy

The process did not change for me , since 2020 I have not updated some of the gchat webhooks,and they still work just fine. One small change is that now appsheets has automation bots instead of previous action types, but the webhook part is the same. [Screenshot_20230202-221024.png] @Koichi_Tsuji , this thread was a game changer in our organization . Thank you again. Without it, Appsheet would have probably not been implemented this deep and in all departments

Additionally, here is the link to the sample application to facilitate further experimentation. I hope it helps!

[Ruxandra]

It is not clear for me how could I sent messages from the Google chat to the app. I have tried to use an automation: I created a slash command, /started, which should trigger a “Call a Webhook” in order to add a new row in a table, using a json like this:

{
“Action”: “Add”,
“Properties”: {
“Locale”: “en-US”
},
“Rows”: [
{
“useremail”: “<<USEREMAIL()>>”
“no”:“1”
“answer”:“yes”
}
]
}

but it didn’t work, the Automation Monitor there is no registration of the automation, so it seems the bot didn’t work. I mean, there is no error, but it didn’t work either. I don’t understand what happens.

Thank you!

Regards!

[Ruxandra]

Hello again!

I tested the webhook call using an automation triggered by “Data change Type” (I found the issue of my json, I missed some commas), I also added a new step in my Slash command automation , and I saw at slash command /started , I received only the first message of the app, and it means the slash command doesn’t trigger the bot. Do you have any idea why the slash command doesn’t trigger the automation?

Thank you!

Regards!

Ruxandra