Google Apps Script
Creating a custom solution with Google Apps Script has several drawbacks. Scripts can be challenging to manage and secure, often lacking the coding standards typically followed by developers. They also lack built-in alerting and reporting mechanisms, requiring vigilant monitoring to adapt to changes in Google APIs when necessary.