Google Apps Script
Follow
Find
70.9K views | +16 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!

Creating update notifications in new Google Sheets using Google Apps Script

Creating update notifications in new Google Sheets using Google Apps Script | Google Apps Script | Scoop.it
"Using the new Google Sheets? Here's how to set up notification rules Google Docs Top Contributor, Adam, shares how to set up notification rules in the new Sheets using a script. "
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

More Google services available in Apps Script - Google Apps Developer Blog

More Google services available in Apps Script - Google Apps Developer Blog | Google Apps Script | Scoop.it
Martin Hawksey's insight:

Included

* Admin SDK Directory service* Admin SDK Reports service* Fusion Tables service* Google+ Domains service* Mirror service (Google Glass)* YouTube service* YouTube Analytics service
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Connecting Zendesk and Google Spreadsheets using Google Apps Script - Control Group

Connecting Zendesk and Google Spreadsheets using Google Apps Script - Control Group | Google Apps Script | Scoop.it
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

CesarsTechInsights: Enable HTML5 Offline functionality to your gDrive hosted web apps!

CesarsTechInsights: Enable HTML5 Offline functionality to your gDrive hosted web apps! | Google Apps Script | Scoop.it
How to easily hack Offline functionality (AppCache) to your gDrive HTML5 hosted Apps with GAS.
more...
No comment yet.
Rescooped by Martin Hawksey from desktop liberation
Scoop.it!

Excel Liberation.: Shared Encryption/decryption library for Google Apps Script.


