Google Apps Script
125.4K views | +2 today
Follow
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!

Google doesn't trust students getActiveUser() not available for EDU accounts

Google doesn't trust students getActiveUser() not available for EDU accounts | Google Apps Script | Scoop.it
The Session.getActiveUser() service is currently not available for Google Apps for Education but is if you are a Business user. So Google trusts business users not to scrape fellow employee email addresses but not students.

Details of this issue have been logged (Issue 538). Please vote for this ticket if you would like to see the feature re-enabled.
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Introduction to Google Apps Script with: Split my form entries to individual sheets by username « MASHe

Here’s a recording of a webinar session I did with Dave Foord at A6 Training and Patrick Lander from Loughborough College.

This session came about after Dave directed me to a question Patrick had posted on the Google Docs forum asking how you can ‘automatically create new sheet for each user completing a form’. Rather than just give the answer I thought it would be better to step Dave and Patrick through the solution, giving them a better understanding of how Apps Script works and some basic principals which they might be able to build upon.
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Google Apps Script – Scheduled Tasks Replacement | calmighty (poor mans cron job)

Google Apps Script – Scheduled Tasks Replacement | calmighty (poor mans cron job) | Google Apps Script | Scoop.it
Now, I had heard of Google Apps Script, but I'm not a “real” programmer so I didn't think much of it until I stumbled across a post the other day that made me investigate the API a little further. ...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

App, App and Away: Workshop Handout #open4ed (Intro to Google Apps Script)

App, App and Away: Workshop Handout #open4ed (Intro to Google Apps Script) | Google Apps Script | Scoop.it
This guide was written to support the App, App and Away workshop might be delivered on the 20th May 2011 as part of Open for Education event (unless otherwise stated available under CC-BY-SA). Shortlink: http://bit.ly/appappaway.
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Official Google Enterprise Blog: Google Apps Script opens new ways to deliver workflow solutions for businesses

Official Google Enterprise Blog: Google Apps Script opens new ways to deliver workflow solutions for businesses | Google Apps Script | Scoop.it
Google Sites offers an incredible way to author and distribute content, and we use it extensively both for ourselves and our clients. Therefore it was not surprising that our customers started requesting a content approval workflow in Google Sites. Now with Google Apps Script, we have been able to develop Appogee Content Approval for Google Sites.
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Google Apps Script - Contact Us Form - E-mail - Google Sites & Google Apps Help - steegle.com

Google Apps Script - Contact Us Form - E-mail - Google Sites & Google Apps Help - steegle.com | Google Apps Script | Scoop.it
Google Apps Script - Contact Us Form - E-mail - Google Sites & Google Apps Help - steegle.com http://ff.im/-G7LqC...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Google Apps Script Tutorial: How to create UI using Apps Script

This script is available in Apps Script gallery under the category Miscellaenous.
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Google Apps Script: Grading Made Easy using Apps Script

Google Apps Script: Grading Made Easy using Apps Script | Google Apps Script | Scoop.it
Grading made super-easy using google forms http://j.mp/kLEp8Y...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Gmail and Document Services now available in Apps Script - Google Apps Developer Blog

If you’ve used Google Apps Script before, you’ll know that we have deep integration with many Google Apps & APIs. You can access your Calendar and Contacts, create Google Sites, send email, and lots more. But two integrations were noticeably missing: the Google Docs word processor, and Gmail. A few weeks ago, at Google IO, we announced new Apps Script APIs for these two great products.
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Liquid 9 | Batch Geocoding Addresses Using Google Spreadsheets | Blog

Liquid 9 | Batch Geocoding Addresses Using Google Spreadsheets | Blog | Google Apps Script | Scoop.it
After facing countless frustrations trying to find a way to geocode 300+ addresses to latitude and longitude coordinates for an upcoming project, I decided to investigate scripting Google Spreadsheets to handle the task.
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Coding my own automated web site monitoring with Google Apps Script and a Spreadsheet « Coding in the cloud

Coding my own automated web site monitoring with Google Apps Script and a Spreadsheet « Coding in the cloud | Google Apps Script | Scoop.it
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Autocomplete Email Addresses in Apps Script - Google Apps ...

Autocomplete Email Addresses in Apps Script - Google Apps ... | Google Apps Script | Scoop.it
This time-saving feature can be duplicated when creating Google Apps Script applications. For instance, if you design an application that requires sending emails, you can leverage this auto-complete feature by using a ...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Boy's Nifty Stuff » Archive » Google Apps Script: TTResponds

Boy's Nifty Stuff » Archive » Google Apps Script: TTResponds | Google Apps Script | Scoop.it
A simple Google Apps Script to auto respond to Form submissions
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Fragments: Accessing YouTube Account Data in Google Spreadsheet via OAuth « OUseful.Info, the blog…

