Struggling with consistency

I keep running into the same wall where I’m hyped for like two weeks and then I just have no energy with my body. Work and life burn me out, and by 6 PM the idea of lifting heavy objects or running sounds like torture. Been a hot summer too which doesn't aid. In winter time, a good workout warms me up, so that motivates me alone haha

Biologically, if you're running low on glycogen, your brain literally signals your central nervous system to make movement feel way harder to save fuel. Though the same sugars make me crash as well, so I tend to avoid consuming a lot of it. Would this signal to me that I might need to consume more sugar? Thinking maybe to have some yoghurt mixed with honey for this.. I have some creatine powder that I take with the yoghurt in a mix as it is

So for anyone who works a normal job or deals with fatigue from life, how are you tricking yourself into getting back to working out? Do you just force yourself through it, or am I setting my daily routine up completely wrong?

Also interested in general advice for where to find motivation, or how to keep it too..😅