"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."
"In this example you can use this script to send an email based on a drop selection. Here the school is identified as the criteria for who receives the email. The list of schools and the email recipient are listed on a separate spreadsheet called 'Setting' and can be edited as desired. Also the email subject and message can be edited also. At the end of the email message the form items that were selected at appended to the email."
" We recently submitted our product CloudShuttle to the Chrome web store for Google Sheets add-ons. Am I tired? Yes. Did I spend a few too many late nights in front of a code editor? Yes.
Would I do it again? One hundred bajillion percent yes.
So, having spent the last few month with my head way inside the process to integrate Google docs with an SAP backend through NetWeaver Gateway, I humbly offer a few tips to the blogosphere for anyone wanting to do the same thing. "
In Migrate data from scriptDb to Datastore I showed how to copy over data easily from scriptdb to datastore. The good thing about abstracting the database is that code is the same regardless of which database use you are using (once you've got the handle).
"In EzyOauth2 - taking some pain out of Apps Script API authentication, I provided a library to simplify oAuth2, then in EzyOauth2 patterns I showed simple patterns for creating apps. Now you will probably want to have multiple authentication packages for different packages and scopes. Unfortunately, everybody's oAuth2 implementation is a little different, but we can still use a standard pattern to abstract away those differences.
To illustrate, I'm going to add a new oAuth2 package - this time for the soundcloud service. "
"The SheetConverter Google Apps Script library provides functions that can retrieve the contents of a spreadsheet range in plain text or html, preserving the formatting that is present in the spreadsheet."
"Our special guest for the show is none other than EdTech royalty, Andrew Stillman, creator of insanely useful scripts and Add-ons … most notably, Doctopus and Autocrat. Andrew talks about some of the tools you might not have heard of like siteMaestro and chromebookInventory. He also chimes in on his unique perspective on Google Classrooms."
YouTube Analytics Channel Reports are restricted to the user authorizing the request must be the owner of the channel. This can cause issues in Apps Script when interacting with other services. This post highlights a workaround where the data is proxied via a separate script published as a web app.
There are regular reporting features built in to Google Analytics but what if you want to do customised reporting? One answer is Google Apps Script and this post walks you through access Google Analytics data in one line of code and setting up automated collection
Martin Hawksey's insight:
Not forgetting you can do some sophisticated data manipulation with built-in Sheet formula like QUERY, SORT and combining others using ARRAYFORMULA