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
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."
“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."
"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"
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!"
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]
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.
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.
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.