Do more. With Google.
automate your workflow, integrate with external APIs, and more.
Try a 5-minute quickstart
NEW! 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
for Google Sheets and Docs.
(The add-ons store for Forms is coming soon.) 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.
March 11, 2014
- Announced a developer preview for add-ons in Google Docs and the new version of Google Sheets, with support for Google Forms coming soon. An add-on is an Apps Script project published to a store inside Docs or Sheets, which makes it easy for users to find and install new features. Our guides cover everything you need to know to develop, design, and apply to publish your first add-on.
- Released a CSS package to apply Google styling to fonts, buttons, and form elements in HTML service dialogs and sidebars, primarily for use in add-ons.
- Added the
createAddonMenu(), which allows scripts to insert a sub-menu into the Add-ons menu in Google Sheets or Docs. For more information, see the guide to menus.
- Added the
AuthMode, which identifies categories of authorized services that Apps Script can execute through a triggered function. For more information, see the guide to the add-on authorization lifecycle.
- Changed the quota for Gmail from 10,000 reads and 10,000 writes per day (excluding sent messages) to 20,000 reads and writes combined per day.
- Added support for the custom JsDoc annotation
@OnlyCurrentDoc, which forces the authorization dialog to ask only for access to files in which an add-on or script is used, rather than all of a user's spreadsheets, documents, or forms. An opposing annotation,
@NotOnlyCurrentDoc, is also available.