Google is committed to advancing racial equity for Black communities. See how.

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

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.
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)

New methods have been added to the Spreadsheet service.
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.
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.
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: