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

3X_7_c_7cba5d60feb1e26da8e879cc60011b6486a7567e.gif

2. Just copy the URL

3X_7_7_7793f600109ca59d97ea2e0584f3ff1e4e18cc94.gif

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

3X_1_9_1921324d5038b8e48cf6b858e13f7c142007005f.gif

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

22 Likes

WOW! Excellent find, @tsuji_koichi!

And great post documenting the setup.

2 Likes

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

3 Likes

Here’s an easy Google Meet integration I found:

[How to click one button to call several persons by phone](https://community.appsheet.com/t/how-to-click-one-button-to-call-several-persons-by-phone/28670/13) Questions

AppSheet supports direct connections to Google Calendar as a datasource. And each event will auto-generate a meeting link if the feature is enabled: [Screen Shot 2020-07-31 at 5.25.04 PM] This link shows up in AppSheet when you connect the calendar as a datasource: [Screen Shot 2020-07-31 at 5.11.13 PM] [Screen Shot 2020-07-31 at 5.17.26 PM] Once you click the meeting link, you can add users by calling them. [Screen Shot 2020-07-31 at 5.21.32 PM] I think that’s as close as you can get…

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!

Add Events to the App-USER’s Calendar Using Dynamic New-Draft Event Links Tips & Tricks ?

AppSheet can use a Google Calendar as a data source, but the app-owner is always the ‘Meeting Organizer’, or owner of the event. What if you want to create an event in the app-user’s calendar? I found a free webtool to build custom links to a new calendar event. You can specify event details, then generate a link that will open a new draft event in the app-user’s calendar. [Screen Shot 2020-09-10 at 7.36.08 AM] https://www.google.com/calendar/render?action=TEMPLATE&sf=true&output=xml&text=TE…

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.

tsuji_koichi:

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

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.

tsuji_koichi:

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

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”}.

Le_Van_Luyen:

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

It should be

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

1 Like

Hi
I have tried but still error:

then try

{> “text”: “<

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!