Google Apps Script
Feedback on this document

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 Sheets
    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 the Standalone Scripts section of the Scripts and Google Accounts document.

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

Container-bound scripts are created within a container, such as a Google Sheet or a Google Site. Container-bound scripts are accessible only from their parent containers, not directly from Google Drive. An example of a container-bound script is a custom function for Google Spreadsheets.

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

Google Apps Script supports two types of containers: Google Sheets and Google Sites.

Google Sheets

To create or open scripts bound to a spreadsheet, open the spreadsheet 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.