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.
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..."
"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...