This post from Apps Script GDE Bruce Mcpherson steps through the process of collecting and displaying page analytics. Here's the details of what's covered: Getting analytics for the site Getting the pages in the site Matching Analytics to sites pagesDealing with recursion Storing options and parameters Database abstraction of site results Retrieving page data from GAS web service Using a canvas in Google sites Working with hyperlinks in canvas Gadget preferences and parameters Light JSONP implementation
* Added the LinearOptimizationService, which allows scripts to model and solve linear and mixed-integer linear programs. * Add-ons for Google Sheets and Docs can now use most installable triggers, although they still cannot use time-driven triggers (sometimes called clock triggers). * Added an installable open trigger for Google Docs. Like the installable open triggers for Sheets and Forms, this trigger is similar to the simple onOpen() trigger, but allows the triggered function to call services that require authorization, if the user has authorized the script ahead of time. * Added several new ScriptApp methods, classes, and enums to support installable triggers in add-ons: * The UiService widget DocsListDialog now requires that you call DocsListDialog.setOAuthToken(oAuthToken) before calling DocsListDialog.showDocsPicker().
"It is possible to sell apps built 100% with Google Apps Script. People are ready to buy items on the add-on stores. It's easy enough to implement in-app purchases. I will certainly continue to propose apps mostly free, with some premium features / more quota for paying users."
DocsListDialog is a widget used by only a small fraction of Apps Script projects to provide a Google Drive "file open" dialog in a UI service user interface. In almost all cases, using Google Picker in HTML service is preferable and more secure.
"Over the last couple of weeks I have received a bunch of emails from readers who were looking for Google Spreadsheet scripts that they used last year, but cannot find this year. The reason for this is that when Google pushed out the updated Spreadsheets to all Google Apps for Edu domains the script gallery was removed from the "insert" menu in Google Spreadsheets. A few of those scripts are now available as Add-ons, but most are not."
"You may have noticed a new icon in the script editor a couple of weeks ago: a light bulb. This is icon will be grayed out most of the time, but when it lights up it means that our system has some useful information to share about your script, such as performance improvements or warnings about the use of deprecated methods. We collect this data as your script executes, so you won't get any hints until after the first time you've run it."
"Here's 2nd in 'do something useful in 5 mins with Google Apps Script'. The first was about how to use a spreadsheet as a database. In case you've got fed up with that by now, here's how to graduate to using a parse.com backend."
"It’s only Wednesday, but already five updates have been announced this week which impact Google Apps domain admins and developers. These aren’t the sorts of things most users will be interested in, but administrators should definitely be aware of them. Take a look and see if your apps or domains will be affected."
Martin Hawksey's insight:
Shared with the Google Apps Script G+ Community by +Jarod King
" The idea is that your Google spreadsheet will connect to your Google Drive account and list down all documents with ownership information. You can easily add more columns to it like size to find documents with a large size. Once the sheet is ready, you can use Filter option (the Funnel icon) to find files owned by you. You can sort the sheet by file name to arrange them alphabetically. "