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 modern JavaScript platform in the cloud. Build solutions to boost your collaboration and productivity.

Teach yourself Apps Script

Learn Apps Script fundamentals with codelabs

Explore a playlist of guided codelab tutorials that teach you the basics of Apps Script with Google Sheets.

Try a 5-minute quickstart

After exploring the codelab playlist, try one of our quickstarts to quickly build a working script project. Create menus and custom functions in Google Sheets, manage responses in Google Forms, or create a basic Google Docs add-on or Hangouts Chat bot!
Custom functions in Sheets Manage Forms responses
Build a Docs add-on Build a Hangouts Chat bot

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

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.

Desktop and mobile add-ons for Gmail

You can also build add-ons that extend Gmail on both desktop and mobile. Since you build Gmail add-ons with a card and widget library, you don't need to build separate UIs for desktop and mobile clients.

A living, breathing platform (well, metaphorically)

April 22, 2020

A new simple trigger, onSelectionChange(e), has been added for Google Sheets.The onSelectionChange(e) trigger runs automatically when a user changes the selection in a spreadsheet.

April 2, 2020

The following has been added to the Spreadsheet service: The following has been added to the Drive service:
  • There's a new FILE_ORGANIZER value in the Permission enum. If you have FILE_ORGANIZER permission on a shared drive, you can edit, trash, and move content within that drive.

February 28, 2020

The following methods have been added to the Spreadsheet service to support the use of theme colors. Many of these methods duplicate the effect of existing color methods, but let you use Color objects instead of stringsvas parameters and return types:

February 5, 2020

Apps Script now supports the V8 runtime. This enables modern JavaScript features and syntax in Apps Script. You can migrate existing scripts to use V8 and its features.

January 21, 2020

To support the launch of G Suite Add-ons, the following manifest changes, service, classes, and methods have been added to Apps Script: