Google Apps Script gets green light

The tool works mainly within the Spreadsheets app to automate various processes. Google's enterprise team also unveils a tool called Side-by-Side search.

Google Apps Script handles spreadsheet data.
Google Apps Script automates processes such as sending e-mails regarding spreadsheet data. Google Enterprise Blog

Google officially rolled out its Apps Script functionality for enterprise users Wednesday, following a limited pilot release earlier this year.

Google Apps Script works mainly within the Spreadsheets app to automate various processes. For example, users can automate the sending of e-mails based on data held in a spreadsheet, or create scripts that communicate with other Web services.

"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 products manager Evin Levey wrote in a blog post Wednesday.

Giving an example of how Apps Script can be used, Levey described an expense approval scenario, in which the script automatically converts foreign currency to local currency, pulls historical exchange rates from external Web services, picks up on missing data, and flags certain expense categories for review.

"Even more useful, the script can figure out whose approvals are needed and automatically request approval from those people," Levey wrote. "And once approved, the script sends a note to the finance department for payment -- all without writing a single e-mail."

Google Apps Premier and Education Edition customers can locate the scripts functionality through the Tools menu in the Spreadsheets app. Levey wrote that the Apps team is seeking feedback on what customers come up with in their use of the tool.

Also on Wednesday, Google's enterprise team announced another tool called Side-by-Side search. The tool allows users to compare the results of two separate searches based on the same body of data, which the team said would allow the evaluation of the Google Search Appliance (GSA) against a company's existing enterprise search product.

The team also announced an upgraded suite of GSA Connectors, including an Enterprise Labs release of a connector for the Salesforce CRM system.

David Meyer of ZDNet UK reported from London.

 

Join the discussion

Conversation powered by Livefyre

Show Comments Hide Comments
Latest Galleries from CNET
The best tech products of 2014
Does this Wi-Fi-enabled doorbell Ring true? (pictures)
Seven tips for securing your Facebook account
The best 3D-printing projects of 2014 (pictures)
15 crazy old phones from a Korean museum (pictures)
10 gloriously geeky highlights from 2014 (pictures)