Do more. With Google.
Try a 5-minute quickstart
Create a Docs add-on that transforms selected text into other languages with Google Translate.
Tailor spreadsheet functions to your needs and build reports with a custom menu in Google Sheets.
Apps Script makes it easy to create and publish add-ons in an online store for Google Sheets, Docs, and Forms. There’s no better way to distribute scripts to large number of users, whether you want to ship your code to the whole world or keep it private to the users in your Google Apps domain.
February 11, 2015
- Added the following class, enum, and methods to the Spreadsheet service, to give precise control over protected sheets and ranges:
- Deprecated the following class and methods, which have been replaced by the
Protectionclass above. Although this class and these methods are deprecated, they will remain available for compatibility with the older version of Sheets.
- Replaced the method
SpreadsheetApp.open(file), which takes a
Fileobject from the deprecated DocsList service as a parameter, with a version that takes a
Fileobject from the Drive service instead. The new method has the same name.
- Changed several
Spreadsheetmethods that previously returned
voidso that they now return a
Spreadsheetobject that can be used to chain method calls.
- Changed the Document service methods
Text.setFontFamily(fontFamilyName)to use string names for font families instead of the
FontFamilyenum, and consequently deprecated
- The following fix was applied: