Apps Script is really powerful and often overlooked as a way to easily automate workflows that involves Google workspace apps.

I’ve built an app similar to this example but that takes things a bit further. It lets you send notifications to a variety of platforms and have them triggered based on conditions such as a cell containing a certain value or a date being reached etc

If you want to check it out the site is https://checksheet.app, happy to answer any questions about it.