Andrew explains how caffeine affects dopamine receptors, increasing motivation and drive. He also discusses how caffeine affects alertness through the release of adrenaline and its impact on the sympathetic nervous system. However, he warns against consuming caffeine too late in the day, as it can disrupt sleep quality.