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

Automated Access to Google Analytics Data in Google Spreadsheets - Google Analytics — Google Developers

Automated Access to Google Analytics Data in Google Spreadsheets - Google Analytics — Google Developers | Google Apps Script | Scoop.it
This tutorial describes how to access the Management and Core Reporting APIs inside a Google Spreadsheet using Apps Script.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

The Normal Force: The Calendrator v1 (using Apps Script to display course calendar) by Eric Eslinger

The Normal Force: The Calendrator v1 (using Apps Script to display course calendar) by Eric Eslinger | Google Apps Script | Scoop.it

"If you're creating a course website, you might want to display a calendar of events for that course. A natural consideration is Google Calendar for the actual calendar. This works fine, and has interesting benefits (easy to move events from one day to another) over the traditional "make a big table in MS Word and type dates in manually".

 

The bummer is, it'd be nice to display the calendar showing things to do for each day in a simple layout. If you add details to the calendar entry, the data is there, but doesn't display in the default views for embedding in your site.

 

Enter the calendrator. It pulls data from your calendar and formats it in a useful way. To create the calendrator, go to your Google Sites page where you want to embed your calendar. Go to Manage Site - > Apps Scripts and create a new script."

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

gotJS: Use Any Editor with Google Apps Script by syncing scripts By Dan Gottlieb

"There's excellent syncing built into Google Drive makes it easy to create javascript files on your computer and run them within Google Apps. This approach means you can use your favorite text editor rather then the online code editor, but still easily test in Google Apps Script without needing to copy and paste repeatedly."

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

Computational Contemplations: Google Apps Script to export course topics to Calendar By Lee Stemkoski

"Time to prep for the Fall semester classes. I typically create a spreadsheet of topics on Google Docs Drive, and for student-ease-of-use I would like to use that data in a Google Calendar. To get these two apps talking, I'm learning Google Apps Script. It is simple to complete https://developers.google.com/apps-script/your_first_script in a matter of minutes, the syntax is quite readable and easy to understand..."

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

Google Apps Script Web Store App: Web Store App Crowd Curated

Google Apps Script Web Store App: Web Store App Crowd Curated | Google Apps Script | Scoop.it
"This app is an experiment in using crowd-sourcing methodology to surface hidden gems from the blogosphere. Topics covered include Collective Intelligence, Information Architecture, Cloud Computing, Big Data, Social Computing, Enterprise 2.0, Symbiotic Intelligence and more."
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!

The Normal Force: The Calendrator v2 by Eric Eslinger

The Normal Force: The Calendrator v2 by Eric Eslinger | Google Apps Script | Scoop.it

"My last post got me to thinking- if I'm going to write a slight improvement to the google calendar's view interface, what other things would I like to add?

 

The first thing I'd add would be HTML markup in the description portion of the event. To see what I'm talking about, go make a calendar event, edit it and add to the description. This is a good place to add (say) an assignment for that particular day, but you'll quickly see that you're limited to plain text in this interface. That's highly unsatisfying."

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

HAPPY BIRTHDAY Google Apps Script: 3 years ago Apps Script was launched to Premier and Education users

HAPPY BIRTHDAY Google Apps Script: 3 years ago Apps Script was launched to Premier and Education users | Google Apps Script | Scoop.it

3 years ago (August 19 2009) Google Apps Script was made available to all Google Apps Premier and Education Edition users. HAPPY BIRTHDAY APPS SCRIPT! :)

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

UK postcode geocoding API: The Daily REST library entry for Excel and GAScript

UK postcode geocoding API: The Daily REST library entry for Excel and GAScript | Google Apps Script | Scoop.it

Geocode and get administrative details and geoHash link from a UK postcode directly into an Excel or Google Spreadsheet
Following on from the Yahoo GeoCode entry here's another geoCoder - this time using UK post code as input, and providing various UK specific administrative district information. As usual it is implemented as a rest-library member. This a data query API, populating columns in a row in a spreadsheet based on a variable column in the data. You just name the columns to match any data you want to retrieve and go. Here's an example geocoding various random postcodes


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

Google Apps Script Web Store App: mLookup

Google Apps Script Web Store App: mLookup | Google Apps Script | Scoop.it

"This fairly simple Google Apps Script allows any Google Apps Business customer to provide a simple way for the users to query their groups and discover members/managers/owners of each group"

more...
No comment yet.
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.