Use a Google Spreadsheet as your JSON backend

#1

Post by bitsweet » Mon, Nov 04, 2013, 10:10 PM UTC

Use a Google Spreadsheet as your JSON backend
coderwall.com

Re: Use a Google Spreadsheet as your JSON backend

#2

Post by yahelc » Mon, Nov 04, 2013, 10:36 PM UTC

Tabletop is a great JS library for dealing with this:

https://github.com/jsoma/tabletop

Re: Use a Google Spreadsheet as your JSON backend

#3

Post by nicolsc » Mon, Nov 04, 2013, 10:40 PM UTC

We've been using Google Spreadsheets as part of our "CMS" in our latest website redesign.

We're relying on schema.org normalization: no more item.gsx$stuff everywhere + switching or mixing data providers is effortless.

http://joshfire-tech.tumblr.com/post/65032069418/using-third...

Re: Use a Google Spreadsheet as your JSON backend

#4

Post by chrisweekly » Mon, Nov 04, 2013, 10:46 PM UTC

Clever hack, for prototypes.

Re: Use a Google Spreadsheet as your JSON backend

#5

Post by codenberg » Mon, Nov 04, 2013, 10:46 PM UTC

yahelc wrote: post #2

Tabletop is a great JS library for dealing with this: https://github.com/jsoma/tabletop

Another alternative is the Miso Project http://misoproject.com/dataset/tutorials/googlespreadsheets

Re: Use a Google Spreadsheet as your JSON backend

#6

Post by lsv1 » Mon, Nov 04, 2013, 10:50 PM UTC

yahelc wrote: post #2

Tabletop is a great JS library for dealing with this: https://github.com/jsoma/tabletop

I did the same in php and posted about it here, it's the poor man's DB http://sastrestuff.wordpress.com/2013/10/12/poor-mans-sql/

Re: Use a Google Spreadsheet as your JSON backend

#7

Post by krrishd » Mon, Nov 04, 2013, 10:59 PM UTC

nicolsc wrote: post #3

We've been using Google Spreadsheets as part of our "CMS" in our latest website redesign. We're relying on schema.org normalization: no more item.gsx$stuff everywhere + switching or mixing data providers is effortless. http://joshfire-tech.tumblr.com/post/65032069418/using-third...

I would love to see such a CMS open-sourced, I'm sure there are a lot of people who would like such a thing

Re: Use a Google Spreadsheet as your JSON backend

#8

Post by tburch » Mon, Nov 04, 2013, 10:59 PM UTC

This is a great way of putting a UI on top of JSON! I created http://jsonblob.com/ to accomplish the same thing, but a spreadsheet is much more familiar than a JSON editor.

Re: Use a Google Spreadsheet as your JSON backend

#9

Post by nirvanatikku » Mon, Nov 04, 2013, 11:09 PM UTC

..FWIW, for those of you who haven't been enlightened with the power that Google Apps Script[1] offers yet, be sure to check it out: http://script.google.com. Layered on top of Spreadsheets, this pair takes prototyping to a whole new level.

[1] https://developers.google.com/apps-script/

Re: Use a Google Spreadsheet as your JSON backend

#10

Post by [deleted] » Mon, Nov 04, 2013, 11:12 PM UTC

[deleted]