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)
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.
February 26, 2019
- The Spreadsheet service has been
extended with the following new classes and methods to support
BigQuery data connectors in Sheets:
BigQueryDataSourceSpecBigQueryDataSourceSpecBuilderDataExecutionErrorCodeDataExecutionStateDataExecutionStatusDataSourceParameterTypeDataSourceParameterDataSourceSpecBuilderDataSourceSpecDataSourceTableDataSourceTypeDataSourceRange.getDataSourceTables()Sheet.getDataSourceTables()SpreadsheetApp.enableAllDataSourcesExecution()SpreadsheetApp.enableBigQueryExecution()SpreadsheetApp.newDataSourceSpec()Spreadsheet.getDataSourceTables()Spreadsheet.insertSheetWithDataSourceTable(spec)
- The Data Studio service has been extended with the following new methods involving reaggregation settings:
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:
RichTextValueRichTextValueBuilderTextStyleTextStyleBuilderRange.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.
Need help? Visit our