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

[Koichi_Tsuji]

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.

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

[GreenFlux]

WOW! Excellent find, @tsuji_koichi!

And great post documenting the setup.

[Koichi_Tsuji]

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

[GreenFlux]

Here’s an easy Google Meet integration I found:

How to click one button to call several persons by phone 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…

[Koichi_Tsuji]

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.

[Aleksi]

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.

[Koichi_Tsuji]

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

[GreenFlux]

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…

[MrLee]

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.

[Koichi_Tsuji]

tsuji_koichi:

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

See my original post.

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

[MrLee]

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!

[Koichi_Tsuji]

What you json body currently looking like.

[MrLee]

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

[Koichi_Tsuji]

Le_Van_Luyen:

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

It should be

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

[MrLee]

Hi
I have tried but still error:

[Koichi_Tsuji]

then try

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

[MrLee]

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

[Koichi_Tsuji]

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.

[MrLee]

Thanks you very much!

[MrLee]

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!

[Koichi_Tsuji]

Async seting is nothing to do with your problem.
I strongly suspect the problem is from JSON.

[Koichi_Tsuji]

tsuji_koichi:

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

I decoded your text and passed to my sample app for google chat and it did work without error.

Máy xịt rửa Model KHG-1410A - Kowon

Placed JSON to JSON validator, also returns no error…

Not sure why you see error.

[MrLee]

I do not understand why?
Can anyone help me with this problem?

[Koichi_Tsuji]

re type JSON from scratch.

apostrophes inside JSON payload may be typed wrongly, this is only a guess I have

and then test your json

jsonformatter.curiousconcept.com

JSON Formatter & Validator

Format and validate JSON data so that it can easily be read by human beings.

to see if you see no error.

[MrLee]

I have tried and tested as you said but with no error

[image]

[Koichi_Tsuji]

tsuji_koichi:

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

As i said JSON body need to be above format!

[MrLee]

The syntax is correct but the current data is not passed to google chat. I really don’t know why and what to do.

[Koichi_Tsuji]

What the current json looks like？

[MrLee]

It’s looks like:
{
“STT”: “<<[STT]>>”,
“Ngày KK”: “<<[Ngày KK]>>”,
“Mã HH”: “<<[Mã HH]>>”,
“Tên HH”: “<<[Tên HH]>>”,
“Đvt”: “<<[Đvt]>>”
}

[Koichi_Tsuji]

Please refer to previous message and advice to yoi

[MrLee]

I did everything as you said but couldn’t.
I do not know why.
This creation of you will keep me from using zapie, but I can’t use it now.
I am so sad

[Koichi_Tsuji]

Please ask for support from support@appsheet.com

[MrLee]

Thanks you so much!

[Koichi_Tsuji]

Let me know once the problem is cleared by the support team.
Good luck!

[MrLee]

Yes sir.
They are doing help me!

[OptimiX_XcrY]

I am sorry , i get the same error (“Failed to parse JSON due to Invalid property identifier character: “. Path ‘’, line 1, position 1… Invalid JSON value starts with: “text”: “text automat trimis”}”,) , by only using :

{
“text”: “text automat trimis”
}

Can anyone point me in the right direction please ?

Thank you

[Koichi_Tsuji]

{
“text”:“text automat trimis”
}

Not exactly sure where this problem coming from but possibly double quote?

Copy above JSON and past to the JSON body as it is.

Try it out.

[OptimiX_XcrY]

Thanks for your input. I was just trying that. I typed it all , instead of copying , and it worked.

My typed double quote is : " " " " , and it works
The pasted one is : “ “ “ , and i get that error

They look different. Both written and pasted code is succesful in the recommended Json formatter page. Maybe it has something to do with regional settings.

@Le_Van_Luyen , maybe this works for you too.

[Koichi_Tsuji]

Yes, exactly, that is the root cause of issue.

But not sure why people is getting different type of format for DOUBLE QUOTE…

[Koichi_Tsuji]

https://typographyforlawyers.com/straight-and-curly-quotes.html#:~:text=Straight%20and%20curly%20quo....

Just because of difference betwee straight and curly quotes.

We have to be bear in mind,upon constructing JSON to pass.