SpreadsheetTriggerBuilder

Builder for spreadsheet triggers.

### Methods

| Method | Return type | Brief description |
|---|---|---|
| `https://developers.google.com/apps-script/reference/script/spreadsheet-trigger-builder#create()` | `https://developers.google.com/apps-script/reference/script/trigger` | Creates the trigger and returns it. |
| `https://developers.google.com/apps-script/reference/script/spreadsheet-trigger-builder#onChange()` | `https://developers.google.com/apps-script/reference/script/spreadsheet-trigger-builder#` | Specifies a trigger that fires when the spreadsheet's content or structure is changed. |
| `https://developers.google.com/apps-script/reference/script/spreadsheet-trigger-builder#onEdit()` | `https://developers.google.com/apps-script/reference/script/spreadsheet-trigger-builder#` | Specifies a trigger that fires when the spreadsheet is edited. |
| `https://developers.google.com/apps-script/reference/script/spreadsheet-trigger-builder#onFormSubmit()` | `https://developers.google.com/apps-script/reference/script/spreadsheet-trigger-builder#` | Specifies a trigger that fires when the spreadsheet has a form submitted to it. |
| `https://developers.google.com/apps-script/reference/script/spreadsheet-trigger-builder#onOpen()` | `https://developers.google.com/apps-script/reference/script/spreadsheet-trigger-builder#` | Specifies a trigger that fires when the spreadsheet is opened. |

## Detailed documentation

### `create()`

Creates the trigger and returns it.

#### Return


`https://developers.google.com/apps-script/reference/script/trigger` --- The created trigger.

*** ** * ** ***

### `onChange()`

Specifies a trigger that fires when the spreadsheet's content or structure is changed.

```javascript
const sheet = SpreadsheetApp.getActive();
ScriptApp.newTrigger('myFunction').forSpreadsheet(sheet).onChange().create();
```

#### Return


`https://developers.google.com/apps-script/reference/script/spreadsheet-trigger-builder#` --- A builder for chaining.

*** ** * ** ***

### `onEdit()`

Specifies a trigger that fires when the spreadsheet is edited.

```javascript
const sheet = SpreadsheetApp.getActive();
ScriptApp.newTrigger('myFunction').forSpreadsheet(sheet).onEdit().create();
```

#### Return


`https://developers.google.com/apps-script/reference/script/spreadsheet-trigger-builder#` --- A builder for chaining.

*** ** * ** ***

### `onFormSubmit()`

Specifies a trigger that fires when the spreadsheet has a form submitted to it.

```javascript
const sheet = SpreadsheetApp.getActive();
ScriptApp.newTrigger('myFunction')
    .forSpreadsheet(sheet)
    .onFormSubmit()
    .create();
```

#### Return


`https://developers.google.com/apps-script/reference/script/spreadsheet-trigger-builder#` --- A builder for chaining.

*** ** * ** ***

### `onOpen()`

Specifies a trigger that fires when the spreadsheet is opened.

```javascript
const sheet = SpreadsheetApp.getActive();
ScriptApp.newTrigger('myFunction').forSpreadsheet(sheet).onOpen().create();
```

#### Return


`https://developers.google.com/apps-script/reference/script/spreadsheet-trigger-builder#` --- A builder for chaining.