Run Automation When Blog Post Publishes?

So you're talking when you publish it but the publish date is set in the future?  Depending on how fast you want to notify people, you could have a job that runs every hour and looks for posts with publish dates/times that were within the last hour or so.  Could get a little tricky if your job does not execute right on time.  

But you could query the blogposts, sort by date, and as soon as you find a publish date that is out of bounds, just exit the loop.  You could even set an extended attribute on the post to flag if the automation executed on the post to avoid it being hit twice.

So you're talking when you publish it but the publish date is set in the future?  Depending on how fast you want to notify people, you could have a job that runs every hour and looks for posts with publish dates/times that were within the last hour or so.  Could get a little tricky if your job does not execute right on time.  

But you could query the blogposts, sort by date, and as soon as you find a publish date that is out of bounds, just exit the loop.  You could even set an extended attribute on the post to flag if the automation executed on the post to avoid it being hit twice.

Thats a good idea! We could set a flag when the blog notifications have been sent out so we don't over notify as well.