I understand that, like regular application programming, a lot of this kind of automation comes down to requirements-gathering and formal specification of workflow.
But, in theory, could there be some kind of sufficiently-advanced software wizard that does most of your job? Maybe by monitoring entry-level employees' interactions with the software-to-be-automated over some period, and using that as a training input to a workflow guesser?
I'm not imagining that you could be cut out of the loop entirely, mind you, but rather that you'd reduce the human-interaction man-weeks part of your job down to a few hours of pairing with a domain expert to clean up the output of workflow-guesser into a final model.