Via brucemcpherson
more...
brucemcpherson's curator insight, November 28, 2013 1:57 PM
Amit Agarwal recently showed how to encrypt/decrypt Email messages using a Google Apps Script application in this post  The encryption method he used is SJCL, maintained by the Stanford Security Lab, and available on GITHUB here. I needed something like that for Google Apps Script version of a parse.com API (here's the VBA version) that I'm just finishing up, so I thought I may as well share out the library.
Rescooped by Martin Hawksey from iGeneration - 21st Century Education
Scoop.it!

Create and Send a Merged Newsletter: Docs, Spreadsheets and Apps Script | Google Gooru

Create and Send a Merged Newsletter: Docs, Spreadsheets and Apps Script | Google Gooru | Google Apps Script | Scoop.it

"In this video, you’ll learn all about the AutoCrat script, and how you can use it to put together the perfect holiday newsletter. With the power of Google Apps Script you can combine Google Docs, Spreadsheets and Gmail to create a personalized newsletter, without having to write several different versions."


Via Tom D'Amico (@TDOttawa)
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Collaborative Tools Project: Emailing Someone a Fancy PDF When They Submit a Google Form

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

CesarsTechInsights: How to easily use BigQuery's Querys & Charts with Google Apps Script! (and our FREE library)

CesarsTechInsights: How to easily use BigQuery's Querys & Charts with Google Apps Script! (and our FREE library) | Google Apps Script | Scoop.it
How to easily use BigQuery's Querys draw it using Google Charts with Google Apps Script! includes a Free Library to help you setup your querys faster.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Awesome Things You Can Do With Google Scripts

Awesome Things You Can Do With Google Scripts | Google Apps Script | Scoop.it
A collection of top Google Scripts for Gmail, Google Drive, Calendar, Contacts and other Google services. No programming knowledge required to run the scripts.
Martin Hawksey's insight:

Amit Agarwal shares over 30 of his script projects (with some guest contrubutions) showing the wide range of problems you can solve with Google Apps Script

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

PJ's Development: Google Drive - Bulk letter generation (with Google Apps Script)

Martin Hawksey's insight:

Via +Jacob Jan Tuinstra

more...
No comment yet.
Rescooped by Martin Hawksey from desktop liberation
Scoop.it!

Validation and lookups using shared google apps scriptDB lists


Via brucemcpherson
more...
brucemcpherson's curator insight, September 19, 2013 7:13 PM

Here's how to access shared lists across workbooks using vlookup, index and match style functions, and how to use those same lists to create and apply dynamic dataValidation to Google Spreadsheets.

Scooped by Martin Hawksey
Scoop.it!

Useful Google Spreadsheet Script Triggers | Railsware Blog

Useful Google Spreadsheet Script Triggers | Railsware Blog | Google Apps Script | Scoop.it
"In my previous blog post, I've provided a brief intro to Google Scripts and with this article, I'd like to share several useful code examples that might come"
more...
No comment yet.
Rescooped by Martin Hawksey from New Web 2.0 tools for education
Scoop.it!

Goobric Walkthrough

Goobric is a Chrome extension that works as part of the Doctopus Google Apps Script written by Andrew Stillman. It allows teachers to attach a rubric to each...

Via Kathleen Cercone
more...
Jonathan Jarc's curator insight, August 12, 2013 12:06 PM

Great in conjunction with Doctopus. Highly recommended.

mmarotta's curator insight, November 27, 2013 1:20 PM

Testing out with SWR this week

 

Scooped by Martin Hawksey
Scoop.it!

MASHe Review 2013: Google Apps Script and Google Sheets

MASHe Review 2013: Google Apps Script and Google Sheets | Google Apps Script | Scoop.it
A look back at some of the work I’ve done around Google Apps Script and Google Spreadsheets/Sheets in 2013
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Growing collection of Google Apps Script examples from Sérgio Souza Costa

Growing collection of Google Apps Script examples from Sérgio Souza Costa | Google Apps Script | Scoop.it
The site is in Portuguese so you might want to head to translate.google.com. The examples so far focus around using GAS for various embed solutions (YouTube, Slideshare)
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Building a contact form - Jacob Jan Tuinstra

Create a fairly response contact form, all from within Google Apps Script.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Google Apps Script methods Utilities.jsonParse() and Utilities.jsonStringify() have been deprecated

Martin Hawksey's insight:

"The Apps Script methods Utilities.jsonParse() and Utilities.jsonStringify() have been deprecated in favor of the now-standard JavaScript methods JSON.parse() and JSON.stringify(), which now appear in autocomplete."


Via +Ivan Kutil

more...
Jacob Jan Tuinstra's comment, November 26, 2013 4:03 PM
Wow, good to know, just prepared a few projects......
Scooped by Martin Hawksey
Scoop.it!

Collaborative Tools Project: The Apps Script and Google Spreadsheet Room Booking System

Collaborative Tools Project: The Apps Script and Google Spreadsheet Room Booking System | Google Apps Script | Scoop.it
more...
No comment yet.
Rescooped by Martin Hawksey from desktop liberation
Scoop.it!

Scriptdb - not just for Google Apps Script

Scriptdb is a no-sql db associated with each Google Apps Script. Here's some unusual uses - it's a useful db in its own right.

Via brucemcpherson
more...
No comment yet.
Rescooped by Martin Hawksey from Google Product News
Scoop.it!

Total Eclipse of the Apps Script [Google Apps Developer Blog]

Total Eclipse of the Apps Script [Google Apps Developer Blog] | Google Apps Script | Scoop.it
Apps Script started out as a simple tool to let developers add new features to Google Apps, but it’s grown into a programming platform that thousands of professional coders use every day.

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

DJ's Weblog » Blog Archive » SheetAsJSON – Google Spreadsheet Data as JSON

DJ's Weblog » Blog Archive » SheetAsJSON – Google Spreadsheet Data as JSON | Google Apps Script | Scoop.it
"This is a short post to explain how to expose a ‘typical’ Google spreadsheet (rows of columnar data, with first header row) as JSON, via HTTP"
more...
No comment yet.
Rescooped by Martin Hawksey from desktop liberation
Scoop.it!

Excel Liberation.: Excel custom functions that can lookup data in Google Apps Script ScriptDB

Excel Liberation.: Excel custom functions that can lookup data in Google Apps Script ScriptDB | Google Apps Script | Scoop.it

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

Apps Script Development for Google Sites by Santiago Montesdeoca

Apps Script Development for Google Sites by Santiago Montesdeoca | Google Apps Script | Scoop.it
"We created a little Apps Script Development guide for Google Sites. Please feel free to leave comments in the document."
more...
No comment yet.