Google Apps Script
Follow
Find
69.4K views | +1 today
Google Apps Script
The GAS: All things related to Google Apps Script including examples, news and snippets
Curated by Martin Hawksey
Your new post is loading...
Your new post is loading...
Scooped by Martin Hawksey
Scoop.it!

Launchpad Online: Intro dev video tutorials

Launchpad Online: Intro dev video tutorials | Google Apps Script | Scoop.it
"In the 2015 kick off episode (http://goo.gl/oAzBN9) of the Launchpad Online developer video series (http://goo.gl/kFMUa6), Google engineer +wesley chun shows you how to connect to Google Maps from a spreadsheet! This isn't a party trick... you’ll learn how to do this, why it may be something useful to consider, and have real working code by the time you’re done. In an earlier video (http://goo.gl/1sXeuD), we introduced viewers to Google Apps Script (http://developers.google.com/apps-script), our cloud-based #JavaScript environment giving developers access to Google Apps data as well as other Google services. In this sequel, we'll take your skills to the next level, creating a map based on a street address in a Google Sheet. And maybe, if you hang in till the end, we'll have an surprise bonus for you!"
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Google Developers Blog: Control protected ranges and sheets in Google Sheets with Apps Script

Google Developers Blog: Control protected ranges and sheets in Google Sheets with Apps Script | Google Apps Script | Scoop.it

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

more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Sites Catalog - Google Apps Script Examples

Sites Catalog - Google Apps Script Examples | Google Apps Script | Scoop.it
The add-on Sites Catalog lists all the Google Sites a user has access to. Google Apps administrators (full admin) can list all sites created on their Google Apps domain
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Oauth2 step by step - apps script authentication for the Google Drive JSON API - Desktop Liberation

Oauth2 step by step - apps script authentication for the Google Drive JSON API - Desktop Liberation | Google Apps Script | Scoop.it
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

How to remove the header from a Google document once added - Web Applications Stack Exchange

How to remove the header from a Google document once added - Web Applications Stack Exchange | Google Apps Script | Scoop.it
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Adding Metadata to Google Docs with Google Apps Script

Adding Metadata to Google Docs with Google Apps Script | Google Apps Script | Scoop.it
A couple of months ago I had started working on an export tool that would export a Google doc in the OU-XML format. The rationale? The first couple of drafts of the teaching material that will be d...
Martin Hawksey's insight:

Explorations from Open University lecturer Tony Hirst (@psychemedia) on using Google Apps Script to add metadata to Docs

more...
Ralph Poole's curator insight, February 10, 2:28 PM

Adding metadata to Google Docs will require a little Google Apps Script programming, but the result is a small application that allows you to add metadata to documents. These metadata will make finding documents easier.

Scooped by Martin Hawksey
Scoop.it!

Turn Google Sheets into an Amazon Price Tracker with Google Apps Script

Turn Google Sheets into an Amazon Price Tracker with Google Apps Script | Google Apps Script | Scoop.it
You can use Google Sheets to keep track of prices of products listed on the Amazon shopping website and get email alerts when the prices go down or up.
Martin Hawksey's insight:

Another great script project from Amit Agarwal, this one integrating with the Amazon’s Product Advertising API 

more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Barcode scanning with Google Apps Script  and Chromebook

Barcode scanning with Google Apps Script  and Chromebook | Google Apps Script | Scoop.it

Demonstration by +Lenny Cunningham of some Google Apps Script he's developed to handle inventory using a barcode scanner interfacing with Google Sheets 

Martin Hawksey's insight:

if you look in the sheets shared at top of the original post you can see the script for barcode handling e.g. See Location 1 Medical Inventory sheet Tools > Script Editor

more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Free Technology for Teachers: How to Use Doctopus and Goobric to Grade Google Classroom Assignments

Free Technology for Teachers: How to Use Doctopus and Goobric to Grade Google Classroom Assignments | Google Apps Script | Scoop.it

"Doctopus and Goobric are Google Sheets Add-ons. In the videos ... Justin Brink demonstrates how to use Doctopus and Goobric with Google Classroom."

more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Bruce Mcpherson: A year in apps script and my bucket list

Bruce Mcpherson: A year in apps script and my bucket list | Google Apps Script | Scoop.it

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.

more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Mark Archived Gmail as Read with Apps Script

Mark Archived Gmail as Read with Apps Script | Google Apps Script | Scoop.it
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.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Some best practise notes on DbAbstraction usage

Some best practise notes on DbAbstraction usage | Google Apps Script | Scoop.it

"Since we have a lot of operations going through the database abstraction libraries nowadays (over 3 million since I released this in summer last year),  I thought I'd give a few hints."

more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Real-time logs analysis using Fluentd and BigQuery

Real-time logs analysis using Fluentd and BigQuery | Google Apps Script | Scoop.it
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."
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

An update on the migration of older spreadsheets to the new Google Sheets

An update on the migration of older spreadsheets to the new Google Sheets | Google Apps Script | Scoop.it

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

more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Edit All Your Calendar Events at Once with This Google Script

Edit All Your Calendar Events at Once with This Google Script | Google Apps Script | Scoop.it
Editing individual events on Google Calendar isn't difficult at all, but changing all of the events? Pretty hard without some sort of program, like this bulk edit calendar script.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Simplify your Google Analytics Reporting with Add-ons for Google Sheets - Analytics Blog

Simplify your Google Analytics Reporting with Add-ons for Google Sheets - Analytics Blog | Google Apps Script | Scoop.it

"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 :)

more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Early work from Andrew Stillman on recording and saving audio files using Google Apps Script

Early work from Andrew Stillman on recording and saving audio files using Google Apps Script | Google Apps Script | Scoop.it
I recently tested a small JS library for handling the recording and download of audio files in Chrome and it uses an HTML web "Worker," which fails in… - Andrew Stillman – Google+
Martin Hawksey's insight:

Check the comments thread to see how this is developing

more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Release notes for update to Google Apps Script DbAbstraction libraries

Release notes for update to Google Apps Script DbAbstraction libraries | Google Apps Script | Scoop.it

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

more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Some minimal UiApp to HtmlService conversions...…

Some minimal UiApp to HtmlService conversions...… | Google Apps Script | Scoop.it

Some minimal UiApp to HtmlService conversions... - Bryan Patterson – Google+

more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Using Drive API within Google Apps Script to create a file/folder skipping root

"For those interested in using Drive API within Google Apps Script to create a sub folder and file within a specified Drive folder that skips the "root""

more...
No comment yet.