How to get an automated alert when a daily row is not populated
I currently have a sheet where a row is automatically created once an email hits a specific folder in my Inbox (via Power Automate). The emails come daily. I would like to get an alert say first thing in the morning, if the previous day did not get a new row added for that day. Does anyone know how I can achieve this?
When I look at creating an automated alert, the choices are only when a new row is created or updated, as an example. Not when a row is not created for the previous or even current day.
Thanks in advance.
Smartsheet admin by day, home chef by night