Google Chat bot linked to a google sheet

2k views Asked by At

The final idea of the bot that I am building will be to send out messages on the chat when a google sheet is edited. But first I am trying just to create a Google Chat bot linked to a google sheet with the hangouts chat template given by google. For this I used the steps described in the following link: https://developers.google.com/hangouts/chat/quickstart/apps-script-bot

With this, I was able to create a bot that works with a standalone app script (a standalone script is any script that is not bound to Google Sheets, Docs, Slides, or Forms file or Google Sites) but when I work with a bounded app script (bounded with a google sheet), I receive a message "...bot not responding" in the chat. To change from the standalone script to the bounded script I just changed the deployment ID of the app scripts under the Connection settings (step 2 in the link above). Should I do something else for this to work?

I am not finding that much documentation about this so I would be very happy if you have any suggestions for me.

1

There are 1 answers

0
user14491665 On

I was missing the "chat": {} object on my manifest file.

{
  "timeZone": "America/Los_Angeles",
  "dependencies": {},
  "chat": {
    "addToSpaceFallbackMessage": "Thank you for adding me!"
  },
  "exceptionLogging": "STACKDRIVER"
}