"Wake Screen" and "Wake Mac" are two entirely different things. If your Mac is "asleep" in the middle of the night, then you will need to "Wake Mac". There is no KM Action for that because KM Macros cannot be triggered when the Mac is asleep.
See this thread:
For more information, see the wiki Searching the Forum for Answers section.