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

Announcing Election Info: Using Apps Script to Provide Voting Information - Google Apps Developer Blog

Announcing Election Info: Using Apps Script to Provide Voting Information - Google Apps Developer Blog | Google Apps Script | Scoop.it

"Election Info is a sample application built using Apps Script that can:


* Query the Google Civic Information API to find polling locations and hours using client side JavaScript and AJAX.
* Display polling information using HtmlService with jQuery for a clean effective UI.
* Generate static maps via UrlFetch and the MapsService to show polling maps and directions.
* Create a calendar event for election day with your polling location using the Calendar service.
* Generate a bring-along document with poll directions and hours using the Document service.
* Send you an email with a summary with your polling place information using the Gmail service.
* Store your previous searches in UserProperties so it will remember your likely home address the next time you launch the app."

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

Little Google Apps Script to notify if I'm due an uptime refund

My web host has a 99.9% uptime guarantee and I get account credit if it falls below that. Unfortunately I have to apply each month to get the credit if its due. So I don't forget I made a Google Sheet/Apps Script which uses importHTML to grab the server uptime table http://www.site5.com/support/uptime/s2-london/then MailApp to email me if credit is due (unfortunately I need to submit credit request via their ticket system otherwise it would all be completely automated). The code I use is

// add Resource > Current script's trigger to add refundDue as a week timer
function refundDue() {
  var doc = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = doc.getSheetByName("Sheet1");
  var uptime = sheet.getRange("c3").getValue();
  var date = new Date().getDate();
  var emailAdd = "youremailaddress@gmail.com";
  if (date <= 7){
    if (typeof uptime == "number" && uptime < 0.999){
      MailApp.sendEmail(emailAdd, "Uptime refund due", "Uptime recorded as "+uptime+" http://www.site5.com/support/uptime/s2-london/ \n\nRequest refundhttps://backstage.site5.com/client/helpdesk/list/");
    } else {
      MailApp.sendEmail(emailAdd, "Failed: Uptime refund due");
    }
  }
}

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

Gmail Timer - Schedule when to receive new mail by Musubi Google Apps Script

Gmail Timer - Schedule when to receive new mail by Musubi Google Apps Script | Google Apps Script | Scoop.it

"Gmail Timer is a Google Apps Script which lets you take control of how often you’re interrupted by email. Timer will divert all of your incoming email into a folder until moving them all into your inbox on an interval you specify, whether once an hour, once a day, or anywhere in between." 

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

Heatmapping Conversion Rates, Automagically (with Google Apps Script) by David Fothergill

Heatmapping Conversion Rates, Automagically (with Google Apps Script) by David Fothergill | Google Apps Script | Scoop.it

"n this post I will briefly discuss the introduction of automated Google Analytics reports, and then share with you a report I created you that quickly generates a Conversion Heatmap via the GA API" 

 

via Eric Koleda

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

See all your Google Contacts on a Google Map using Google Apps Script by Amit Agarwal

See all your Google Contacts on a Google Map using Google Apps Script by Amit Agarwal | Google Apps Script | Scoop.it
Learn how to create a Google Map using postal addresses of your contacts that are available inside Google Contacts.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Apps Script in the classroom - Google Apps Developer Blog

"Over the past few years we've seen lots of Apps Script adoption within the EDU community. Educators need lightweight systems that integrate with the Google Apps they already use. Empowered by a cloud-hosted and simple to use platform, non-programmers have been able to create powerful scripts that have a real impact on the lives of their students. In honor of World Teachers' Day we're highlighting some popular scripts educators have created and other materials teachers can use to get started."

more...
No comment yet.
Suggested by Jacob Jan Tuinstra
Scoop.it!

Building a FlexTable with multiple sheets in Google Apps Script - Jacob Jan Tuinstra

This script makes one flex table out of a spreadsheet with multiple sheets.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Automated Google Apps Script Update Notifier - Discover new Apps Script Menthods by keisuke oohashi

Automated Google Apps Script Update Notifier - Discover new Apps Script Menthods by keisuke oohashi | Google Apps Script | Scoop.it

keisuke oohashi has come up with with nice Apps Script web app that automatically looks for new methods within the Google Apps Script Services. The service is here https://script.google.com/a/macros/bfts.co.jp/s/AKfycbz98NsP02DO46Y2kTdTnhqOvqfWuJJpyuznRtfH34cazge33Ew/exec

 

To get an idea of how it was made check the comments in https://plus.google.com/112329532641745322160/posts/a7JERQDc4Ap.

 

