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 modern JavaScript platform in the cloud. Build solutions to boost your collaboration and productivity.
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)
June 12, 2020
New methods have been added to the Spreadsheet service.
- The
RichTextValueclass now has aRichTextValue.getLinkUrl()method that gets the URL of the specified value. - The
RichTextValueBuilderclass now has aRichTextValueBuilder.setLinkUrl()method that sets the link URL for the specified value. - The
PivotTableclass now has aPivotTable.getSourceDataRange()method that returns the source data range on which the pivot table is constructed. - The
PivotValueclass now has aPivotValue.remove()method that removes the value from the pivot table.
April 22, 2020
A new simple trigger,
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
The following has been added to the
Spreadsheet service:
- A new
Drawingclass has been added to support drawings. - You can now get your drawings with the
Sheet.getDrawings()method.
- There's a new
FILE_ORGANIZERvalue in thePermissionenum. If you haveFILE_ORGANIZERpermission on a shared drive, you can edit, trash, and move content within that drive.
February 28, 2020
The following methods have been added to the Spreadsheet service to support the use of theme colors. Many of these methods duplicate the effect of existing color methods, but let you use
Color objects instead of stringsvas parameters and return types: - The
Bandingclass now has 16 new methods that manipulate color in the banding columns and rows usingColorobjects. - The
BooleanConditionclass now has two new methods that retrieve the color of the condition's background and font asColorobjects. - The
ConditionalFormatRuleBuilderclass now has seven new methods that set color-based format rules usingColorobjects. - The
GradientConditionclass now has three new methods that retrieve condition colors asColorobjects. - The
Rangeclass now has eight new methods that get and set font and background colors usingColorobjects. - The
Sheetclass now has two new methods that get and set tab colors usingColorobjects. - The
Slicerclass now has two new methods that get and set the background color of the slicer usingColorobjects. - The
TextStyleBuilderclass now has aTextStyleBuilder.setForegroundColorObject(color)method that updates the foreground color of the style builder using aColorobject. - The
TextStyleclass now has aTextStyle.getForegroundColorObject()method that gets the foreground color of the style as aColorobject.