Teach yourself Apps Script
Learn Apps Script fundamentals with codelabs
Explore a playlist of guided codelab tutorials that teach you the basics of Apps Script with Google Sheets.Try a 5-minute quickstart
After 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 |
Build add-ons to extend Google Sheets, Docs, Slides, Forms, and Gmail
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.
Desktop and mobile add-ons for Gmail
You can also build add-ons that extend Gmail on both desktop and mobile. Since you build Gmail add-ons with a card and widget library, you don't need to build separate UIs for desktop and mobile clients.
A living, breathing platform (well, metaphorically)
January 21, 2020
To support the launch of G Suite Add-ons, the following manifest changes, service, classes, and methods have been added to Apps Script:
- 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:
CalendarEventActionResponseCalendarEventActionResponseBuilderDatePickerDateTimePickerDisplayStyleDriveItemsSelectedActionResponseDriveItemsSelectedActionResponseBuilderFixedFooterSwitchControlTypeTimePickerCardBuilder.setDisplayStyle(displayStyle)CardBuilder.setFixedFooter(fixedFooter)CardBUilder.setPeekCardHeader(peekCardHeader)CardService.newCalendarEventActionResponseBuilder()CardService.newDatePicker()CardService.newDateTimePicker()CardService.newDriveItemsSelectedActionResponseBuilder()CardService.newFixedFooter()CardService.newTimePicker()Switch.setControlType(controlType)
- 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.
December 18, 2019
- The Spreadsheet service has been extended with the following class and new methods to support using color building and theme colors:
December 12, 2019
The documentation for Apps Script manifest file structures has been redesigned and relocated into the Reference section. The new reference pages describe the fields and resources that make up an Apps Script manifest file, including the sections related to Add-ons.
December 11, 2019
- The Data Studio service has been
extended with the following class and new methods to support different response
types and dynamic statuses:
GetDataResponseGetSchemaREsponseSetCredentialsResponse-
Checkbox.setIsDynamic(isDynamic) -
CommunityConnector.newGetDataResponse() -
CommunityConnector.newGetSchemaResponse() -
CommunityConnector.newSetCredentialsResponse() -
Config.setIsSteppedConfig(isSteppedConfig) -
SelectMultiple.setIsDynamic(isDynamic) -
SelectSingle.setIsDynamic(isDynamic) -
TextArea.setIsDynamic(isDynamic) -
TextInput.setIsDynamic(isDynamic)
December 6, 2019
A new Apps Script Fundamentals codelab playlist has been created. This playlist walks new users through basic Apps Script concepts as they build scripts for Google Sheets.
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.getIdentityToken()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.