Google Apps Script
Follow
Find
63.8K views | +31 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...
Suggested by Arun
Scoop.it!

Automatically Mark Old Unread Emails in Your Gmail as Read.

Automatically Mark Old Unread Emails in Your Gmail as Read. | Google Apps Script | Scoop.it
Fed up with unread emails piling up your Gmail inbox? Automatically nold emails as read using this simple Google script.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Using the Instructure Canvas API with Google Apps Script to extract discussion threads

Using the Instructure Canvas API with Google Apps Script to extract discussion threads | Google Apps Script | Scoop.it

This post contains details of how the Canvas API can be queried with Google Apps Script and the data entered in a Google Spreadsheet. In this particular example I go on to explore the data using Social Network Analysis techniques, but the basic framework may be useful for other projects

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

Seer SEO Toolbox by: Chris Le (@iamchrisle) and Seer Interactive (@SEERinteractive) Google Apps Script

Seer SEO Toolbox by: Chris Le (@iamchrisle) and Seer Interactive (@SEERinteractive) Google Apps Script | Google Apps Script | Scoop.it

An all-in-one toolbox made for SEOs.

Martin Hawksey's insight:

Impressive amount of Apps Script in this linking a number of 3rd party services, however, minifying code and storing Google account username and password in a cell makes this a non-starter for me

more...
Scooped by Martin Hawksey
Scoop.it!

Crowdsourcing Localization with Google Apps Script - (Locking Sheets to prevent overwrites)

Crowdsourcing Localization with Google Apps Script - (Locking Sheets to prevent overwrites) | Google Apps Script | Scoop.it
With just a couple days’ effort in Google Apps Script, we created a complete application for crowd-sourced localization.
Martin Hawksey's insight:

Nice example of the Lock Service which is used when a submit event is fired to prevent two people editing the same cell

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

gClassFolders v2 creates class folders for students and teachers using Google Apps Script

gClassFolders v2 creates class folders for students and teachers using Google Apps Script | Google Apps Script | Scoop.it

gClassFolders Version 2 was released on 2/13/13 and contains the following new features:

* Ability to run in "Single Teacher Mode" or "School Mode" - school mode anticipates use over multiple semesters and at the scale of many classrooms.

 

* Ability to add students and classes over time without recreating all folders. 

 

* Bulk operations like "Remove from class", "Add teacher," "Add school aide," "Move to another class," and "Archive course" 

 

* Internationalized interface runs in over 70 languages via Google Translate API.

 

* Plugs into gClassHub, a gallery of tools that allows any teacher running gClassFolders to instantly launch spreadsheets containing useful scripts like Doctopus, autoCrat progress reports, etc. PRE-POPULATED with their student roster and student assignment folder IDs!

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

Collaborative Tools Project: Using Google Spreadsheets To Improve Student Accommodation

Collaborative Tools Project: Using Google Spreadsheets To Improve Student Accommodation | Google Apps Script | Scoop.it
Nice example highlighted by Tom Smith at the University of York of how someone with basic skills can dramatically improve workflow with a bit of Google Sheets and Apps Script
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Trevor Iampen got tired of the sites viewer in Google Sites, so I built his own using Apps Script

"I got tired of the sites viewer in Google Apps, so I built one for our school district and for public use as a web service. Just type in your Domain and GO"

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

A Free Utility for Project Scheduling and Resource Allocation using Google Spreadsheets | Zyxware Technologies

A Free Utility for Project Scheduling and Resource Allocation using Google Spreadsheets | Zyxware Technologies | Google Apps Script | Scoop.it

"Two important aspects about managing multiple projects with multiple teams are scheduling of the projects & milestones and allocation of resources to these projects. Over the past few years we have been using a simple Google Spreadsheet based utility which we had developed in-house to schedule projects and to allocate resources for projects. We had earlier released this as Free Software under a GPL license and made this available as free template and over 1000 users are currently using this tool.

 

The utility is available as a free Google Spreadsheet Template"

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

Jellybend.com - Google Apps Script help and support (and loads of script examples)

Jellybend.com - Google Apps Script help and support (and loads of script examples) | Google Apps Script | Scoop.it
Jellybend.com provides Google Apps Scripts help and support to automate tasks across Google products and third party services.
Martin Hawksey's insight:

I've been struggling to keep up to date with the examples Marcello Scacchetti and the other folks at Jellybend have been up to. Check their blog for examples on creating custom forms, sales tracking, merging Google Documents, syncing contacts and more

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

Getting ONCourse Data Flowing into Google Spreadsheets

Very useful demonstration of how course data exposed to a API can be pulled into a Google Sheet allowing further manipulation/exploration by using Apps Script to create some custom helper functions.  

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

Keep your Twitter Archive fresh on Google Drive using a bit of Google Apps Script

Keep your Twitter Archive fresh on Google Drive using a bit of Google Apps Script | Google Apps Script | Scoop.it
Looking for a way to keep my Looking for a way to keep my Twitter Archive fresh I stumbled on this method for reading/writting/hosting files on Google Drive using Google Apps Script
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Collaborative Tools Project: An Alternative To Google Calendar's Appointment Slots made using Google Apps Script

Collaborative Tools Project: An Alternative To Google Calendar's Appointment Slots made using Google Apps Script | Google Apps Script | Scoop.it

"

