There was an IPSOSmori survey to that tune in mid-September. It was contradicted by a following YouGov poll in November where Sturgeon was seen as doing better.

And of course "doing well in her job" doesn't matter much if 38% of Scots vote SNP vs 16% Tory voters (from the Yougov survey).