Google has launched the Google Apps Script in Google Apps Standard Edition, meaning that it is much more broadly available now. Previously, it was only available in Google Apps Premier and Education editions. It was released back in the summer.
Google Apps Script starts in the spreadsheets of Google Docs. It lets you create sheets to read and change formulas, formats and cell contents, and lets you create custom functions so you can automate repetitive tasks.
"Google Apps Script provides the ability to automate a variety of tasks such as modifying Spreadsheets, creating Calendar appointments, checking stock prices, sending email, looking up Contacts and much, much more," says Google Apps Product Manager Evin Levey. More details can be found in the video below:
Execution and hosting of scripts takes place on the Google cloud, and basic support for event handling can run when users are offline.