In this video, I briefly demonstrate how you can automate routine workflows with a custom add-on deployed in your own domain. Here is the code for you to explore. I've added some comments to this version to make it easier to follow.
https://script.google.com/a/macros/gt...