How Google Sheets and Webhooks made my life easier!
2 min read
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.
How to Build Apps using Google App Script
Read more about Google Sheets Triggers here
Read more about Google Chat Incoming webhooks
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!
Github Gist of the entire 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.