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

About brucemcp 224 Articles
I am a Google Developer Expert and decided to investigate Google Apps Script in my spare time. The more I investigated the more content I created so this site is extremely rich. Now, in 2019, a lot of things have disappeared or don’t work anymore due to Google having retired some stuff. I am however leaving things as is and where I came across some deprecated stuff, I have indicated it. I decided to write a book about it and to also create videos to teach developers who want to learn Google Apps Script. If you find the material contained in this site useful, you can support me by buying my books and or videos.

Be the first to comment

Leave a Reply

Your email address will not be published.


*