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

Appsheet should naturally get tied with G Suite services and product as the time goes by, which is basically “No Doubt”. I believe you app creators would agree with it.

Google Chat should be one of the service G Suite users are broadly adopting to their day to day jobs on the enterprise basis. It should be common needs “How to integrate Appsheet app with Google Chat”?

Bunch of people should have been implemented this integration, but I tried it out with my app, and found it was super simple and easy. To share my experiences for those who would seek a solution toward the future. (this is also my own memorandam…)

1. Get the “End point” URL from your Google Chat Rooms.

  Beatifully simple. Go to your Chat room and copy the URL.

  Go to your chat rooms you want to submit messages.  And hit the Manage Webhook

2. Just copy the URL

3. Go to Appsheet editor, workflow and past the URL you copied.

BF23DDD1-3D9F-4CB7-A87E-839E5A2B8B1C

Note

Workflow settings.

  • Preset Custom
  • URL One you just copied
  • Verb POST
  • HTTM Content Type JSON
  • Body – JSON

Simple JSON!

{
“text”: “<<[FieldNameYourWantToPassFromaRowToGoogleChatRoom!]>>”
}

Beside that, you simple set up workflow as usual, when and how to “fire” the workflow as you wish.

Thank you Appsheet team, to make it and our life super simple and easier!!!

According to Google API documentation, we could do lots, sending message to chat room with card view etc. Should be a fun.

https://developers.google.com/hangouts/chat/concepts/cards

Please try it out and kindly share your own experiences and tips you find.

We have had native connector on webhook set up for Slack even before Appsheet become google cloud team, so I suspect this integration should be come much more simpler, but until then we just set up in this way, but still easy.

@tmiyai

11 Likes

WOW! Excellent find, @tsuji_koichi!

And great post documenting the setup.

1 Like

Like for those pro engineers and pro appsheet handler like you, you probabaly can set this up with your eyes closed…

1 Like

Here’s an easy Google Meet integration I found:

3 Likes

Thanks for this, shamely I overlooked it.

The problem in terms of google calendar as data source, is how to change the “organizer”… I discussed privately with Appsheet team, but still can not find a solution. And the google meet settion is auto generated, but unless “organizer” is to join the session, we can not invite others, which is a problem, as far as I clearly remember the issues.

1 Like

Koichi, if I remember the case it was that if the organizer is not joining the event, nobody is able to join because with the normal gSuite they need to ask the permission to join.

Too many topics I discussed with you, friend, I will wrap up things !
Yes, you should be right!

1 Like

I do the same as you but what is the error like this?
Failed: Webhook HTTP post request failed with exception The remote server returned an error: (400) Bad Request.

See my original post.

JSON must be in this schema, so you are getting error.

I have tried but still error:
Failed: Webhook HTTP post request failed with exception The remote server returned an error: (400) Bad Request.
Help me!

What you json body currently looking like.

body:
{
“Tên HH”: “<<[Tên HH]>>”
}

Error:
Failed: Action not performed because 1 errors are present. Error: Failed to parse JSON due to Invalid property identifier character: “. Path ‘’, line 1, position 1… Invalid JSON value starts with: “Tên HH”: “Máy xịt rửa Model KHG-1410A - Kowon”}.

It should be

{
“text”: “<<[Tên HH]>>”
}

Hi
I have tried but still error:

then try

{
“text”: “<<encodeurl([Tên HH])>>”
}

tôi đã thử nhưng vẫn lỗi:
ailed: Action not performed because 1 errors are present. Error: Failed to parse JSON due to Invalid property identifier character: “. Path ‘’, line 1, position 1… Invalid JSON value starts with: “text”: “M%C3%A1y%20x%E1%BB%8Bt%20r%E1%BB%ADa%20Model%20KHG-1410A%20-%20Kowon”}.

Unfortunately, I run out of my idea, and it is beyond my skill.
Suggest you go to support appsheet to call for a help.

I only guess your [Tên HH] field may contain the value which can not be used in HTTP request.

Thanks you very much!

I discovered the error is due to the mode not enabled:
Run asynchronously?
Should AppSheet run this webhook asynchronously (in the background) and let the rule return immediately ?.
But the data is not sent to google chat?
Help me!