Get post data from Blogger into a google Spreadsheet with the Google Blogger API

If you use blogger.com you may want to get some data about your posts into a spreadsheet for analysis. For example, the d3 concept browser analyses the Excel Liberation site and blog each night. There is a blogger API which makes this very straightforward. As well as the blogger API, for convenience,  I'm using various functions such as sheet caching and using scriptDB as a lockbox from the mcpher library which you can include in your code.
In this case, while i was researching the half life of blog posts, I needed to get list of all my posts and the date they were published. The final output starts like this

The code

Source http://excelramblings.blogspot.com/2014/01/get-post-data-from-blogger-into-google.html