Trigger an Automation without human input

I suggest that you have a scheduled pipeline which would run every night that would look for overdue records, and then set a date time field to the current date time thus giving you a trigger for your pipeline.

By doing it that way you could choose to  run the pipeline essentially manually by updating that date time field manually or with a Formula URL button but also the scheduled pipeline can trigger it as well.