Does anyone use automation to set an alert on the same day it's added?

Hi everyone,

We need to be able to send an alert in a workspace when something is ready to view on the same day it's set up. It does not need to be triggered when something changes as many changes can be made that don't not make it ready to view yet. Only when it's ready do we want to send an alert.

Reminders are processed between midnight and 4am so they won't work. Has anyone run into this and if so what worked for you?