I've read and am re-reading the book The Slight Edge, by Jeff Olson. It talks about the compounding effective of small decisions made over time, whether that's choosing to act, or choosing not to act.
I found it very motivating for not skipping workouts.