"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...
This post illustrates how you can integrate the structured web data scraping service import.io with Google Apps Script.
Martin Hawksey's insight:
Extracting data from HTML pages with Google Apps Script can be a bit fiddly. There are a number of web services such as import.io that turn this into a point and click expereince. I particularly like import.io because they appear to have spent time of the developer experience with lots of example code and client libraries. Here's a click look at how you can integrate Google Apps Script with the import.io service
"Our most-often recommended CRM product, Norada's Solve360, has now introduced their own add-on for Google Docs that allows you to create merged documents and labels from records that already exist in your Solve360 database."
"In a follow up to our previous post, Top 10 Google Apps Script for Education we are happy to bring you our updated Top 10 Google Docs & Sheets Add-ons for Education. Google recently launched the Add-ons feature, which brings really useful Apps Script based extensions to Docs & Sheets. Add-ons are really easy to discover and install, and become available across all Docs & Sheets when they are installed."
"Sometimes you start with a particular database, or a spreadsheet, then you decide to use something else, and you have to refactor all your code. This is an early version of a Google Apps Script handler for database abstraction (with of course a heavy focus on Google options), to try to avoid some of that pain. "
After a beta period that started in March, earlier this week, Google rolled out scripts for AdWords MCC accounts to all users. AdWords scripts can be used to automate account maintenance, changes and reporting. The ability to use scripts in MCC (My Client Center) accounts means users can now get the benefits of automation across […]
"The old UserProperties and ScriptProperties services have been deprecated and replaced by the new PropertiesService. In the old service, a user property was available from all scripts to a particular user, and a script property was available to all users of a script.
In this new service, the getUserProperties() are available to a particular user running the current script, and getScriptProperties() are available to everyone running this script
At some point you'll need to migrate your existing properties to this new PropertiesService. Here's a handy script to do that..."
Arun Nagarajan: "I finally made the switch to zero inbox and its amazing how useful a small#AppsScript can be. I used to do this silly thing where I marked messages I needed to act on as "unread". Now, if its in my inbox, I need to work on it."
"There are many rates and quotas in the Google Apps Script environment. One of the usual ways of dealing with it is to sleep between instructions, but that seems to be a rather blunt instrument. So here's a way of adapting to rate limits using an exponential backoff technique ... This is a fairly simple idea, where if something fails because of some temporary reason (for example rate limiting), you can wait a bit and try again. The exponential part is that you wait increasingly longer amounts of time between attempts. Eventually of course you give up."