If it's necessary then motivation is irrelevant. You don't have to be motivated, you have to work.

Your problem isn't motivation, it's not understanding that not all work is, or needs to be, pleasant, or intrinsically enjoyable.

Look at what your goal is: if the result isn't motivating, then the unpleasant work isn't the issue, rather your goal.