"A few weeks ago, the Google Sheets team introduced improved control over protected sheets and ranges. Developers have told us they're looking for the same power in Google Apps Script — after all, ever since we added data validation to the Spreadsheet service, programmatic control over protected ranges has been the most popular request on the Apps Script issue tracker.
Today, we are excited to give you that granular control.
With the new Protection class in the Spreadsheet service, your scripts can touch every aspect of range or sheet protection, just like in the new UI. (The older PageProtection class, which had more limited features, will be deprecated, but will stick around in case you need to work with older spreadsheets. The new Protection class only applies to the newer version of Sheets.)"
2014 has been an eventful year for Google Apps Script with some great new capabilities arriving (add-ons), as well some useful ones (ScriptDB) being deprecated. In this post I'll cover my highlights and lowlights of the Apps Script year, and would love to have your opinions on
* did I miss anything significant this year, and do you agree with my comments?
* what do you think the best thing that happened this year in Apps Script?
* .. and the worst ?
* what an 'apps script bucket list' should contain.
A while back, Android added the ability for some of its notifications to be directly acted upon from the notification shade, such as archiving a Gmail message. More recently, this same functionality came to Android Wear.
Mandy Waite "A new tutorial for doing real-time logs analysis with with Fluentd and Google BigQuery. Covers the following steps (requires some billable components of Google Cloud Platform): - Run an nginx web server in a Google Compute Engine instance. - Log browser traffic to that server using Fluentd. - Query the logged data using the BigQuery web UI and using Google Apps Script from a Google Spreadsheet. - Visualize the query results in a chart within a Google Spreadsheet that automatically refreshes."
"Back in November 2014, we announced that older spreadsheets (those created prior to Dec 2013, including any subsequent copies) would start being gradually migrated to the new version of Google Sheets for Google Apps domains on the Rapid release track, with Scheduled domains to follow
...Simpler spreadsheets will be upgraded first, while those that use Apps Script and more complex features will be migrated weeks to months later to ensure a seamless transition."
"It's common for Google Analytics users to use spreadsheets to analyze their Google Analytics data or combine it with another data source. But exporting your data from Google Analytics to Google Sheets is a manual process, and it can be tedious if you run reports frequently or manage multiple accounts. With the release of Add-ons for Google Sheets, getting your Google Analytics data into Google Sheets has never been easier!
Add-ons allow you to extend the power of Google Sheets by automating common tasks and integrating with external services. The Google Analytics Spreadsheet Add-on allows you to access your Google Analytics data, right from within a spreadsheet!"
Martin Hawksey's insight:
Great to see Google Apps Script being used and promoted by other Google product teams :)
"Release notes for update to Apps Script DbAbstraction libraries.
Lots of changes - a brief summary of the highlights.. * transactions now implemented, with rollback for selected drivers * a new driver - scratchDB - this is a transient database that sticks around for as long as you use it, otherwise it cleans itself away * updates to Orchestrate to be able to same complex queries as other back ends"
Sharing your scoops to your social media accounts is a must to distribute your curated content. Not only will it drive traffic and leads through your content, but it will help show your expertise with your followers.
How to integrate my topics' content to my website?
Integrating your curated content to your website or blog will allow you to increase your website visitors’ engagement, boost SEO and acquire new visitors. By redirecting your social media traffic to your website, Scoop.it will also help you generate more qualified traffic and leads from your curation work.
Distributing your curated content through a newsletter is a great way to nurture and engage your email subscribers will developing your traffic and visibility.
Creating engaging newsletters with your curated content is really easy.