Google Apps Script

Scripts and Containers

There are two main classifications of scripts: standalone scripts and container-bound scripts.

  1. Standalone scripts
    1. Connect the Drive app
  2. Container-bound scripts
    1. Google Docs, Sheets, and Forms
    2. Google Sites

Standalone scripts

Standalone scripts are directly accessible from Google Drive. To create a standalone script, go to https://script.google.com.

To learn more about permissions and access levels for standalone scripts, see Scripts and Google Accounts.

Connect the Drive app

You can also create a standalone script directly from Google Drive.

The first time you want to create a script from Drive, follow these steps:

  1. Go to Google Drive and click Create > Connect more apps.
  2. When the "Connect apps to Drive" window appears, type "script" into the search box and press the Enter key.
  3. Click Connect next to the listing for Google Apps Script, then click OK in the confirmation window.

Now that you've connected the app, you can create a script by selecting Create > Script.

Container-bound scripts

A container-bound script is accessible only from its parent container, not directly from Google Drive. An example of a container-bound script is a custom function for Google Sheets.

To create or open a container-bound script, you must have editor or owner access to the container. To learn more about permissions and access levels for container-bound scripts, see Scripts and Google Accounts.

Google Apps Script supports four types of containers: Google Docs, Sheets, Forms, and Sites.

Google Docs, Sheets, and Forms

To create or open scripts bound to a document, spreadsheet, or form, open the file and select Tools > Script editor.

Google Sites

To create or open scripts bound to a Google Site, open the site and select More > Manage Site > Apps Scripts.

Authentication required

You need to be signed in with Google+ to do that.

Signing you in...

Google Developers needs your permission to do that.