Nicola Sturgeon's forthcoming memoir will be entitled Frankly, it has been revealed, with the release set for August 14