Wednesday, August 19, 2009

Google Apps Script Launched to Google Apps Premier and Education

Back in May we announced a pilot release of Google Apps Script, and after thousands of hours of use, and lots of valuable feedback, we're excited to launch Google Apps Script to all Google Apps Premier and Education Edition customers today.

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'
Even more useful, the script can figure out whose approvals are needed, and automatically request approval from those people. And once approved, the script sends a note to the finance department for payment – all without writing a single email!

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!


  1. Will this API eventually be available to everyone, including those with spreadsheets at

  2. Ditto Russell's question. It's not clear to me whether Standard Edition users should remain hopeful that they'll get this next, or should rush out and upgrade to Premium Edition today.

  3. As you guys expand this and we build new functions and features, Google should promote it as a reason to pay the paltry $50 to go Premier!

  4. Super site! I am Loving it!! Will return once more, Im taking your food likewise, Thanks. PLease visit our site instagram viewer to see top hashtag on instagram


  5. For Education,jobs, news, health, Business, Astrology

  6. Choosing a great business lawyer is one of the important decisions you will make as a business owner. The choice is much more than about money. Baby Formula Recall Lawsuit

  7. Starting a small business or a home-based business is not something that should be entered into lightly. More often than not you'll go through a long period languishing while trying to make your business viable bread bag supply

  8. The Path of the Law presents the conclusions drawn by Holmes after more than 30 years of legal observation, thought, and practice of law. He probably wrote this essay to further discuss what he began in his most famous publication, The Common Law. The Path of The Law was written not as a manual about the practice of law, but a manual to show students how to think like a lawyer; what it means to be a good lawyer; and what it means to have a successful law career. Elmiron Lawyer