How do you automate the deletion of the photos on Apple photos after archiving? I do not think apple provides an API for that. Dropbox and Google photos has API and would be possible to delete it from there after archiving.
One way archive, no automated deleting. I treat it as a WORM drive (write once, read many). Family Apple iCloud shares 2TB storage for $10/month. If we get close to the 2TB limit, I’ll refactor the pipeline.