Create add-ons for Google Sheets, Docs, Slides, or Forms, automate your workflow, integrate with external APIs, and more.
Overview Explore the API
Home Guides Reference Samples Support Add-ons Apps Script API

Many Google apps, one platform in the cloud

Sheets Docs Slides Forms Drive Drive Calendar Hangouts Chat Sites Contacts Groups Maps Translate

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.
Build with Docs

Macros, menus, and custom functions

Tailor spreadsheet functions to your needs and build reports with a custom menu in Google Sheets.
Build with Sheets

Managing responses for Google Forms

Email Calendar invites and a personalized Google Doc to every user who responds to a form.
Build with Forms Try a Forms Add-on

Build add-ons to extend Google Sheets, Docs, Slides, and Forms

Illustration of Apps Script editor Illustration of Google Sheets editor Illustration of Google Docs editor Illustration of Google Forms editor

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.
Learn about Add-ons

A living, breathing platform (well, metaphorically)

November 6, 2019

October 28, 2019

You can no longer publish web apps to the Chrome Web Store. The Chrome Web Store deprecated Chrome apps in 2016 and they are now only available for ChromeOS devices. This change includes published Apps Script web apps. Previously published web apps are no longer discoverable in the Chrome Web Store. Editor add-ons aren't affected; you can still publish editor add-ons to the Chrome Web Store.

October 23, 2019

  • The Slides service class RgbColor and the enumeration ColorType have been moved from the Slides service to the Base script service. The functionality of these classes has not changed. Moving these classes to the Base script service enables other services to make use of them in the future. You can now find the documenation for these classes at RgbColor and ColorType.
  • Several classes and methods relating to the now shutdown UiApp service have been removed. Most of these methods involved interactions between the Charts service and UiApp that were very seldom used. The following is a full list of the removed classes and methods:
    • Charts service
      • CategoryFilterBuilder
      • Control
      • DashboardPanel
      • DashboardPanelBuilder
      • Chart.getId()
      • Chart.getType()
      • Charts.newCategoryFilter()
      • Charts.newDashboardPanel()
      • Charts.newNumberRangeFilter()
      • Charts.newStringFilter()
      • NumberRangeFilterBuilder.build()
      • NumberRangeFilterBuilder.setDataTable(tableBuilder)
      • NumberRangeFilterBuilder.setDataTable(table)
      • NumberRangeFilterBuilder.setFilterColumnIndex(columnIndex)
      • NumberRangeFilterBuilder.setFilterColumnLabel(columnLabel)
      • NumberRangeFilterBuilder.setLabel(label)
      • NumberRangeFilterBuilder.setLabelSeparator(labelSeparator)
      • NumberRangeFilterBuilder.setLabelStacking(orientation)
      • StringFilterBuilder.build()
      • StringFilterBuilder.setDataTable(tableBuilder)
      • StringFilterBuilder.setDataTable(table)
      • StringFilterBuilder.setFilterColumnIndex(columnIndex)
      • StringFilterBuilder.setFilterColumnLabel(columnLabel)
      • StringFilterBuilder.setLabel(label)
      • StringFilterBuilder.setLabelSeparator(labelSeparator)
      • StringFilterBuilder.setLabelStacking(orientation)
    • Spreadsheet service
      • EmbeddedChart.getId()
      • EmbeddedChart.getType()
      • EmbeddedChart.setId(id)
Older release notes