We have an "internal systems" team at my current company to solve this problem. The product manager for the team knows everyone and keeps tabs on what's being done that could be automated. It's not used to replace people (at least it hasn't been yet) rather it's used to allow the team to stay the same size and scale up their operations to meeting the growing business demands.
I think many companies could benefit from a team like this.
I think many companies could benefit from a team like this.