Not a coach, but this sounds very familiar! Of course, all of this is very personal, but I have put some thoughts and ideas that have helped me below. Good luck and look after yourself.
Goals and planned trips are definitely helpful, but in my experience you can have the most amazing trip planned for next summer and be really excited about it, but that doesn’t necessarily translate to motivation for doing that training session today. The more sessions you skip, the worse you feel about it and the harder it becomes to find motivation.
I use a “show up to the mat” approach – the phrasing comes from my days as a gymnast, but the concept is the same. If I have a workout scheduled and I am motivated to do it, great. If I am not motivated, I’ll tell myself that I need to show up before I can give up. For gymnastics, that meant putting on workout gear and getting my mat and other kit together. For running, getting my running kit and shoes on and going outside. If I do that and I’m still not feeling it, it’s ok not to do the workout. More than 99% of the time, getting that far is half the battle and once I am dressed and ready to go I will just get on and do whatever I had planned to do. If I’m still not feeling it, I’ll take the same approach again and persuade myself to “just run a mile” or “just warm up” before giving up, and that will quite often be enough to get me there.
The key to this, though, is that there is always occasional day where you do show up and it still feels too much. I’ve certainly had days where I’ve stood on the front porch in my running gear and then gone back into the house to watch Netflix in my pyjamas instead – in those cases it’s ok to give yourself a break and not to beat yourself up about it. For me, knowing that I tried helps with the latter. The important thing is to show up again the next day.
The other useful thing is to train with other people as often as possible. If someone is expecting to meet you at the climbing gym for a session, you’re much more likely to go than if you don’t feel like it than you are if it’s only yourself you are letting down. Even if you aren’t doing anything that requires a partner, the idea of an “accountability buddy” can be helpful, particularly if you are performing the same service for the other person in return.