There is a great Automator action that automatically uploads activities to Strava when you plug your Garmin in! (not work I know but a good example of a repetitive manual process)
I’ve had a quick Google and I reckon that what OP wants to do is easily doable using Automator or Apple Script as Photos supports both.
Applescript is what I primarily use – it can be used with any supported program e.g. most Apple ones, Adobe, Microsoft office, etc. It allows you to automate any function in those programs & most importantly lets them communicate with each other.
So one of my work tasks is setting up artwork to be printed. If I’m printing a banner then I add a 25mm border around the outside for the hem and a dot around the edge approx every 600mm for an eyelet. With Apple Script this can be done with 1 click. Another job involves producing 100s of similar artworks for signs. My script will look up the spec (i.e. size, text required, logos required, etc) in an Excel spreadsheet and then procedurally generate the artwork in Adobe Illustrator. Similar to using a mail merge but way more versatile.