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

Fun But Learn: Conduct Poll in Google+ and Display Result in Your Site

Fun But Learn: Conduct Poll in Google+ and Display Result in Your Site | Google Apps Script | Scoop.it
A nice tutorial to conduct polls on Google+ and how you can extract the counts and display them on your web page. This is definitely a nice way to reach to maximum people and get maximum votes.
more...
brucemcpherson's comment, January 26, 1:50 AM
Haven't tried this yet, but it looks like a smart idea.
Martin Hawksey's comment, January 28, 1:24 AM
@brucemcpherson the developer was getting some stick along lines of 'why don't you use forms' ... shame they didn't see some of the creative thinking that went into this
brucemcpherson's comment, January 28, 2:30 PM
Yep.. I was really impressed by the lateral thinking here. I'm sure this idea can be applied to other problems.
Rescooped by Martin Hawksey from Excel Liberation
Scoop.it!

Apps Script custom functions - Excel Liberation

Apps Script custom functions - Excel Liberation | Google Apps Script | Scoop.it
Liberate Excel data from the desktop

Via brucemcpherson
Martin Hawksey's insight:

Highlighting the difference between VBA and App Script functions

more...
brucemcpherson's curator insight, January 17, 6:49 AM

I'm putting together a primer on how to do some of the more common things you do in custom excel functions, but would like to do in Google Apps Script. Register some suggestions here.

Rescooped by Martin Hawksey from Excel Liberation
Scoop.it!

A simple Google Apps Script RestQuery - Excel Liberation

A simple Google Apps Script RestQuery - Excel Liberation | Google Apps Script | Scoop.it

"Liberate Excel data from the desktop"

 

"If you follow this site, you'll know there is a lot of content that shows how to convert VBA projects to Google Apps Script. Eventually, you'll want to leave VBA behind. 

 

Here's a 'no dependency' example of the kind of thing GAS does really well." by Bruce McPherson


Via brucemcpherson
more...
brucemcpherson's curator insight, January 14, 11:21 AM

If you follow this site, you'll know there is a lot of content that shows how to convert VBA projects to Google Apps Script. Eventually, you'll want to leave VBA behind. 

 

Here's a 'no dependency' example of the kind of thing GAS does really well.

malek's comment, January 16, 11:22 AM
True: time to kiss VBA goodbye.
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 1:03 PM
Wow, good to know, just prepared a few projects......
Scooped by Martin Hawksey
Scoop.it!

How to Send Confirmation Emails with Google Forms

How to Send Confirmation Emails with Google Forms | Google Apps Script | Scoop.it
Learn how to send automatic confirmation emails to the user's email address after they submit a Google form. You may also CC a copy of the form to yourself.
more...
No comment yet.
Suggested by Shunmugha Sundaram
Scoop.it!

Track Product Price Drops on Top Indian E-commerce Websites

Track Product Price Drops on Top Indian E-commerce Websites | Google Apps Script | Scoop.it
Learn how to use Indian online shopping price tracker to get free email alerts when product's price drop in Flipkart, Snapdeal, Jabong, Myntra and Yebhi.
more...
No comment yet.
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 10:57 AM
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.