Google Apps Script
An alternative solution involves developing a custom solution using Google Apps Scripts, which implies a complex development. However, using Google Apps Script has its downsides. Managing and securing scripts can be quite challenging, often deviating from standard coding practices. Additionally, they lack inherent alerting and reporting mechanisms, necessitating vigilant monitoring to adapt to changes in Google APIs when needed.