There is a wide variety of reasons for why automation efforts fail. If your own initiatives aren't quite paying off, take a step back and ask what you can do better.
Improving Automation Efforts
For example, consider the fact that your end goals just weren't clear enough. You'd be surprised what you can achieve when you have a clear vision in mind.