Google Adds Scripts to Spreadsheets
Google Spreadsheets now include the ability to use Google Script, a means for running server-side Java script. Already available for Google Sites, the addition of Google Script in Spreadsheets gives you the ability to automate complex or repetitive actions.