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!"
“I kept missing the weekly Apps Script Office Hours, so I wrote a script that will send me an email whenever +Eric Koleda mentions "Office Hours." I've used it the past couple of weeks, and so far, it seems to have worked well."
"My team at GOV.UK was tasked with creating a series of high-level metrics reports which could be sent daily to ministers and senior civil servants of several government departments, with the data customised for each department.
We discovered that an added bonus of pulling data into a Google spreadsheet was that it also allowed us to publish the data to a Google site. This helped us display data to stakeholders without adding lots of users to our Google Analytics account."
"Usually on this blog and the associated site I cover topics to do with getting data in an out of Excel. Lately though, I've been playing around with using Google Apps Script as a proxy and publishing data out of Google Apps Scripts.
I've brought many of those concepts together to create a single publisher to expose your scripts, scriptdb data and other public content in a variety of formats such as standalone web page, a js function that returns the html code for a page, as json data and as jsonp data. I've also included a code prettifier and json beautifier in the code.
The main purpose of this is to be able to publish your code snippets or scriptdb data as dynamic content in iFrames in other web sites, or to get the content as Json data. However, same domain restrictions on iFrames and jSon make this hard to achieve. The js and jsonp options mitigate these issues allowing you to embed source code in a variety of hosts. Here is how it fits together."
"Integration with Google Apps Script: We’re making it quick and easy for businesses using Google Apps to use Cloud SQL. Publish and share data with Google Sheets, add data to Google Sites pages or create simple Google Forms without worrying about hosting or configuring servers."
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.
"Forwarding emails to Evernote to turn them into notes is one of Evernote's awesome features. However, if you want those notes tagged or in a specific notebook, you have to adjust the subject line. A much easier and faster method is to use this Google Apps Script with Gmail."
"There are many tools available to help you manage a task list and Google Apps comes with its own simple Tasks app. But sometimes it is more convenient and collaborative to simply manage your task list in a shared spreadsheet. This spreadsheet can be a simple personal task list or a project-management interface that requires team-wide coordination.
Google Spreadsheets come with a set of notification rules that might come in handy. For example, you can be notified each time someone adds a new task to the list or each time the status of a task is updated. Furthermore, it is very easy add to add basic reminders through Apps Script with just a few lines of code ..."
Color Code+ gives you the ability to reference cells when applying conditional formatting in Google Spreadsheets. It covers most of the basic cases, but there's a link to request additional help and see examples of what you can do.
" In a number of articles I've covered how to use GAS for jsonp, oauth, as a lockbox and various other useful things. There are many threads to pull together in this section, so here's a step by guide to GAS proxying as described in this post."