Sunday, October 24, 2010

Google App Scripts for Google Sites

If you are using Google Sites for your Public or Intranet sites, here is an awesome news for you. Google has enabled Google App Scripts for Google Sites. Google App Scripts, which is 1.5 years young can be used to automate business processes that involve multiple applications. This will be very handy if you are running a small business and want to setup the infrastructure needed for your company. You can setup multi-step workflows using the Google App scripts.

Google’s Cloud language

Google App Script, which was originally launched to automate tasks (macros) on Google Docs Spreadsheet, is a server side JavaScript that executes on the Google’s Cloud. Almost all the Google’s services can be accessed using Google App Scripts. Though Google App Scripts are not widely used yet, they have got so much of potential on the Cloud. Some of the popular services of Google App Script includes Calendar, Contacts, Mail, DocsList, Spreadsheet, URLFetch, etc. Google is also experimenting UI services using which you can create applications which interact with the users via rich graphical interfaces. Another interesting addition to the list of services is the JDBC service using which you can write JDBC queries to pull data from any of your data servers. (Supports only MySQL for now). Read more about Google App Scripts here.

Script editor showing a sample functionGoogle App Script for Google Sites

To create a new script, go to More Actions > Manage Site > App Scripts. Click on the Launch Editor option to open the editor where in you can write your scripts. Launch editor will compile and check your script for errors. Once your script is saved successfully, you can add links from your page to trigger these functions. App scripts serve as a perfect back end for all your site operations.

From Google Site, you can add links to trigger the App Script functions

Follow Google App Scripts blog to keep yourself updated on the happenings in the space. If you are new to Google App Scripts, check out this tutorial. I have created a working copy of the same on my sample site.

-- Varun

No comments:

Post a Comment

google-site-verification: googlea4d68ed16ed2eea6.html