For update notifications follow @I_hack_me http://twitter.com/I_hack_me ;

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

[Event] Neo4j + Google Apps Script Code Lab - San Francisco 29th September

[Event] Neo4j + Google Apps Script Code Lab - San Francisco 29th September | Google Apps Script | Scoop.it

"Get acquainted with Neo4j and AppScript at this Codelab by learning to connect Neo4j within a Google Spreadsheet. Using a political dataset, you will learn about graph databases, Heroku apps, and how it can be used with Google apps."

more...
No comment yet.
Suggested by Jacob Jan Tuinstra
Scoop.it!

Building a menu in Google Apps Script - Jacob Jan Tuinstra

Building a menu in Google Apps Script - Jacob Jan Tuinstra | Google Apps Script | Scoop.it

"This little snippet makes it possible to create a menu structure (horizontal and vertical) based on an array, in Google Apps Script."

 

[Editor: Also a nice example of how to layout Google Sites for Apps Script examples]

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

Collaborative Tools Project: 5.0 Building a Booking System With Google Apps Script by Tom Smith

Collaborative Tools Project: 5.0 Building a Booking System With Google Apps Script by Tom Smith | Google Apps Script | Scoop.it

"Latest update on Building a Booking System With Google Apps Script"

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

Feed+ Chrome Web Store/Apps Script that uses Apps Script to create RSS feed from Google+ by Eric Koleda

Feed+ Chrome Web Store/Apps Script that uses Apps Script to create RSS feed from Google+ by Eric Koleda | Google Apps Script | Scoop.it

"a new Apps Script web app to the Chrome Web Store! This sample app allows you to create an RSS feed of Google+ activities, and utilizes the HtmlService, ScriptDb, and the ContentService. I'll be publishing a more in depth look at the code in the coming weeks, but for now install it, use it, and let me know what you think!"

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

YOKOFAKUN: Translating a DNA sequence in Google Spreadsheet using #GoogleAppScript

YOKOFAKUN: Translating a DNA sequence in Google Spreadsheet using #GoogleAppScript | Google Apps Script | Scoop.it
more...
No comment yet.
Rescooped by Martin Hawksey from desktop liberation
Scoop.it!

Proxy jsonp - How to use Google Apps Script to avoid same origin json problems

Proxy jsonp - How to use Google Apps Script to avoid same origin json problems | Google Apps Script | Scoop.it

If you are reading this, I guess you are familiar with this error message "XMLHttpRequest cannot load somedata.json. Origin null is not allowed by Access-Control-Allow-Origin."

This is of course the same origin policy that prevents you being able to access jSon data that is stored on a different domain than your javaScript Code. This is really annoying if you are trying to use publicly hosted data, but there are ways round it.

 

Here's how to use Google Apps Script as a Proxy for all your jsonp needs.


Via brucemcpherson
more...
Suggested by wterral
Scoop.it!

Teacher Mini-Observation Tracking System using Google Forms and Google Apps Scripts by Andrew Stillman

Teacher Mini-Observation Tracking System using Google Forms and Google Apps Scripts by Andrew Stillman | Google Apps Script | Scoop.it

Problem

"How can overburdened school administrators manage their workflow to enable short mini-observations aligned to a teacher effectiveness framework like Danielson without getting locked into expensive, proprietary software?"

 

Solution

"This well thought-out template, created by a collaboration between a highly successful NYCDOE principal and an Apps Script developer, makes data entry a snap, helps administrators prioritize observations, and supports communications with teachers."

 

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

Storing and serving up images from scriptDB with Google Content Service, jSonP and jQuery

Continuing the theme of using Google Apps Script Content service and scriptDB for lots of things, today's post cover a few tricky topics.

- How to convert an image to a blob so it can be stored in scriptDB.
- How to use the content service as a server so that we can serve up that image to some request
- How to respond to a jSonP request from Google Content service to get over cross domain request problems
- How to convert that back into an image in jQuery


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

Word Cloud Creator - Google Script Examples by Romain Vialard

Word Cloud Creator - Google Script Examples by Romain Vialard | Google Apps Script | Scoop.it

"This library provides one single method to create an HTML Word Cloud from a text input. You can also use this library outside of Apps Script: This Word Cloud Creator is available as a REST API and a Web Application." 

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

Using Google Apps Script as a wrapper for multiple APIs by Bruce Mcpherson

