Back in August we released Google Apps Script to Google Apps Premier and Education Edition customers. Today we're excited to extend the availability of Apps Script to Google Apps Standard Edition, used by millions of groups, families, clubs and other organizations around the world.
Google Apps Script provides the ability to automate a variety of tasks such as modifying Spreadsheets, creating Calendar appointments, checking stock prices, sending email, looking up Contacts and much, much more. For a more detailed overview, check out the video below:
Getting started is easy. You can take a look at the Apps Script Welcome Page, and then work through some of the Tutorials. Before long you'll be writing scripts to automate all kinds of repetitive tasks like keeping track of group expenses and sending out automated reminders triggered by values in a spreadsheet.
In this example, we're using a Google Docs spreadsheet to keep track of our soccer team's weekly dues. Each player owes $5 per game towards shared expenses. Unfortunately the players can be an absentminded bunch that need frequent payment reminders. In the spreadsheet, every amount entered updates a player's column to indicate which weeks are PAID (in green), and how much is DUE (in red). We've also used Apps Script to add a custom menu:
- 'Refresh' recalculates and colors cells to indicate which weeks are PAID and which are DUE
- 'Send Reminders' emails a polite message reminding players in debt to pay up
Check it out, and let us know what you think!
Posted by Evin Levey, Product Manager, Google Apps team
8 comments:
This is another impressive milestone for Docs! Perhaps you should point out it's being rolled out progressivly -- I don't have the 'scripts' menu item yet.
I wish the script feature could also interact with a document, so that using a form would allow for the data to be placed on a document for a different way of reading
Great news! We in htp://www.fjsolutions.com.ar implement Google Apps to all our clients.
I'm very interested by scripting possibilities,
but I can't use script editor in spreadsheet.
It doesn't appear in the menu.
Too soon perhaps ?
My project : create a small entreprise to help Google Apps user.
This is great! I'm hoping to get a simple online database out of this. Anyone out there have a script that handles a simple web-based query to a spreadsheet/database that shows results in either a webpage or by sending an email to an address indicated.
ok, one question. Does this only work with google apps (for your domain) or does this work with ordinary google docs/mail too?
I do not have Scripts menu Item in Tools. :(
So question to author: when it will be available for regular users as it was mentioned in the post? Or maybe we need to contact somebody for switching this feature on?
I also do not have script menu item in Tools.
What do I have to do to access this feature? Thanks
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.