Is there a known Molecular signalling pathway for motivation

well sort of yes.
Norepinephrine is a signal molecule that stimulates the frontal lobes. This region of the brain is responsible for turning a thought into action. If you consume caffeine or any other upper then the level of norepi in the synapse increases. You become more motivated by increased activity of the frontal lobes.