If you’re running a Youtube account, how might you collect Insights data for all your videos as spreadsheet entries that can be used in the preparation of reports about your social media effectiveness?

One way might be to go to each video in turn and download the separate CSV data files created for each video. Alternatively, you can grab the data via the YouTube/GData API (http://code.google.com/apis/youtube/2.0/developers_guide_protocol_insight.html).

I haven’t actually got round to getting any data out of my YouTube account and into a Google spreadsheet yet, but I have dome the first step, which is to set up the authentication using OAuth. Here’s the Google Apps script I used…
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Google Apps Script: Lite Staff Directory for Sites or as a Service « MASHe

This script allows a users to search a Google Spreadsheet of contact information, filtering by different parameters and edit their own information personal information. The following video demonstrates the gadget in action, you can also try it published as a service or embedded in a Google Site
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Google Launches New Drag and Drop AppsScript Interface Design Tool - ReadWriteCloud

Google Launches New Drag and Drop AppsScript Interface Design Tool - ReadWriteCloud | Google Apps Script | Scoop.it
Today Google announced a new tool for Apps Script, the scripting language for Google Apps: Apps Script GUI Builder. Apps Script lets admins automate tasks and extend ...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Google Apps Script: Merging with Google Apps Developer Blog

Coming out of Google I/O, Google Apps Script has accelerated its momentum, introducing a lot of cool new features that have been top requests of our community ... To continue this momentum, we’re streamlining our communications by merging this blog into the Google Apps Developer Blog. Integrating the two will help strengthen the community by reaching more of you, and it better reflects that Apps Script is a vital part of Google Apps.
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

How it was made: eAssessment Scotland Google Spreadsheet booking form with website and Twitter integration

How it was made: eAssessment Scotland Google Spreadsheet booking form with website and Twitter integration | Google Apps Script | Scoop.it
For this year we’ve moved the booking form to Google Spreadsheets (moving to the cloud to avoid the issue of our soon to be mothballed event system), which has been an opportunity to continue to tweak my previous work on Google Spreadsheet based booking systems. For this version I’ve implemented: 3rd party website integration (e.g. hosting the form remotely and in our case wrapping it in a WordPress template); better handling of parallel session selection e.g. quotas for maximum number of delegates; email notification confirming booking details and registration; and Twitter integration with automatic ‘tweet out’ of registrations and adding delegates to a named Twitter List
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

What you can’t do with Gmail and Document Services now available in Apps Script « MASHe

What you can’t do with Gmail and Document Services now available in Apps Script « MASHe | Google Apps Script | Scoop.it
Google recently announce Gmail and Document Services now available in Apps Script, which wasn’t a huge surprise as they had already announced it at the Google...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Google Apps Scripts for an intuitive interface to organic chemistry Open Notebooks

Google Apps Scripts for an intuitive interface to organic chemistry Open Notebooks | Google Apps Script | Scoop.it
Rich Apodaca recently demonstrated how Google Apps Scripts can be added to Google Spreadsheets to enable simple calling of web services for chemistry applications (gChem). Although we have been using web service calls from within a ...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

I/O BootCamp 2011: Don't Hate, Automate Using Google Apps Script

Speakers: Saurabh Gupta Google Apps Script is a JavaScript cloud scripting language that provides easy ways to automate tasks across Google products and thir...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Visual UI Editor For Google Apps Script « OUseful.Info, the blog…

Visual UI Editor For Google Apps Script « OUseful.Info, the blog… | Google Apps Script | Scoop.it
I don't know what the Google Apps Script team drink, but going by the rate of evolution I imagine it's highly caffeinated. I haven't seen this level of open product development since Google Wave (oops, don't mention Wave ...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Ported: Tony Hirst's Using Protovis to Visualise Twitter ...

Ported: Tony Hirst's Using Protovis to Visualise Twitter ... | Google Apps Script | Scoop.it
Tony and I had discussed collecting the data in a Google Spreadsheet using one of my many Twitter/Spreadsheet mashups and then draw the network visualization from the data. I thought I would go one step further not only ...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Turning Google Spreadsheets into a personal or group bookmarking service « MASHe

Turning Google Spreadsheets into a personal or group bookmarking service « MASHe | Google Apps Script | Scoop.it
Recently Yahoo announced that it was going discontinue/sell their Delicious bookmarking service.
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

TwitSheets - Spreadsheets...

TwitSheets - Spreadsheets... | Google Apps Script | Scoop.it
A bunch of useful spreadsheets for use by anyone. No claims of perfection here, not even any guarantees of correctness - just a good place to find spreadsheets which might be useful for various purposes.
No comment yet.