Google Apps Script provides the ability to automate a variety of features in Google Apps, such as reading and changing values in Google Spreadsheets, creating Google Calendar appointments, sending email and much more. Check out the Google Apps Script Overview video, 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!
Posted by Evin Levey, Product Manager, Google Apps team
5 comments:
And in honor of Google launching Scripts to the general public, those of us that used in in the pilot release on standard accounts no longer have access to it. Way to go Google.
This looks great. When can we see this in the basic docs account? Or is there some reason that the rest of us can't have it?
Nealle
Any plans for releasing this in standard Google Docs? Sorry, I know there must be some bells and whistles for paying customers, but it looks very very nice... :)
gr8 stuff.Technology going more advance & beyond imagination.
I am anxious to try this as well -- please advise as to how we can access!
Post a Comment
Thank you for sharing your feedback with the Google Enterprise team. We will respond to open issues addressed in Comments with future posts on this blog. We appreciate your interest in Google Enterprise.