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

Managing Libraries with Google Apps Script

"At last we can now create a library of useful stuff in GAS and access it (or share it) from other sheets. Those of you that have seen this blog or follow the parent web site, may have seen some of the Google Apps Script from Excel migration projects and the associated code." by Bruce Mcpherson

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

Simple Google Apps script to update signatures accross a domain by Juan Canham — Gist

Simple Google Apps script to update signatures accross a domain by Juan Canham

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

RSS Feed Social Share Counting Google Spreadsheet JISC CETIS MASHe

RSS Feed Social Share Counting Google Spreadsheet JISC CETIS MASHe | Google Apps Script | Scoop.it
Sheila MacNeill recently shared Some thoughts on web analytics using our work on analytics in which she mentioned a tool I developed which allows us to quickly get social share and page view counts for out blog, category or project feeds.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Fire Up Your Computer: The 2012 Google Apps Developer Challenge is Here! - Google Apps Developer Blog

Fire Up Your Computer: The 2012 Google Apps Developer Challenge is Here! - Google Apps Developer Blog | Google Apps Script | Scoop.it
Create an innovative application using Google Apps Script, Google Apps, and Drive APIs. If your application is the best within one of the three categories defined below in your region, you could win a prize of $20,000 dollars! Google is also committed to nurturing the next generation of computer scientists as well as encouraging more women to get into coding, so we have special prizes for all-student or all-female teams that make the second round —$1,000 dollars.

The first round of submissions will start on the 24th of August 2012. The categories are

* Enterprise / Small Business Solutions e.g., Accounting, Sales, Workflow, Collaboration
* Social / Personal Productivity / Games / Fun
* Education / Not for Profit / Water / Food & Hunger / Health

Make sure you read all the details about the competition on the Google Apps Developer Challenge page and follow the hashtag #gappschallenge on Google+ for any additional updates.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Dev8Ed: Slides and video of short version of hacking stuff together with Google Spreadsheets JISC CETIS MASHe

Last week was the latest event as part of DevCSI, Dev8Ed. As part of the event I put my name forward for a session on ‘hacking stuff together with Google Spreadsheets’. The session appeared to go down well as I was asked to repeat on the second day got lots of votes for the ‘best of Dev8Ed’. Hacks included using built-in spreadsheet formula and using Google Apps Script

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

Collaborative Tools Project: 4. Building a Booking System with Google Apps ( Code )

"This is the 4th of 3 previous posts about hacking Google Apps to attempt to create a usable Booking System."

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

Google Apps Script equivalents for common VBA functions

"As part of creating a framework for dual maintenance of Google Apps Script and VBA versions of the same application, one of the key things was to produce a set of functions in GAS that would be equivalent to the most common ones in VBA. This includes various objects missing from GAS such as the VBA collection.

 

Here is a selection of the GAS equivalent of common VBA functions. For more like this, take a look at the ramblings site, or contact me on our forum."

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

Using Google Apps Script for a Fast Tracking Student Feedback System

Using Google Apps Script for a Fast Tracking Student Feedback System | Google Apps Script | Scoop.it

In this example Google Apps Script is used to create a custom user interface that can be used in Google Spreadsheets, allowing tutors to enter feedback and grades based on individual assessment criteria pulled from a central data source (another Google Spreadsheet). The system then generates personalised feedback forms (Google Documents) based on the data and distributes them to students.

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

Introducing Versions and Libraries in Apps Script - Google Apps Developer Blog

Introducing Versions and Libraries in Apps Script - Google Apps Developer Blog | Google Apps Script | Scoop.it

"Have you ever written a particular piece of code over and over again? Or used scripts to do something that you thought others might want to do as well? Starting today, you’ll be able to share and reuse those scripts as libraries, right from inside Google Apps Script."

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

How to Turn Twitter into a Gmail Notifier using Google Apps Script

How to Turn Twitter into a Gmail Notifier using Google Apps Script | Google Apps Script | Scoop.it

"I am ready to share a little project around Gmail that I have been working on this weekend. The idea is that you can turn your Twitter Timeline into a Gmail Notifier and get notified (via tweets) as soon as new email messages arrive in your mailbox."

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

Collaborative Tools Project: 2. Building a Booking System With Google AppScript...

Collaborative Tools Project: 2. Building a Booking System With Google AppScript... | Google Apps Script | Scoop.it
"Given the swingeing criteria in my first post, I decided to start by creating the simplest interface I could.

I began with a simple database of Perches in a spreadsheet and then in the Script Editor created a rough GUI with a couple of dropdown menus, and a couple of buttons that I would fill with data from the a mixture of a Perches calendar and this spreadsheet.

I decided not to keep track of bookings in a separate spreadsheet, simply because this felt like it would just be a whole heap of work. I would just use a calendar to store bookings. The guest of each event would decide who's booking it was."
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Google in Education - Google+ - Interested in automating processes within Google Apps Script?

Google in Education - Google+ - Interested in automating processes within Google Apps Script? | Google Apps Script | Scoop.it

