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."
" Tripit can be configured to automatically browse through all your email looking for travel information. Although I really like their product, I’m not really comfortable letting them dive into my personal email. So for some time I’ve been manually forwarding them all travel confirmations for indexing.
Some time ago a friend of mine told me about Google Apps Script. I have to say that I’m very, very impressed with what Google has pulled of here! From knowing nothing at all to having working code that automated my previously manual GMail workflow just took me an hour!"
* Create a new Spreadsheet in Google Drive * Create 2 tables: one with the customers data, one with the orders * Model your data in the tables so that it can be filtered and correctly maintained * Write a script that will send via email a report of the purchase history of a customer"
“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."
In the builtwith.com api rest library entry for Excel I covered how to get data about a given web site using the builtwith.com API. I went against my usual rule here, by including an api that needs an API Key. Here's how to securely store your API keys in one place, and use them without exposing them in your code.