Google Spreadsheets adds Scripting
Google has launched a limited test of Google Apps Script which allows users to add automation with Google Spreadsheets. Google Apps Script allows you to automate reading and changing values in cells and ranges, changing formats and formulas and creating custom functions and make those functions available from the Google Spreadsheets menu. Scripting is not limited to Google Spreadsheets functions but can also allow you to send email and even create calendar entries. One of the samples created included a Google Form that entered information into a Google Spreadsheet then performed a mail merge and sent mail through Gmail.
If this sounds cool, you can Apply to Google Apps Script now.