"Lately I've been posting about the Google Apps Script Content Service and how to use it as a 'serverless' Rest API service. In addition, I covered how to use the ScriptDB as a secure repository for oAuth credentials, and using the Content Service as a proxy for other APIs that need authentication.

 

Another thing I've been playing around with in recent posts is mashing up multiple APIs, for example doing some geocoding then passing the result of that off to another API.

 

So where are am I going with all these threads? Content Service, acting as a pseudo server, allows us to either combine, or preprocess API calls. That means that we can create a "completely new REST API" by combining multiple APIs, doing the necessary preprocessing and translations in Google Apps Script."

more...
No comment yet.
Suggested by Jacob Jan Tuinstra
Scoop.it!

Building a table chart with Google Apps Script- Jacob Jan Tuinstra

Building a table chart with Google Apps Script- Jacob Jan Tuinstra | Google Apps Script | Scoop.it
This script uses the tableChart method, made available via the dashboard possibilities...
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Collaborative Tools Project: The Day The Security Guy Dropped By <Google Apps Script Security By Tom Smith

Collaborative Tools Project: The Day The Security Guy Dropped By <Google Apps Script Security By Tom Smith | Google Apps Script | Scoop.it

"It's always a pleasure when Arthur the online security guy at York drops by for a cup of tea. Today he pointed out, kind of him to bother really, that....

 

When you run an AppsScript in a Google Spreadsheet, it is run by the ActiveUser i.e the person that is logged in and working with the spreadsheet. In order to run the AppsScript, which edits the spreadsheet, you need Edit permission on that spreadsheet.

 

Stay with me.

 

Because you've got Edit permission on the spreadsheet, the container for the AppsScript, you've also got Edit permission on the AppsScript. That means, that you ( the ActiveUser ) can edit the script to say... get a copy of all my Documents ( assignments etc ) and upload them to a homework cheating site over here... and do it from your actual email address. It could send rude messages from you, the ActiveUser."

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

Expand your reach with web apps - Google Apps Developer Blog

"Apps Script developers that wished to share their work with a larger audience have traditionally turned to the Script Gallery, which allows other users to copy and install the script into their own spreadsheets. While appropriate for custom functions and spreadsheet extensions, it didn't fit well when distributing more complex functionality and apps.


In this blog post we'll be highlighting a newer way to distribute your scripts: deploying them as a web app and publishing them to the Chrome Web Store"

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

Converting blog post urls into MS Word documents using Google Apps Script #oerri JISC CETIS MASHe

Converting blog post urls into MS Word documents using Google Apps Script #oerri JISC CETIS MASHe | Google Apps Script | Scoop.it
Outlining some Google Apps Script code I've written that takes some blog post urls and makes a downloadable html/.doc report...
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

5 Useful Web Apps Built with Google Apps Script - Google Apps Developer Blog

"At Google I/O in June, we launched two new features that made it easier to build and distribute web apps with Google Apps Script. First, we added the ability to deploy web apps that run as the user. Second, we added simple integration for publishing web apps that you’ve built with Apps Script to the Chrome Web Store.


Recently we’ve come across some new and useful web apps that developers have built using Apps Script and published in the Chrome Web Store. In this blog post, we’d like to highlight a few of those."

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

Super Simple Website Checker - Uptime checker app coded in Google Apps Script by Jan Kleinert

Super Simple Website Checker - Uptime checker app coded in Google Apps Script by Jan Kleinert | Google Apps Script | Scoop.it

"Super Simple Website Checker was built using Google Apps Script and demonstrates the usage of HtmlService, ScriptDb, triggers, and UrlFetch. You can view the source code for the web app here: https://script.google.com/d/1ZA2u-HUSHx_5O9YXIKQLirrvlzXXzuvx4373G8DRUgNyGPmeUxGCIlh8/edit

 

Super Simple Website Checker is a sample app that allows you to monitor the uptime, or status, of websites. For each website you choose to monitor, the app will check the status of those websites every 15 minutes. You can view the status in the app itself, and for any websites that are not up (that is, not returning an HTTP 200 OK status), you'll get an email update to inform you of the status for those failing websites. "

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

[Failed] Embedding live data from Google Spreadsheet with Apps Script ContentService in PowerPoint using oomfo

[Failed] Embedding live data from Google Spreadsheet with Apps Script ContentService in PowerPoint using oomfo | Google Apps Script | Scoop.it
I came, I saw, I failed. This was a potentially promising hack that didn’t work out. Hopefully you’ll get as much benefit from failure, as from success.
more...
No comment yet.