" Being able to write to, and read from, [mySQL] databases directly from your Google Sheet can be a huge advantage. In the e-commerce example, for instance, you may want todownload order information for delivery completion, label printing or later sales analysis, or you may choose to upload new data from your spreadsheet to the on-line store including prices, product descriptions and so forth."
"If you are writing Apps Script webapps and accessing some of the Google JSON APIs services, you're going to need to deal with oAuth2. This library using the statetokenbuilder should help get it right first time."
"I decided to see if I could write a script that would scan the news sites I read each morning and deliver a customized news feed to my Gmail inbox, along with a summary of my day’s calendar ... The script itself is pretty simple: it scans a set of news feeds, creates links to the stories, scans the headlines for specific words, and calls them out separately from the rest of the news. It also reads my calendar for the day’s events and tells me if I have any upcoming events that I have not yet RSVP’d to. "
"Getting it into a spreadsheet is a good start, but what if you want to get the data into some other kind of format? A fusion table, an Orchestrate database or some other medium for example. Let’s say you are creating a mobile application that accesses parse.com for its data, and for this application we need some data processed by import.io, perhaps merged with some data from some other source. Here’s how we can use Google Apps Script to achieve that."
"In the absence of being able currently to connect my local MS Access database direct to Google via JDBC or similar, I have found a method of updating Google Sheets and related Awesome tables with Access data, which uses a combination of Drive, Google Apps Script and a Google Sheet. "
"In the last few months, we've added a number of new features to Google Apps Script, includingadd-ons for Sheets and Docs and 7 new advanced services.
We're eager to maintain that momentum — focusing on new features that help you do more with Google Apps. As a result, we're deprecating two Apps Script services for which good replacements exist elsewhere: ScriptDB (a NoSQL database that has been marked as experimental since it was introduced) and the Domain service (which encapsulates the GroupsManager, NicknameManager, and UserManager global objects).
Both ScriptDB and the Domain service will be turned off on November 20, 2014."
Martin Hawksey's insight:
Sad news about ScriptDb - it had it's issues like tracking quotas across projects but the NoSQL storage was handy.
There are lots of times when it would be useful to create batches of sheets with customised information, share these with specified people automatically, and have any changes that those users make, automatically collected and visible from one...
If you are using the Maps.Directions API, and plotting many source/destination points, you may be hitting quota problems (too many calls in too short a time, maximum daily allowance). Here's how to automate the use of waypoints to make your quota go further - reducing the number of API calls required by as much as x 20.
"As the CEO of an email productivity company, not a day goes by when I don’t learn about a new email pain point. I love solving email problems for our customers, but many of their problems do not lend themselves to a full browser-extension and server solution, like the products we make. Apps Script is perfect for solving some of these problems in a quick, lightweight, customizable way.
The Awaiting Response script is a perfect example of one of these solutions."
As you will know by now, ScriptDB is now deprecated. A year or so ago, I published some articles on alternatives to ScriptDB on the desktop liberation site, one of which was Parse.com. This has turned out to be one of the most popular topics. Here's how to get started and get your data off scriptDB.