Interested in automating processes within Google Apps? Want to learn more about what powers Flubaroo? Then Apps Script is for you! Tune into our Hangout on Air on Wednesday May 23 11am-12pm PT with +Eric Koleda who will be sharing an introduction to Apps Script, use cases, code examples, and holding Q&A.

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

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

"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."
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Introduction to Google Apps Script [Video]

"The Google Apps Script team recently organized a hangout where Eric Koleda gave a nice introduction to Apps Script and then went through build a working application from scratch using App Script inside Google Docs.

 

One of the things I learned in the hangout was that publish a script as a service with parameter and then access it like any other public URL without having to open your Google Sheet (for example, this should be useful for setting up email based polls)."

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

Programmatically Managing Charts in Spreadsheets - Google Apps Developer Blog

Programmatically Managing Charts in Spreadsheets - Google Apps Developer Blog | Google Apps Script | Scoop.it

Details on the ability to programmatically create, modify and delete Spreadsheet charts using Google Apps Script

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

Making Google Reader Mobile sing using your Gmail inbox for personal productivity to save bookmarks and tweet links JISC CETIS MASHe

Making Google Reader Mobile sing using your Gmail inbox for personal productivity to save bookmarks and tweet links JISC CETIS MASHe | Google Apps Script | Scoop.it

In this post I introduce a little Google Apps Script producivity tool that lets me send tweets and save bookmarks to Delicious and Diigo from links sent to your Gmail (developed to improve Google Reader Mobile workflow)

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

Using Google Apps Script to Fast Track Student Feedback: Behind the code JISC CETIS MASHe

Using Google Apps Script to Fast Track Student Feedback: Behind the code JISC CETIS MASHe | Google Apps Script | Scoop.it

Here is some text I prepared for a possible Google Apps Developer blog guest post, which appears to have dropped off the radar. This post is designed to compliment my other post releasing the source code, highlighting some of the coding features possible in the Apps Script service including: self-filing Google Spreadsheet; hybrid UI design (combination of GUI Builder and hardcode); and Document templating.   

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

Nice example of using Google Drive public folders to present your Apps Script Project

Nice example of using Google Drive public folders to present your Apps Script Project | Google Apps Script | Scoop.it

Nice example of using Google Drive public folders to present your Apps Script Project

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

Email Overload! - Google Apps Developer Blog

"Gmail Delay Send is a Google Apps Script that allows you to schedule emails to be delivered on a specified date and time. Using this tool you can ensure your email is sent to its destination at a time when you can capture your recipient’s full attention. For example, receiving an email at 4:59 PM on friday might not receive the same attention as an email received on Monday at 10:00 AM."

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

Rest Library for Google Apps Script

"In previous posts I covered a couple of conversions of Excel VBA projects to Google Apps Script, with particular emphasis on maintaining compatibility between the solutions to allow for dual maintenance. Previous conversions have been a GAS Color Ramp and a GAS roadmapper.

 

This latest migration makes a GAS version of the Excel Rest library, This allows you to store a list of useful REST queries, and execute them to populate a worksheet both in Excel and Google Spreadsheets"

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

Notable Script Libraries - Google Apps Script — Google Developers

"a list of very useful Script Libraries created by our top contributors and other community members."

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

Google Apps Script gets Managed Libraries allowing access to versioned scripts!

Google Apps Script gets Managed Libraries allowing access to versioned scripts! | Google Apps Script | Scoop.it

GoogleScriptExamples.com demonstrate the new experimental feature of Apps Script to Manage Script Libraries. This allows users to access versioned script libraries making deployment as an enterprise solution much easier. This feature is demonstrated using the GPlusApp Library which makes it easier to access Google+ from Google Spreadsheets/Sites.

GoogleScriptExamples.com is maintained by two Google Top Contributors;+James Ferreira author of the book Google Script - Enterprise Application Essentials and +Romain Vialard who wrote the Gmail Meter app.

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

Connecting Apps Script to Google Calendar

by Tom Fitzgerald
Connecting Apps Script to Google Calendar is really easy. In this example I connect to my calendar, get some events and paste them to a spread sheet. Also show how you can have a popup window ask for input and save it to your spread sheet.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Using Google Spreadsheets to dashboard project/course blog feeds using Apps Script

Using Google Spreadsheets to dashboard project/course blog feeds using Apps Script | Google Apps Script | Scoop.it

In this post I’ll show I’ve create a quick dashboard in Google Spreadsheets which takes a list of blog RSS feeds and filters for specific tags/categories. The final result uses the Xml parse, UrlFetch and Cache services in Google Apps Script

more...
No comment yet.
Suggested by t.kenan
Scoop.it!

Dynamic FAQ Section w/ jQuery, YQL & Google Docs | Tutorialzine

Dynamic FAQ Section w/ jQuery, YQL & Google Docs | Tutorialzine | Google Apps Script | Scoop.it
In this tutorial, we are making a dynamic FAQ section. The script, with the help of jQuery & YQL, will pull the contents of a shared spreadsheet in your Google Docs account, and use the data to populate the FAQ section with content.
more...
No comment yet.