It depends what do you mean "go automatic with actions". When we did something 3 mins ago and forgot about it may be a distortion of short term memory or working memory (depends on what you forget).

If we're drunk and later forget what we did I think the problem is while encoding information while we're drunk. So our mind does not really save information what we do then. We may even be pretty conscious while being super drunk and still forget what we did after that.