Google chat scritpt with webhooks

[Ian_james_Dunca]

Has anybody created a google chat message automation without having to use a third party tool like automate.io so send messages to people in your google chat when a new record is added or updated?

[Bill_French]

Hi @Ian_james_Duncan, and welcome to the community!

Ian_james_Duncan:

send messages to people in your google chat when a new record is added or updated?

Yep - client hired me to create it using this Google Apps Script API. With script actions, it’s possible to mimic the events that call to a webhook server in Google Apps Script; then push the messages using the Chat API.

[Ian_james_Dunca]

what sort of cost would that be?

Also do you know anything about auto generating documents?

[Bill_French]

Ian_james_Duncan:

what sort of cost would that be?

It depends on the deeper requirements -

• What data [exactly] needs to be pushed into the chat stream?
• What data from the chat stream needs to be pushed back into Airtable?
• Are there any requirements to have the integration work like a chat bot? (i.e., type certain commands in chat and retrieve and display Airtable data in the chat session?