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)
January 22, 2019
- The Spreadsheet service has been
extended with the following new classes and methods to support text styles
and Rich Text cell formatting:
RichTextValue
RichTextValueBuilder
TextStyle
TextStyleBuilder
Range.getRichTextValue()
Range.getRichTextValues()
Range.getTextStyle()
Range.getTextStyles()
Range.setRichTextValue(value)
Range.setRichTextValues(values)
Range.setTextStyle(style)
Range.setTextStyles(styles)
SpreadsheetApp.newRichTextValue()
SpreadsheetApp.newTextStyle()
- The Data Studio service has been extended with the following new classes and methods that define and support authentication types for community connectors:
- The deprecated UiApp service will be offically shutdown on July 15th, 2019. After this date, the service will no longer function for any script project.
January 4, 2019
- The Slides service has been extended
with the following new classes and methods that support slide linking and text box
insertion:
SlideLinkingMode
Layout.insertTextBox(text)
Layout.insertTextBox(text, left, top, width, height)
Master.insertTextBox(text)
Master.insertTextBox(text, left, top, width, height)
Page.insertTextBox(text)
Page.insertTextBox(text, left, top, width, height)
Presentation.appendSlide(slide, linkingMode)
Presentation.insertSlide(insertionIndex, slide, linkingMode)
Slide.getSlideLinkingMode()
Slide.getSourcePresentationId()
Slide.getSourceSlideObjectId()
Slide.insertTextBox(text)
Slide.insertTextBox(text, left, top, width, height)
Slide.refreshSlide()
Slide.unlink()
- The Data Studio service has been extended with the following new classes and methods that error displays:
December 13, 2018
- The Slides service has been extended
with the following new classes and methods that support connector lines:
ConnnectionSite
Group.getConnectionSites()
Image.getConnectionSites()
Line.getConnectionSites()
Line.getEndConnection()
Line.getLineCategory()
Line.getStartConnection()
Line.isConnector()
Line.setEndConnection(connectionSite)
Line.setLineCategory(lineCategory)
Line.setStartConnection(connectionSite)
LineCategory.UNSUPPORTED
PageElement.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.