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)
September 9, 2019
The Card service methods
CardHeader.setUrl(url) and
Image.setUrl(url) have been updated to accept an encoded image data
string as an input parameter. As before, you can alternatively use a publicly-available image URL as the input parameter.
August 7, 2019
Documentation for the UI service has been removed. This service was deprecated in December 2014 and officially
shut down on July 15, 2019. To build interfaces for web apps and editor add-ons, use
the HTML service.
July 26, 2019
- The Slides service has been extended with the following new methods to support concrete color schemes:
- The Spreadsheet service has been extended with the following new methods to support trimming whitespace and removing duplicate values:
May 20, 2019
- The Gmail service has been updated
with the
GmailMessage.getHeader(name)method that can retrieve a RFC 2822 header from a message. - The Optimization service has been updated with the following batch methods:
May 3, 2019
The Document service has been updated to add methods to get and set the language of a document:
April 19, 2019
The Data Studio service has been updated to add a few values to
FieldType enum: HYPERLINKIMAGEIMAGE_LINK
April 8, 2019
The behavior of the Google
Clould (GCP) projects used by scripts has been altered. Now, the
default GCP projects that Apps Script creates for new scripts are hidden and
script owners can't access them directly. Admins and domain users with the
resourcemanager.projects.list permission on the parenting GCP folder can still access default GCP projects. If you need access to a script's GCP project (because you wish to publish it or take a similar action), it's best to switch your script to use a standard GCP project.
April 5, 2019
- The Spreadsheet service has been
extended with the following new classes and methods to support text finding,
checkboxes, and other features:
TextFinderRecalculationIntervalSheetTypeDataValidationBuilder.requireCheckbox()DataValidationBuilder.requireCheckbox(checkedValue)DataValidationBuilder.requireCheckbox(checkedValue, uncheckedValue)- A
clearRanges()method has been added to the all the embedded chart type builder classes, such asEmbeddedAreaChartBuilder.clearRanges() EmbeddedChart.getChartId()RangeList.check()RangeList.insertCheckboxes()RangeList.insertCheckboxes(checkedValue)RangeList.insertCheckboxes(checkedValue, uncheckedValue)RangeList.removeCheckboxes()RangeList.uncheck()Range.check()Range.createTextFinder(findText)Range.getDataRegion()Range.getDataRegion(dimension)Range.insertCheckboxes()Range.insertCheckboxes(checkedValue)Range.insertCheckboxes(checkedValue, uncheckedValue)Range.removeCheckboxes()Range.uncheck()Sheet.createTextFinder(findText)Sheet.getType()Spreadsheet.createTextFinder(findText)Spreadsheet.getIterativeCalculationConvergenceThreshold()Spreadsheet.getMaxIterativeCalculationCycles()Spreadsheet.getRecalculationInterval()Spreadsheet.isIterativeCalculationEnabled()Spreadsheet.moveChartToObjectSheet(chart)Spreadsheet.setIterativeCalculationConvergenceThreshold(minThreshold)Spreadsheet.setIterativeCalculationEnabled(isEnabled)Spreadsheet.setMaxIterativeCalculationCycles(maxIterations)Spreadsheet.setRecalculationInterval(recalculationInterval)
- The Data Studio service has been extended with the following new classes and methods that support configuring BigQuery connectors:
- The
Notificationobjects in the Card service no longer have a type that you must set. Calls to the now removedNotification.setType(type)method result in a no-op.
Need help? Visit our