You might not know but Google are dropping the Appointment Slots feature from Google Calendar. The academic community has been pretty miffed about this decision because it's one of the features they've really taken to their hearts and were actively using. Appointment Slots are a great way of making any number of tutorial slots available for tutorials and letting students pick which times suit them. Google responded to the academic outcry with a list of alternatives. This list included paid for services with no clear pricing model for enterprise, downloadable open source software and, rather desperately, a few web2.0 tools that weren't even relevant. Few of these tools integrated with Google Calendars or Contacts, none would have worked with our log ins, and of course, none would be embedded in your Google Calendar making it easy to create overlapping or clashing appointments. So, I wondered how useful a tool I could create using Apps Script. Of course I couldn't embed it Google Calendar but it could work with our York single sign-on, and add details to Google Calendar. The Apps Script environment is limited in many ways - making it difficult to create an elegant solution, but its integration abilities might make it "good enough" for booking tutorial slots."
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Google Apps Developer Blog: Apps Script helps name Pluto's new moons

Google Apps Developer Blog: Apps Script helps name Pluto's new moons | Google Apps Script | Scoop.it
In 2011 and 2012, while studying the region around Pluto with the Hubble Space Telescope, I discovered the dwarf planet’s fourth and fifth known moons. I soon found my inbox stuffed with hundreds of naming suggestions.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

How to Write a Twitter Bot in 5 Minutes (using Google Apps Script)

How to Write a Twitter Bot in 5 Minutes (using Google Apps Script) | Google Apps Script | Scoop.it
This step-by-step tutorial explains how you can create your own Twitter bot using Google Scripts and the new Twitter API. The bot is hosted on the Google cloud.
more...
No comment yet.
Suggested by Shunmugha Sundaram
Scoop.it!

Get Read Receipt Notification for your Emails in Gmail with Google Docs

Get Read Receipt Notification for your Emails in Gmail with Google Docs | Google Apps Script | Scoop.it
Learn how to use Google Docs to get read receipt alerts when your Email has been read in Gmail. Available to Non-Google Apps Account holders too.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Twitter Archiving Google Spreadsheet TAGS v5 (Google Apps Script)

For a couple of years I've been sharing a Google Sheet template for archiving searches from Twitter. In September 2012 Twitter announced the release of a new version of their API (the spreadsheet u...
Martin Hawksey's insight:

Latest iteration of my Google Sheet template for storing Twitter search data (this version uses version 1.1 of the Twitter API meaning it should keep working beyond March)

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

Monitor your Website’s Uptime with Google Docs

Monitor your Website’s Uptime with Google Docs | Google Apps Script | Scoop.it
Learn how to use Google Docs as a free website monitoring tool and receive instant email and SMS text alerts when your website goes down.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Gasitter Simple message board using Google Drive Host Page and ContentService of Google Apps Script

What is this?

This is the simple message board service. It's built by only Google Technology , Google Drive and Google Apps Script.

 

How to created?

Static files (html , js , image , css) is deployed on Google Drive. All APIs are built by ContentService of Google Apps Script.

Martin Hawksey's insight:

Great demonstrations from keisuke oohashi of the power and possibilities of combining hosted Google Drive with Google Apps Script

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

Collaborative Tools Project: Using Google Spreadsheets to Record Chemistry Experiment Marks

Collaborative Tools Project: Using Google Spreadsheets to Record Chemistry Experiment Marks | Google Apps Script | Scoop.it
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Four Ways You Can Benefit By Using AdWords Google Apps Scripts

Four Ways You Can Benefit By Using AdWords Google Apps Scripts | Google Apps Script | Scoop.it
The best kept secret for saving time and improving results in AdWords may very well be AdWords Scripts, a lightweight automation tool that is easier to use than the API but more powerful than the standard interface and the AdWords Editor.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Get a Reminder to Follow-up your Starred E-mails in Gmail

Get a Reminder to Follow-up your Starred E-mails in Gmail | Google Apps Script | Scoop.it
You remember important message in Gmail by adding a star but, with time, that list of starred messages may have become too big. Get a reminder to follow-up.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

ObjDB: storing data with Google Apps Script - HarryOnline

ObjDB: storing data with Google Apps Script - HarryOnline | Google Apps Script | Scoop.it
A powerful library for Google Apps Script to easily work with data stored in spreadsheets and databases
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

[Event] St. Hacktrick's Day | Hacking Google Apps Scripts for Educators

[Event] St. Hacktrick's Day | Hacking Google Apps Scripts for Educators | Google Apps Script | Scoop.it

"On Saturday March 16, 2013, K-12 teachers will join forces with teams of computer science students from the NY/NJ area to (compete for glory and prizes and) develop free, lightweight tools for education in Google’s powerful javascript-based automation language - Apps Script. Come hack with us."

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

Bjorn Behrendt's gClassFolders for creating folders for students in Google Drive get's enhanced by Apps Script Community

Bjorn Behrendt's gClassFolders for creating folders for students in Google Drive get's enhanced by Apps Script Community | Google Apps Script | Scoop.it

Bjorn Behrendt recently shared gClassFolders which automatically creates folders for your students in Google Docs. In the comments of this Google+ post you'll see Andrew Stillman has forked the code to include Romain Vialard's DriveApp library to handle ownership transfer. 

[Great to see the Apps Community sharing and building like this]

more...
No comment yet.