I have started subscribing to the believe that it is not about motivation, it's about discipline. There is only so much you can do to motivate yourself to do a tedious or onerous task. But if you have discipline, you don't need the motivation.

I still struggle a lot with procrastination, but I find this reframing to be helpful.