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

gotJS: UiBot - Google Apps Script User Interface Library - build UI from JSON objects by Dan Gottlieb

gotJS: UiBot - Google Apps Script User Interface Library - build UI from JSON objects by Dan Gottlieb | Google Apps Script | Scoop.it

"I've been playing around with Google Apps Script lately, and I thought I'd share a small class I wrote to make building user interfaces with the UI Service a little more pleasant. With this library, you can specify an interface through a simple declarative JSON syntax, rather then a lot of chained function calls (or the GUI builder). It also includes some helpers to reduce the amount of code needed to build forms." by Dan Gottlieb via Eric Koleda

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

How to create a mail merge using Google Apps Script & Google Forms

Here's my quick guide on creating a simple mail merge using Google Apps Script and Google Forms. Certainly a lot of use-cases for this one! Just imagine what...
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Create a data driven Twitter avatar (using Google Apps Script) | Tutorial | .net magazine by Matthew Knight

Create a data driven Twitter avatar (using Google Apps Script) | Tutorial | .net magazine by Matthew Knight | Google Apps Script | Scoop.it
Matthew Knight explains why you don’t need to be a genius to make simple digital toys – just build upon the genius of others and make use of Google Apps Script...

In this tutorial Matthew explains how you can use Apps Script to get your Gmail unread count before passing the result to a php server to update your avatar (I reckon you could do the whole thing in apps script)
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

SpreadsheetDB Google Apps Script Library by Keisuke Oohashi

SpreadsheetDB Google Apps Script Library by Keisuke Oohashi | Google Apps Script | Scoop.it
What's SpreadsheetDB? This Script can be Spreadsheet as a DB for Google Apps Script. It can do select/insert/update/delete Row(s) on Spreadsheet by query. It can full text query to Spreadsheet rows.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Google Analytics now accessible as one of the Google Apps Services - Analytics Service

Google Analytics now accessible as one of the Google Apps Services. To use you need to enable via Google API console
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Introducing Dashboards in Google Apps Script - Google Apps Developer Blog

Introducing Dashboards in Google Apps Script - Google Apps Developer Blog | Google Apps Script | Scoop.it

"Charts are a great way to visualize information. They let you arrange data in meaningful ways, allow you to tell a story, and can really catch the reader's eye. But when dealing with large datasets, visualizing all the data at once can be somewhere between a tough to impossible mission. You usually need to filter the data and concentrate on a specific part that is of interest, and then when you want to see a different part of the data you'll need to filter it again and refresh the view. That's why we're happy to announce the introduction of dashboards in Apps Script, which allow you to compose multiple charts and filters into a single experience!"

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

Parse Apps Script - Utilities for using Parse.com with Google Apps Script By Alan deLevie @adelevie

Utilities for using Parse with Google Apps Script.

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

Page Rank REST API from Excel and Google Apps Script by Bruce Mcpherson

Page Rank REST API from Excel and Google Apps Script by Bruce Mcpherson | Google Apps Script | Scoop.it

"I haven't posted anything on new entries to the rest-excel-gas library for a while. As I mentioned in this post the library itself is available as a rest query. There have been quite a number of new APIs added lately through forum requests, but here is a nice one - populate a worksheet with the Google Page Ranks of a list of given domains. (you just enter the domains you want, the library call fills in the rest)"

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

How to Forward Multiple Emails at Once in Gmail using Google Docs

How to Forward Multiple Emails at Once in Gmail using Google Docs | Google Apps Script | Scoop.it
Learn how to use Google Docs to forward multiple emails in Gmail at once to any number of recipients without the need of desktop clients.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Share docs between domain users - Apps Script Tutorial by Waqar Ahmad

"Google Apps Administrator have access control privilege for the documents of users in his/her domain. An administrator can share the document of one user to any other user in that domain. This is mostly required when you need to audit the documents of a domain user. Say, Bob's boss want to audit the documents of Bob and does not want to ask Bob to share the documents. In this case, Googe Apps Administrator can help Bob's boss."

