Many Google apps, one platform in the cloud
Increase the power of your favorite Google apps — like Calendar, Docs, Drive, Gmail, Sheets, and Slides.
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, Slides, and Forms
Desktop add-ons for Docs, Sheets, Slides, and Forms
Apps Script makes it easy to create and publish add-ons in an online
store for Google Sheets, Docs, Slides, 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.
A living, breathing platform (well, metaphorically)
December 13, 2018
- The Slides service has been extended
with the following new classes and methods that support connector lines:
ConnnectionSiteGroup.getConnectionSites()Image.getConnectionSites()Line.getConnectionSites()Line.getEndConnection()Line.getLineCategory()Line.getStartConnection()Line.isConnector()Line.setEndConnection(connectionSite)Line.setLineCategory(lineCategory)Line.setStartConnection(connectionSite)LineCategory.UNSUPPORTEDPageElement.getConnectionSites()Shape.getConnectionSites()SheetsChart.getConnectionSites()Table.getConnectionSites()Video.getConnectionSites()WordArt.getConnectionSites()
- The Fusion Tables advanced service has been deprecated and will shutdown fully on December 3rd, 2019.
November 14, 2018
- The Card service has been extended with the following new classes and methods that let you to customize the background of text button widgets:
- The Slides service has been extended
with the following new methods that let you control the Z-positioning of page
elements in Slides. Other new methods let you add alt titles and alt descriptions
to page elements. The following methods have been added to the
Group,Image,Line,PageElement,Shape,SheetsChart,Table,Video, andWordArtclasses:bringForward()bringToFront()sendBackward()sendToBack()setDescription(description)setTitle(title)
- The Spreadsheet service has been
extended with the following new classes and methods that let you add and search
for metadata strings attached to rows, columns, sheets, or spreadsheets:
DeveloperMetadataDeveloperMetadataFinderDeveloperMetadataLocationDeveloperMetadataLocationTypeDeveloperMetadataVisibilityRange.addDeveloperMetadata(key)Range.addDeveloperMetadata(key, visibility)Range.addDeveloperMetadata(key, value)Range.addDeveloperMetadata(key, value, visibility)Range.createDeveloperMetadataFinder()Range.getDeveloperMetadata()Sheet.addDeveloperMetadata(key)Sheet.addDeveloperMetadata(key, visibility)Sheet.addDeveloperMetadata(key, value)Sheet.addDeveloperMetadata(key, value, visibility)Sheet.createDeveloperMetadataFinder()Sheet.getDeveloperMetadata()Spreadsheet.addDeveloperMetadata(key)Spreadsheet.addDeveloperMetadata(key, visibility)Spreadsheet.addDeveloperMetadata(key, value)Spreadsheet.addDeveloperMetadata(key, value, visibility)Spreadsheet.createDeveloperMetadataFinder()Spreadsheet.getDeveloperMetadata()
October 30, 2018
- The Spreadsheet service has been
extended with the following new classes and methods:
OverGridImageSheet.getImages()Sheet.isColumnHiddenByUser(columnPosition)Sheet.isRowHiddenByFilter(rowPosition)Sheet.isRowHiddenByUser(rowPosition)Spreadsheet.getImages()Spreadsheet.isColumnHiddenByUser(columnPosition)Spreadsheet.isRowHiddenByFilter(rowPosition)Spreadsheet.isRowHiddenByUser(rowPosition)
- The following methods in the
Spreadsheet service now return an
OverGridImageobject instead ofvoid: - The following methods have been added to existing services:
- console service
- DataStudio service
- Gmail service
October 18, 2018
- The Card service has been extended with the following classes and methods to support Gmail add-on compose actions:
September 27, 2018
- The Data Studio service is now available. You can use this service when building a Data Studio Community Connector.
August 20, 2018
- The Utilities service has been extended with the following methods and classes:
August 17, 2018
-
Apps Script add-on documentation has been moved to a new location:
G Suite Developer > Add-ons.
The Add-on documentation has been moved in an effort to make add-ons
more discoverable and improve site navigation.
In the coming months we will continue to expand and revise the Add-ons documentation to create a better developer learning experience.
Need help? Visit our