NOTE: ScriptDB is now deprecated. Please take a look at Database abstraction with google apps script for alternatives.
Here's a slideshare primer to introduce the concept.
Here's how something like this might work. Elsewhere in this site, you'll see how to interact with Google Maps and Google Earth using a webapp directly generated from an Excel Workbook. It goes something like this. Fine, but there is no opportunity to collect data from the Mapping application and feed it back to Excel.
However, if the webapp was instrumented to be able to record data in a temporary drop box, then we could complete the feedback loop and use such a web app to enrich the original Excel data.
Although I'm using scriptDB as the deaddrop here, I could also implement this on parse.com (i probably will), since we also now have parse.com - nosql database for VBA and parse.com - noSQL database for GAS. The differences will be fairly trivial. Watch this space if parse.com is your preferred thing.
You can get me on Google plus, Twitter or this forum, and compare this topic with A VBA API for scriptDB
Services > Desktop Liberation - the definitive resource for Google Apps Script and Microsoft Office automation > Things that have been deprecated > Google Apps ScriptDB >