Many Google apps, one platform in the cloud
Increase the power of your favorite Google apps — like Calendar, Docs, Drive, Gmail, Sheets, and Slides.
Teach yourself Apps Script
Learn Apps Script fundamentals with codelabsExplore a playlist of guided codelab tutorials that teach you the basics of Apps Script with Google Sheets.
Try a 5-minute quickstartAfter exploring the codelab playlist, try one of our quickstarts to quickly build a working script project. Create menus and custom functions in Google Sheets, manage responses in Google Forms, or create a basic Google Docs add-on or Hangouts Chat bot!
|Custom functions in Sheets||Manage Forms responses|
|Build a Docs add-on||Build a Hangouts Chat bot|
Desktop add-ons for Docs, Sheets, Slides, and Forms
Desktop and mobile add-ons for Gmail
April 22, 2020
onSelectionChange(e), has been added for Google Sheets.The
onSelectionChange(e)trigger runs automatically when a user changes the selection in a spreadsheet.
April 2, 2020
- A new
Drawingclass has been added to support drawings.
- You can now get your drawings with the
- There's a new
FILE_ORGANIZERvalue in the
Permissionenum. If you have
FILE_ORGANIZERpermission on a shared drive, you can edit, trash, and move content within that drive.
February 28, 2020
Colorobjects instead of stringsvas parameters and return types:
Bandingclass now has 16 new methods that manipulate color in the banding columns and rows using
BooleanConditionclass now has two new methods that retrieve the color of the condition's background and font as
ConditionalFormatRuleBuilderclass now has seven new methods that set color-based format rules using
GradientConditionclass now has three new methods that retrieve condition colors as
Rangeclass now has eight new methods that get and set font and background colors using
Sheetclass now has two new methods that get and set tab colors using
Slicerclass now has two new methods that get and set the background color of the slicer using
TextStyleBuilderclass now has a
TextStyleBuilder.setForegroundColorObject(color)method that updates the foreground color of the style builder using a
TextStyleclass now has a
TextStyle.getForegroundColorObject()method that gets the foreground color of the style as a
January 21, 2020
- The Apps Script manifest structure has been
updated to provide configuration controls for
G Suite Add-ons. All
add-on manifest settings are specified in the
AddOnsobject in the manifest.
Manifest fields that previously supported G Suite Add-ons still exist, but are now deprecated. See Upgrading your published add-ons for instructions on how to upgrade a Gmail add-on into a G Suite add-on.
- The Card service has been extended
with the following classes and methods that provide new widgets and event responses:
- The Conference Data service has been added to Apps Script. The service helps G Suite Add-ons that extend Google Calendar to stay in sync with third-party conferencing applications. This service is only useful to developers who manage a conferencing application and want to make it available in Google Calendar.