Find a vast collection of Google Apps Script (GAS) demos and examples. GAS Tutorial, Google Apps Script Tutorial by Waqar Ahmad...
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Google I/O 2012 Notes: New features in Google Apps Script (NoSQL, HTML/Content publishing and Chrome app publishing) JISC CETIS MASHe

Google I/O 2012 Notes: New features in Google Apps Script (NoSQL, HTML/Content publishing and Chrome app publishing) JISC CETIS MASHe | Google Apps Script | Scoop.it

One of the main questions I get from people interested in using Apps Script is how stable/sustainable the platform is. Given there were three separate sessions on Apps Script at #io12 announcing a number of new features including the launch of script.google.com I’d say for now things are looking very healthy.

 

There were (by my count) four new features of Apps Script announced outlined below, I’m throwing in one more old announcement, which I’ll share my notes on in this post:

 

* Recent announcement Managed Libraries and Versioning – this lets you control a master script which you can maintain and bug fixes, new features can be used by anyone using the library (before if you created a script in a spreadsheet and someone made a copy the script became orphaned so the only way you could receive updates was making a fresh copy or manually replacing the existing code).
* ContentService – lets you publish content generated by App Script which will be interpreted by other web services/tools as atom, rss, json, text or xml
* HTMLService – lets you publish content generated by Apps Script which will be interpreted by other web services/tools as html which can include custom CSS and client-side JavaScript (including importing existing libraries/code like jQuery)
* ScriptDb – a NoSQL style database that lets you store and query data that doesn’t have a fixed schema (doesn’t have a fixed number of values or may have nested data)
* Publish to Chrome Web Store – you can publish Apps Script based applications directly to the Chrome Web Store so that other people may easily install and use.

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

Twitter Bootstrap in Google Apps Script (with source code) via @soundTricker318 #gasja

Twitter Bootstrap in Google Apps Script (with source code) via @soundTricker318 #gasja | Google Apps Script | Scoop.it

Twitter Bootstrap in Google Apps Script (working example with source code)

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

Using Google Apps ScriptDB and the ContentService as an REST server - Bruce Mcpherson

"That's right - you can serve up data from your Google Apps Script directly. In my post the other day, I showed how to use the Google Apps ScriptDB as a place to store the  Rest-Excel library. Now ideally, you'd want to get that out again by making a simple API call - but we dont have a server. With the new Google Apps Script ContentService, you dont need one."
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

R melt for Google Apps Script and Excel/VBA: reshaping/unpivoting data By Bruce Mcpherson

R melt for Google Apps Script and Excel/VBA: reshaping/unpivoting data By Bruce Mcpherson | Google Apps Script | Scoop.it

"could consider this to be a kind of unpivot - exploding tabulated data back into transactional rows as described by Hadley Wickhams in his implementation of reshape/melt for R."

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

How JISC CETIS dashboard social activity around blog posts using a splash of data science

How JISC CETIS dashboard social activity around blog posts using a splash of data science | Google Apps Script | Scoop.it
Behind the scences look at how we (JISC CETIS) can quickly develop dashboards to monitor activty around blog posts (using Google Spreadsheets of course ;)...
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Google Spreadsheet Template for getting social activity around RSS feeds using Apps Script

Google Spreadsheet Template for getting social activity around RSS feeds using Apps Script | Google Apps Script | Scoop.it
Here's a Google Spreadsheet template I've developed from some leftovers which pulls data together from comment feeds, Twitter and Delicious (with social counts for these plus Facebook, LinkedIn and Google+)...
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Release Notes - Google Apps Script — getThumbnail() method added to the DocsList service's File class

getThumbnail() method added to the DocsList service's File class
more...
No comment yet.
Rescooped by Martin Hawksey from Google in the Classroom - Apps, Sites...
Scoop.it!

Doctopus - Free Google Apps Script to manage student projects

Doctopus - Free Google Apps Script to manage student projects | Google Apps Script | Scoop.it

"How can teachers harness all the awesomeness, ubiquitous access, and collaborative authoring power made possible by Google Docs without creating a document management nightmare?
Solution

