11 Google apps, 1 platform in the cloud
Increase the power of your favorite Google apps — like Calendar, Docs, Drive, Gmail, and Sheets.
Apps Script lets you do more with Google. All on a JavaScript platform in the cloud.
Try a 5-minute quickstart
Add-on for Google Docs
Create a Docs add-on that transforms selected text into other languages with Google Translate.Macros, menus, and custom functions
Tailor spreadsheet functions to your needs and build reports with a custom menu in Google Sheets.Managing responses for Google Forms
Email Calendar invites and a personalized Google Doc to every user who responds to a form.Build add-ons to extend Google Sheets, Docs, and Forms
Desktop add-ons for Docs, Sheets and Forms
Apps Script makes it easy to create and publish add-ons in an online
store for Google Sheets, Docs, and Forms. There’s no better way to
distribute scripts to large numbers of users, whether you want to ship
your code to the whole world or keep it private to the users in your
G Suite domain.
Android add-ons for Docs and Sheets
Developers can use Apps script to connect Android apps to the Google Docs and Sheets apps on Android. This allows users to pass data to and from their Docs and Sheets to those apps, all from their mobile device.
A living, breathing platform (well, metaphorically)
July 28, 2017
- Added a getFormUrl() method that returns the URLs of Forms send responses to this Sheet or Spreadsheet.
- Adds a Checkbox Grid item to Forms.
- Enabled the collection of exception and error reports using Stackdriver Error Reporting.
July 18, 2017
- To protect users from abuse, Google OAuth clients that request certain sensitive OAuth scopes are subject to review by Google. Such apps may present users with a warning screen saying the app is unverified by Google. You can remove this screen from your app's authorization flow by submitting a review request.
June 23, 2017
- Stackdriver Logging has been moved out of Early Access. All scripts now have access to Stackdriver logging.
June 20, 2017
-
Added the method randomize()
that randomizes the order of rows in a spreadsheet
Range.
April 26, 2017
- Quizzes in Google Forms is now accessible from the Apps Script Forms service.
- Added support for Combo and Histogram charts. Like other charts, these can be embedded in a Google Sheet.
- Added ability to getColor() and setColor() for Calendar Events. Events have their own color set: EventColor.
March 9, 2017
- Introduced project collaboration using Team Drives. Files and scripts in a Team Drive are owned by the team instead of individuals, allowing teams to develop and maintain scripts more readily.
- Script editors (in addition to script owners) can now publish add-ons and deploy scripts as web apps or executables for the Execution API.
- For all container-bound scripts, the container owner takes ownership of a new script project regardless of who created it.
March 7, 2017
- Enabled the Slides Advanced Service.
- Enabled the Sheets Advanced Service.
December 1, 2016
- Introduced the Early Access program for new G Suite Business features. These features include App Maker and Stackdriver Logging.
November 23, 2016
- Added forms validation classes for check boxes, generic data, grid items, paragraph text items, and text items.
October 19, 2016
- Added X-Frame-Option header support to HtmlService, allowing iframes to render Apps Script HTML and web apps.