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."
"If you're creating a course website, you might want to display a calendar of events for that course. A natural consideration is Google Calendar for the actual calendar. This works fine, and has interesting benefits (easy to move events from one day to another) over the traditional "make a big table in MS Word and type dates in manually".
The bummer is, it'd be nice to display the calendar showing things to do for each day in a simple layout. If you add details to the calendar entry, the data is there, but doesn't display in the default views for embedding in your site.
Enter the calendrator. It pulls data from your calendar and formats it in a useful way. To create the calendrator, go to your Google Sites page where you want to embed your calendar. Go to Manage Site - > Apps Scripts and create a new script."
"Time to prep for the Fall semester classes. I typically create a spreadsheet of topics on Google Docs Drive, and for student-ease-of-use I would like to use that data in a Google Calendar. To get these two apps talking, I'm learning Google Apps Script. It is simple to complete https://developers.google.com/apps-script/your_first_script in a matter of minutes, the syntax is quite readable and easy to understand..."
"This app is an experiment in using crowd-sourcing methodology to surface hidden gems from the blogosphere. Topics covered include Collective Intelligence, Information Architecture, Cloud Computing, Big Data, Social Computing, Enterprise 2.0, Symbiotic Intelligence and more."
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
"My last post got me to thinking- if I'm going to write a slight improvement to the google calendar's view interface, what other things would I like to add?
The first thing I'd add would be HTML markup in the description portion of the event. To see what I'm talking about, go make a calendar event, edit it and add to the description. This is a good place to add (say) an assignment for that particular day, but you'll quickly see that you're limited to plain text in this interface. That's highly unsatisfying."
Geocode and get administrative details and geoHash link from a UK postcode directly into an Excel or Google Spreadsheet Following on from the Yahoo GeoCode entry here's another geoCoder - this time using UK post code as input, and providing various UK specific administrative district information. As usual it is implemented as a rest-library member. This a data query API, populating columns in a row in a spreadsheet based on a variable column in the data. You just name the columns to match any data you want to retrieve and go. Here's an example geocoding various random postcodes