Yesterday I had an amazing experience automating scheduling posts the next six months of events. This included scheduling six monthly announcement posts, each with a custom photo and video, and then also setting up reminder emails for each of these, closer to the time of the event.
All I had to do was to collect the dates, photo file names and video URLs I wanted to use in a spreadsheet and the rest was largely handled by automation.
Read I used Warp and the Ghost Admin API to automate this task.