Google announced this week that it has launched a limited test of a new feature, which lets people add customization and automation to Google Apps, starting with spreadsheets in Google Docs. They call this Google Apps Script.
Google Apps Script lets users automate spreadsheet actions, like reading and changing values in cells and ranges, changing formats and formulas, and creating custom functions. It also allows users to send email or create calendar entries outside of spreadsheets.