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

If you use 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

Author: brucemcp

Leave a Reply

Your email address will not be published. Required fields are marked *