Sharp log-Sobolev inequalities in ${\sf CD}(0,N)$ spaces with applications