News for hackers. Stuff that matters.
Re:Use a Google Spreadsheet as your JSON backend by nirvanatikku on Monday November 04, 2013 @06:09PM (#6671849)
..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 by andrewb on Monday November 04, 2013 @06:47PM (#6672022)
From personal experience, Google Apps Script is not ready for Enterprise / Production. It's simply too unreliable.

However I do enjoy the API. It's wonderful how easy it is to prototype an idea and get it off the ground with minimal effort.

Re:Use a Google Spreadsheet as your JSON backend by jianshen on Monday November 04, 2013 @06:30PM (#6671947)
Apps Scripts are pretty amazing. You can add custom UI elements to Google Spreadsheets and have it talk to external services (even your own).

My team is currently using it as a makeshift JSON level editor for a mobile game where each tab represents a collection of objects and the schema is defined dynamically by whatever is in the frozen header row. (think Backbone collections and models).

Re:Use a Google Spreadsheet as your JSON backend by AmericanOP on Monday November 04, 2013 @06:53PM (#6672057)
I've been hunting for a dev to connect Google spreadsheets with our company's CRM.

If someone is interested in a project, email is in my profile. I've gotten very lucky meeting smart people through HN before, so why not try again!

Re:Use a Google Spreadsheet as your JSON backend by MediaSquirrel on Monday November 04, 2013 @07:26PM (#6672207)
You probably don't need a dev. Try Zapier.com
Re:Use a Google Spreadsheet as your JSON backend by rattray on Monday November 04, 2013 @09:45PM (#6672892)
I've done a number of things with Apps Script exactly because I couldn't do them with Zapier (or IFTTT, for that matter).
Re:Use a Google Spreadsheet as your JSON backend by BonoboBoner on Tuesday November 05, 2013 @05:52AM (#6674397)
VBA in the cloud?
Re:Use a Google Spreadsheet as your JSON backend by _nate_ on Tuesday November 05, 2013 @09:13AM (#6675103)
I've actually used an excel doc as a backend, which wrote json to a server for an app to consume. And honestly, I would do it again over using a google doc.