"At Google I/O in June, we launched two new features that made it easier to build and distribute web apps with Google Apps Script. First, we added the ability to deploy web apps that run as the user. Second, we added simple integration for publishing web apps that you’ve built with Apps Script to the Chrome Web Store.
Recently we’ve come across some new and useful web apps that developers have built using Apps Script and published in the Chrome Web Store. In this blog post, we’d like to highlight a few of those."
Super Simple Website Checker is a sample app that allows you to monitor the uptime, or status, of websites. For each website you choose to monitor, the app will check the status of those websites every 15 minutes. You can view the status in the app itself, and for any websites that are not up (that is, not returning an HTTP 200 OK status), you'll get an email update to inform you of the status for those failing websites. "
Romain Vialard demonstrates that with the recent addition of Apps Script Libraries and Dashboard chart objects it's possible to rapidly develop information panels all within a Google authenticated environment
"the Idea here is that you use your scriptDb (either one linked to a particular workbook, or a shared one you use for centralized to tracking) to record when certain events start and finish using Google Apps Script. Here's an example of logging something that happened, and how long it took."
" You might know about Buffer, a web service where you can create a stash of tweets which will be posted to your Twitter account at regular intervals. Instead of overwhelming your followers with all the interesting things you have to say, you can configure it such that it will send out a tweet at 9am and 1pm every day (for instance). The only thing you have to worry about is to keep your buffer filled.
However, the buffer size at Buffer is only 10 tweets. If you want more you need to pay (or make your friends sign up as a referral). Because I find $10/mo a bit much for just a buffer, I decided to make my own.
We'll do this with a Google Spreadsheet and a Google Apps Script"
Solution for making a free SMS inbox in a Google Spreadsheet using the IntelliSoftware SMS Gateway and 30 liines of Google Apps Script code. This particular example is used to collect votes for a poster competition but there are many other things you could use it for.
"Many people have been asking for a simple way to put Google Analytics data into a Google Spreadsheet. Once the data is inside a Google Spreadsheet, users can easily manipulate Google Analytics data, create new visualizations, and build internal dashboards.
So today we released a new integration that dramatically reduces the work required to put Google Analytics data into any Apps Script supported product, such as Google Docs, Sites, or Spreadsheets."
"a new Apps Script web app to the Chrome Web Store! This sample app allows you to create an RSS feed of Google+ activities, and utilizes the HtmlService, ScriptDb, and the ContentService. I'll be publishing a more in depth look at the code in the coming weeks, but for now install it, use it, and let me know what you think!"
IFTTT is a web service that lets you do some basic plumbing between web services. It makes it very easy to trigger actions between different web services. One of the most recent additions is Google Drive. With Google Drive integration you can store files or, the one that interests me more, insert a new row in a Google Spreadsheet.
"My wife and I recently moved into a new house. We needed to send an address update to our contact list but didn't want to go through a printer then stuffing, sealing, stamping and writing out addresses. Given my love of all things Google and my new found curiosity of Google Apps Scripts I wanted to use a Script to: - Send and HTML email; nice design and picture of the house - Email our entire contact list in one send - I wanted it to be free and send from my personal email address - Use personalization; Dear William - Google Maps integration
Queue a Google Apps Script and the deign stylings of my buddy +William Hodges. With the script I was able to: - Create a custom HTML design - Email our entire list from my Gmail account - Include personalization - Provide a Google Map and driving directions from the recipients address to our new address"
" the Apps Script version of the Django framework reference tutorial: the Polls web app. Doing this will help us understand how to write a complete Web application from the UI to the database.
The poll app is very very simple, it’s like a CRUD hello world. The domain model is made of a Poll class (a question) which have associated many Choices (or possible answers for the poll’s question), the user is presented with the available polls list when he click in one of them is redirected to the poll detail with the different choices as options, the users vote for the best choice and finally the results are presented, number of votes for each one of the choices."
Within Google Apps Script you can create basic time-based triggers (poor mans cron) to run functions on specific date/time intervals. Recently on one of my posts someone asked: ‘Is there a way to schedule when the script runs?’. In particular they were interested in running a particular function every 10 minutes for a set period. I did briefly look at scripting time-based triggers, but quickly realised that my original plan to control a number of timed triggers from a central spreadsheet wasn’t possible because the class TriggerBuilder doesn’t allow forSpreadsheet on TimeBased triggers. Instead I came up with this code snippet
Templated Export allows users to reshape and selectively publish data from Google Spreadsheets in custom formats. The tool is powered by Google App Script which allows integration with Google Spreadsheets using existing authenticated access.
Example uses include: turning data from a spreadsheet into a RSS feed and publishing data from a spreadsheet in JSON format to be used by other tools/services.
Check out the post for installation instructions and demonstration videos