Quite often you have to manually do the task at least once to determine how to automate it. That tells you your upper bound on how much time can be saved.
If for example it only took 15 minutes of manual work it's highly unlikely that the payback of automation would occur any time soon. That's especially true because the 2nd or 3rd time there may be different special cases and you'd have to go back and change your automation.