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

Eforcers S.A.: Building a Google Apps Script Web App (polling app), Part 1

Eforcers S.A.: Building a Google Apps Script Web App (polling app), Part 1 | Google Apps Script | Scoop.it
" the Apps Script version of the Django framework reference tutorial: the Polls web app. Doing this will help us understand how to write a complete Web application from the UI to the database.

The poll app is very very simple, it’s like a CRUD hello world. The domain model is made of a Poll class (a question) which have associated many Choices (or possible answers for the poll’s question), the user is presented with the available polls list when he click in one of them is redirected to the poll detail with the different choices as options, the users vote for the best choice and finally the results are presented, number of votes for each one of the choices."
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Google App Script: Scheduling timed triggers JISC CETIS MASHe

Within Google Apps Script you can create basic time-based triggers (poor mans cron) to run functions on specific date/time intervals. Recently on one of my posts someone asked: ‘Is there a way to schedule when the script runs?’. In particular they were interested in running a particular function every 10 minutes for a set period. I did briefly look at scripting time-based triggers, but quickly realised that my original plan to control a number of timed triggers from a central spreadsheet wasn’t possible because the class TriggerBuilder doesn’t allow forSpreadsheet on TimeBased triggers. Instead I came up with this code snippet

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

Google Apps Script quick hack to extract inline images from Gmail — Anonymous Gist

Google Apps Script quick hack to extract inline images from Gmail — Anonymous Gist | Google Apps Script | Scoop.it
Google Apps Script quick hack to extract inline images from Gmail
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Templated Export for Google Spreadsheets using Google Apps Script

Templated Export for Google Spreadsheets using Google Apps Script | Google Apps Script | Scoop.it

Templated Export allows users to reshape and selectively publish data from Google Spreadsheets in custom formats. The tool is powered by Google App Script which allows integration with Google Spreadsheets using existing authenticated access.

 

Example uses include: turning data from a spreadsheet into a RSS feed and publishing data from a spreadsheet in JSON format to be used by other tools/services.

 

Check out the post for installation instructions and demonstration videos 

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!

0x8107D: A free Twitter buffer with Google Apps Scripts

0x8107D: A free Twitter buffer with Google Apps Scripts | Google Apps Script | Scoop.it
" You might know about Buffer, a web service where you can create a stash of tweets which will be posted to your Twitter account at regular intervals. Instead of overwhelming your followers with all the interesting things you have to say, you can configure it such that it will send out a tweet at 9am and 1pm every day (for instance). The only thing you have to worry about is to keep your buffer filled.

However, the buffer size at Buffer is only 10 tweets. If you want more you need to pay (or make your friends sign up as a referral). Because I find $10/mo a bit much for just a buffer, I decided to make my own.

We'll do this with a Google Spreadsheet and a Google Apps Script"
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

[FREE] Receive SMS messages in a Google Spreadsheet for a textwall, voting and more (UK only) JISC CETIS MASHe

[FREE] Receive SMS messages in a Google Spreadsheet for a textwall, voting and more (UK only) JISC CETIS MASHe | Google Apps Script | Scoop.it

Solution for making a free SMS inbox in a Google Spreadsheet using the IntelliSoftware SMS Gateway and 30 liines of Google Apps Script code. This particular example is used to collect votes for a poster competition but there are many other things you could use it for.

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

Automate Google Analytics reporting using Google Apps Script - Google Developers Blog

Automate Google Analytics reporting using Google Apps Script - Google Developers Blog | Google Apps Script | Scoop.it

"Many people have been asking for a simple way to put Google Analytics data into a Google Spreadsheet. Once the data is inside a Google Spreadsheet, users can easily manipulate Google Analytics data, create new visualizations, and build internal dashboards.

 

So today we released a new integration that dramatically reduces the work required to put Google Analytics data into any Apps Script supported product, such as Google Docs, Sites, or Spreadsheets."

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