Live data from Hacker News

Use Google Spreadsheets as a CMS

data.brace.io

21–28 of 28 posts

Re: Use Google Spreadsheets as a CMS

#22
I actually use Google Spreadsheets for signing people up to a newsletter. This way, if they want me to send emails through my mailing webapplication (alpha use, so i'm using it only for myselve right now). I only need to download the spreadsheet as *.csv and i can upload it right in my webapp. The spreadsheet doesn't need to be a specific structure fyi and the app supports multiple languages {{isEnglish}}my English message for {{FirstName}} {{/isEnglish}}{{isDutch}}mijn Nederlandstalig bericht voor {{FirstName}} (=my dutch message){{/isDutch}} in both subject, message (text) and message (html).. So it's quite flexible, i'm just not satisfied with my current layout...

I also tried to use it as a CMS. Using an 3rd party app in Google Drive for editing HTML files and then including it in my website, but i had problems with connecting the webapp with Google Drive OAUTH (spreadsheets was a no-brainer fyi). The problems were with a combo of Google Drive, OAuth and the .Net library that Google released (API V2. i suppose) :-(

I now use a file based database in Asp.Net MVC for my CMS. I'm updating it with every new website i have to create (if the client wants a CMS, off course).

I'm kinda curious what their backup method is when Google Drive goes down? (i thought about caching and a button for the client for cleaning the websites cache, so they could see their changes. )

Re: Use Google Spreadsheets as a CMS

#23
post #7

I built a site for a restaurant and use a Google Spreadsheet as the back-end for menu data. Whenever they have a change to make, they modify the spreadsheet, and the updates are instantly live on the site. They like it because they're very non-technical people, but totally get spreadsheets. I like it because there's version-control on any changes to the spreadsheet, so tracking updates is easy. Everything is cached i…

Agreed. The use case really addresses the Job a client hires a CMS to do.

I like it so much I submitted it to ProductHunt -> http://www.producthunt.com/posts/data-by-brace

Re: Use Google Spreadsheets as a CMS

#24
post #7

I built a site for a restaurant and use a Google Spreadsheet as the back-end for menu data. Whenever they have a change to make, they modify the spreadsheet, and the updates are instantly live on the site. They like it because they're very non-technical people, but totally get spreadsheets. I like it because there's version-control on any changes to the spreadsheet, so tracking updates is easy. Everything is cached i…

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/

Post reply on HN