Google Apps Script provides the ability to automate a variety of features in Google Apps, such as reading and changing values in Spreadsheets, creating Calendar appointments, sending email and much more. Check out the Google Apps Script Overview, below, taken from our May announcement.
Our favorite user example is a bureaucracy-busting Expense Approval Script, which expands one of the tutorials we've assembled to help people see how to use Google Apps Script. Submitting and approving expense reports can be tedious. Adding a script automates the drudgery by doing the following:
- automatically converting foreign currency amounts to local currency
- looking up historical exchange rates from external web services
- catching basic errors – things like missing dates, descriptions, and amounts
- triggering business logic to flag certain expense categories 'For Review'
This is just one of hundreds of business processes that can be customized and streamlined using Google Apps Script within Google Apps Premier and Education editions. From expenses and timesheets to trouble tickets and order tracking – really, anything that you might want to calculate, organize and automate – is now easier than ever with Google Apps Script.
Starting today, all Google Apps Premier and Edu domains will now see "Scripts" in the Google Spreadsheets "Tools" menu – so check it out.
We're looking forward to seeing how users put Google Apps Script to creative (and valuable) use, so start scripting, and let us know what you come up with. We'll feature some of our favorite user submissions over the coming weeks!