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

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!

Parse RSS Feeds with Google Apps Script

“This snippet explains how you can read and parse RSS feeds with Google Apps Script. The script reads the feed using URLFetchApp, translates the RSS Feed and then serves it as an RSS feed using the ContentService (the mime type is set to RSS). Also, the feed content is cached for an hour to reduce the number of URL fetch requests."
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Excel Liberation.: awarding badges - Google Apps Script integration with Persona and Mozilla Openbadges

Excel Liberation.: awarding badges - Google Apps Script integration with Persona and Mozilla Openbadges | Google Apps Script | Scoop.it
"awarding Mozilla Open Badges through a complete badge environment that handles questions, marking, badge assertion, persona authentication and Mozilla backpack awards. I introduced this in a previous post, but now that I've added the last stage of Persona and Mozilla integration, you can actually move these badges into your openbadges backpack"
more...
No comment yet.
Suggested by Jacob Jan Tuinstra
Scoop.it!

Contacts by Group using Google Apps Script by Jacob Jan Tuinstra

This GAS snippet will enable you to get an overview of the contacts you have, based on the group you select.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Archive Gmail messages to Google Drive folders | Jellybend

Archive Gmail messages to Google Drive folders | Jellybend | Google Apps Script | Scoop.it
By using this script you can archive Gmail messages to Google Drive including message attachments.
more...
No comment yet.
Rescooped by Martin Hawksey from desktop liberation
Scoop.it!

Excel Liberation.: Playing around with awarding badges on sites

Excel Liberation.: Playing around with awarding badges on sites | Google Apps Script | Scoop.it

Via brucemcpherson
Martin Hawksey's insight:

Wonderful example of Google Apps Script ScriptDb Service

more...
brucemcpherson's curator insight, December 20, 2012 1:56 PM

I've been looking at the Mozilla Open Badges initiative lately, as a way to improve engagement with a particular site or Blog. My idea is that you could assign a set of earnable badges to a particular page of a site, perhaps different ones on different pages, and present the opportunity to earn one by answering a few questions - using the Open badges infrastructure to store the badges earned. Here's the beginnings of a page specific badge earning widget with quiz data served up by google apps script.

Scooped by Martin Hawksey
Scoop.it!

Create RSS feeds from Google Plus activities using Google Apps Script (app and code)

Create RSS feeds from Google Plus activities using Google Apps Script (app and code) | Google Apps Script | Scoop.it
Eric Koleda "created using Apps Script called Feed+ (http://goo.gl/p1F0W), which allows you to create RSS feeds from your Google Plus activities" Eric has "finally got around to cleaning up the source code and I am now ready to share it with the world!"
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Romain Vialard - Google+ Save emails as EML Files with Google Apps Script

Romain Vialard - Google+ Save emails as EML Files with Google Apps Script | Google Apps Script | Scoop.it
Did you know how easy it is to save emails as EML Files with Apps Script ?
Useful for people who used to store emails in shared folders. 
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Apps Script lets you build powerful HTTP APIs

Tips on creating, storing and serving JSON/JSONP for your website applications using Google Apps Script
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

[Video] Adding voice and SMS to Google Apps using Twilio and Apps Script — Google Developers

[Video] Adding voice and SMS to Google Apps using Twilio and Apps Script — Google Developers | Google Apps Script | Scoop.it

Integrating SMS and phone calls with Google Apps via Twilio, a voice and SMS provider. 

 

via  Eric Koleda

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.
Scooped by Martin Hawksey
Scoop.it!

Analysing WordPress post velocity and momentum stats with Google Sheets (Spreadsheet)

Like other wordpress.com and self-hosted wordpress blogs using Jetpack I got my annual report. This left some questions about the posts made later in the year that hadn't had time to collect views so I've created a Google Spreadsheet template using Google Apps Script to query the WordPress Stats API to reveals some more answers.

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

Tutorial: Getting to Know the Maps Service - Google Apps Script — Google Developers

Tutorial: Getting to Know the Maps Service - Google Apps Script — Google Developers | Google Apps Script | Scoop.it
"Goal This tutorial shows how use and combine the features of the Maps Service."
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Google Apps Developer Blog: Kicking Apps and Making Names

Google Apps Developer Blog: Kicking Apps and Making Names | Google Apps Script | Scoop.it
Once, instead of manually naming hundreds of towns in a (fictitious) foreign country, I weaseled my way out of creativity by writing a ridiculous set of custom spreadsheet functions.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Google Apps Developer Blog: Managing Projects with Gantt Charts using Google Apps Script

Google Apps Developer Blog: Managing Projects with Gantt Charts using Google Apps Script | Google Apps Script | Scoop.it
A common tool in project management circles is the Gantt chart: a schedule of the tasks in the project and how they relate to each other over time.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Delete Attachments from Gmail without Deleting the Email via Google Docs

Delete Attachments from Gmail without Deleting the Email via Google Docs | Google Apps Script | Scoop.it
Learn how to delete only attachments from Gmail messages without deleting emails using Google Docs sans the need of desktop clients and reclaim lost space.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Google Apps Developer Blog: The Hottest Script in Hollywood (Google Apps Script)

Google Apps Developer Blog: The Hottest Script in Hollywood (Google Apps Script) | Google Apps Script | Scoop.it
In just a few hours at the recent Apps Script hackathon in Los Angeles, we saw attendees build everything from website monitoring to room booking to financial tracking apps.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Sergii Kauk - Google+ ScriptDb viewer for Google Apps Script

Sergii Kauk - Google+ ScriptDb viewer for Google Apps Script | Google Apps Script | Scoop.it
"I needed a quick way to inspect ScriptDb contents for a recent project so I did a viewer which some of you might find useful too."
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Google Apps Developer Blog: AdWords Analysis in Google Apps Script

Google Apps Developer Blog: AdWords Analysis in Google Apps Script | Google Apps Script | Scoop.it
The integration between Google Analytics and Apps Script has opened up lots of opportunities for me to make life easier through automation. In a recent blog post on my agency's website, I outlined how an automated report can quickly “heatmap” conversion rate by time and day. The aim of the report is to provide actionable analysis to inform decisions on day-part bidding and budget strategies.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Getting Creative with Big Data and Google Apps – Big Data Week 22-28 April – connecting local and global data communities

Getting Creative with Big Data and Google Apps – Big Data Week 22-28 April – connecting local and global data communities | Google Apps Script | Scoop.it
I was recently asked to write a guest post for Big Data Week on using Google Apps as an interface for Big Data. For the post I decided to revisit an old recipe which uses Google Sheets (Spreadsheets) and Google Apps Script to interface the Twitter and Google Analytics API. One of the results is the bubble graph shown which shows who has been tweeting my blog posts, how many visits their tweet generated, the number of retweets and how many followers the person has. You can read more about his this was done and get a copy of the template in the post.
more...
No comment yet.