Written by an educator for educators, the free doctopus script gives teachers the ability to auto-generate, pre-share, and manage grading and feedback on templated Docs for group and individual projects."


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

Data Shaping in Google Spreadsheet - Generating New Rows from Multiple Values in a Single Column

Data Shaping in Google Spreadsheet - Generating New Rows from Multiple Values in a Single Column | Google Apps Script | Scoop.it
Today Tony Hirst posted Data Shaping in Google Refine – Generating New Rows from Multiple Values in a Single Column. Coincidently I faced a similar problem today working with a Google Spreadsheet so thought I’d share my solution.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Apps Script quick tips: building a stock price spreadsheet by Ikai Lan

Apps Script quick tips: building a stock price spreadsheet by Ikai Lan | Google Apps Script | Scoop.it
"I’ve been using iGoogle less and less over the past few years. A few weeks ago, the team announced that iGoogle would be shutting down in November 2013. It’s not a huge loss to me, though I do check iGoogle several times a day. Why? Stock prices! I’ve been using the Stock Market gadget for years.

As it turns out, the functionality I want is very easy to replicate using Google Spreadsheets and Google Apps Script. I’m thoroughly convinced that the fastest way to wire up different Google services for custom functionality is this product. Google Apps Script provides services to access Google Finance APIs."
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Creating Custom Learning Assessment and Student Feedback Applications with Google Apps Script

Here's a chapter from Cultivating Change in the Academy: 50+ Stories from the Digital Frontlines at the University of Minnesota in 2012 written by Abram Anders. The chapter covers the development of a custom assessment and feedback tool written by Abram and available in the Script Gallery

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

Doodle for your domain using Google Apps Script - Apps Script Tutorial by Waqar Ahmad

Doodle for your domain using Google Apps Script - Apps Script Tutorial by Waqar Ahmad | Google Apps Script | Scoop.it
"I was looking on this post on Google Apps Developer blog, I thought, why not to develop the same functionality using Google Apps Script which will be easy to maintain and run.
So I made a Spreadsheet Application which will does the same for you.
In this application, you just need to write the URL of the doodle and Date for that Doodle logo."

Find a vast collection of Google Apps Script (GAS) demos and examples. GAS Tutorial, Google Apps Script Tutorial by Waqar Ahmad...
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Get the revision history of a resource using DocsList API - Apps Script Tutorial by Waqar Ahmad

To get the revision history of your resource in your Google Docs using Google Apps Script, you can use Google DocsList API with Google oAuth and URLFetch App.

Find a vast collection of Google Apps Script (GAS) demos and examples.GAS Tutorial, Google Apps Script Tutorial by Waqar Ahmad...
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Quarter of Google Apps Script tweets come from Japanese profiles inc @soundTricker318 @kwixilvr @ttyokoyama

Using the search "apps script" OR "Google Apps Script" OR "google script" OR developers.google.com/apps-script/ 'The GAS' has been collecting apps script related tweets since November 2011. Doing a quick analysis filtering profiles tagged with ja language code you can get  a sense of the size of the Google Apps Script community in Japan. So you might want to fire up Google Translate and start following @soundTricker318 @kwixilvr and @ttyokoyama

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

Use Regular Expressions to Find Anything in your Gmail Mailbox with Apps Script - Amit Agarwal

Use Regular Expressions to Find Anything in your Gmail Mailbox with Apps Script - Amit Agarwal | Google Apps Script | Scoop.it

"Gmail offers some very useful search commands to help you quickly find messages that could be buried deep in your mailbox. For instance, a query like from:(John OR David) has:attachment after:2012/01/15 will locate all emails received in the past six month that have attachments and the send is either John or David.

 

The built-in Gmail search is powerful but there are some scenarios where it will not work. For instance, you cannot perform a wildcard search inside Gmail (like apples * red). Or how do you locate all emails that have a phone number mentioned in the message body? It is also not possible to perform case-sensitive searches inside Gmail.

 

You can however do all this in Gmail with the help of regular expressions (or regex)."

more...
No comment yet.