Google Apps Script
Follow
Find
46.4K views | +84 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...
Scooped by Martin Hawksey
Scoop.it!

Agent Provocateur: Using ScriptApp to process batches in Google Apps Script that last more that 5 minutes

Agent Provocateur: Using ScriptApp to process batches in Google Apps Script that last more that 5 minutes | Google Apps Script | Scoop.it
Martin Hawksey's insight:

Details of a script to get around script execution time limts by automatically creating new script triggers

more...
No comment yet.
Rescooped by Martin Hawksey from Excel Liberation
Scoop.it!

JavaScript client API for Google Apps Script API primer

An API for JavaScript/jQuery client webapps providing CRUD access to Google Apps Script scriptDB - a free noSQL databases. This adds to a VBA API for Excel alre

Via brucemcpherson
Martin Hawksey's insight:

More fantastic work by Bruce Mcpherson

more...
Scooped by Martin Hawksey
Scoop.it!

Fun But Learn: Automatic Back up Your Blog Easily With Google Docs

This article is about how to back up your blog easily with Google Docs. Now our new Blog Exporter can export your articles automatically into your Google Drive. No need of any manual activities.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Excel Liberation.: Google Apps Script Content Service - Cross Domain Puzzle

Excel Liberation.: Google Apps Script Content Service - Cross Domain Puzzle | Google Apps Script | Scoop.it

"Doing cross domain requests for JSON data from client jQuery apps are hard work. In the past, you would have needed a data source that had implemented JSONP, but nowadays you can use CORS (cross origin resource sharing). However CORS only works if the server is co-operating - meaning that it is allowing access from the domain hosting the client doing the requesting.


...


It seems that GAS Content Service does not support CORS, and up till now I've managed GET requests perfectly fine by returning JSONP. However, you cannot POST to a Google Apps Script webapp unless it is publicly available, but the thing is, I need to POST to webapps that have different permissions, and I don't really want to use a proxy to do it."

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

You don't need Google Glass to have fun with Google Glass (and the new Apps Script Mirror Service)

You don't need Google Glass to have fun with Google Glass (and the new Apps Script Mirror Service) | Google Apps Script | Scoop.it

You don't need Google Glass to have fun with Google Glass (and the new Apps Script Mirror Service) ... Martin Hamilton has sucessfully flashed a Smasung Gear watch to run Glass and interact with it using Google Apps Script - http://blog.martinh.net/2013/12/hacking-galaxy-gear-smartwatch-to-run.html

more...
No comment yet.
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 Excel 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!

Nifty Computer Tricks: Deleting multiple empty Google contact groups

Nifty Computer Tricks: Deleting multiple empty Google contact groups | Google Apps Script | Scoop.it
" there does not seem to be an easy way to delete all these empty groups except manually one by one, which I refuse to do. So I wrote a simple script for Google Apps Script to solve the problem"
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Kalyan Reddy – Google+ Automatically receive travel directions for upcoming appointments using Apps Script

Kalyan Reddy – Google+  Automatically receive travel directions for upcoming appointments using Apps Script | Google Apps Script | Scoop.it
Using the new functionality, I threw together a quick sample script that scans my Calendar for the next appointment with a location listed and emails me transit directions. It's designed to be run on a 30 minute trigger.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

A Reddit Scraper Written in Google Apps Script | The Programmer's Library

Learn how you can easily scrape the Reddit website using their own API and a little bit of Google Scripts. No programming or server required.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

How to Find Google Drive Shared Files

How to Find Google Drive Shared Files | Google Apps Script | Scoop.it

"If you would like to take a second look at what all you are sharing from your Google Drive. Here is a small scriptwhich will present you with a list of files and folders you are sharing with others."


Via +Jacob Jan Tuinstra

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

Known Issues with Apps Script in the New Google Sheets - Google Apps Script — Google Developers

The new version of Google Sheets has known issues with the Apps Script features listed below. If you are affected by these issues or any other unsupported features, you should continue to use the current version of Sheets for now
more...
No comment yet.
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!

GaSmarty - Google Apps Script Hacks

GaSmarty is a template engine of Google Apps Script based on Jarty
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.
Scooped by Martin Hawksey
Scoop.it!

Collaborative Tools Project: Creating A Shared Logging System

Collaborative Tools Project: Creating A Shared Logging System | Google Apps Script | Scoop.it
more...
No comment yet.