Automation to schedule the publishing of my site not working?

I could be wrong - but you might need to have published it at least once for the automation action to run correctly. If that doesn’t work, then I think we’ll need to open a bug report following the steps here.