
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)
November 6, 2019
- The Spreadsheet service has been extended with the following class and new methods to support using slicers to filter ranges, charts, and pivot tables:
- The Script service has been extended
with the
ScriptApp.getIdentity()
method, which returns an identity token for the effective user.
October 28, 2019
You can no longer publish web apps to the Chrome Web Store. The Chrome Web Store
deprecated Chrome apps in 2016 and they are now only available for ChromeOS devices.
This change includes published Apps Script web apps. Previously published web apps are no longer discoverable in the Chrome Web Store. Editor add-ons aren't affected; you can still publish editor add-ons to the Chrome Web Store.
October 23, 2019
- The Slides service class
RgbColor
and the enumerationColorType
have been moved from the Slides service to the Base script service. The functionality of these classes has not changed. Moving these classes to the Base script service enables other services to make use of them in the future. You can now find the documenation for these classes atRgbColor
andColorType
. - Several classes and methods relating to the now shutdown
UiApp service have been removed. Most
of these methods involved interactions between the
Charts service and
UiApp
that were very seldom used. The following is a full list of the removed classes and methods:- Charts service
CategoryFilterBuilder
Control
DashboardPanel
DashboardPanelBuilder
Chart.getId()
Chart.getType()
Charts.newCategoryFilter()
Charts.newDashboardPanel()
Charts.newNumberRangeFilter()
Charts.newStringFilter()
NumberRangeFilterBuilder.build()
NumberRangeFilterBuilder.setDataTable(tableBuilder)
NumberRangeFilterBuilder.setDataTable(table)
NumberRangeFilterBuilder.setFilterColumnIndex(columnIndex)
NumberRangeFilterBuilder.setFilterColumnLabel(columnLabel)
NumberRangeFilterBuilder.setLabel(label)
NumberRangeFilterBuilder.setLabelSeparator(labelSeparator)
NumberRangeFilterBuilder.setLabelStacking(orientation)
StringFilterBuilder.build()
StringFilterBuilder.setDataTable(tableBuilder)
StringFilterBuilder.setDataTable(table)
StringFilterBuilder.setFilterColumnIndex(columnIndex)
StringFilterBuilder.setFilterColumnLabel(columnLabel)
StringFilterBuilder.setLabel(label)
StringFilterBuilder.setLabelSeparator(labelSeparator)
StringFilterBuilder.setLabelStacking(orientation)
- Spreadsheet service
EmbeddedChart.getId()
EmbeddedChart.getType()
EmbeddedChart.setId(id)
- Charts service