I work in Tech Support and Google Sheets helped me automate repetitive tasks!
This helped me push messages to various teams who use Google Chats, the Webhook option present in Google Chat is amazing.
The Goal was to track Incidents(Outages) and then push notifications to various teams which was manual before I found out about Google Sheets Simple Triggers.
Here are few links that might help you get started.
Now all we had to do was enter the data in a specific Cell and the
onEdit() function would read it and post it to the necessary chat rooms.
You will need to add the trigger from Google Scripts
Enough talk! Show me the code!
Thank you for reading, if you like this article feel free to share it as always I'm open to constructive feedback and criticism, feel free to leave a comment or message me.