Skip to content

Comment on Use Google Spreadsheets as a CMSparent

Comments

I am using Google Spreadsheet as a simple back-end just using client-side JS (on a website to track testing of Firefox add-ons). I've been meaning to write a blog post about this because the existing blog posts I read each missed some details about parsing the spreadsheet data or accessing different spreadsheet tabs.

1. My data is on this spreadsheet: https://docs.google.com/a/mozilla.com/spreadsheets/d/1CXdwQq...

2. I load the spreadsheet's tab "1816064743" as XML: https://github.com/cpeterso/arewee10syet/blob/master/index.h...

3. Then parse the spreadsheet rows and columns here: https://github.com/cpeterso/arewee10syet/blob/master/js/gdat...

4. And display the pretty results on my website: http://arewee10syet.com/

AboutSource Built by g1lg1l

Hackerly is an independent reader for Hacker News, built on the public HN API. Not affiliated with Y Combinator.