Class SpreadsheetTriggerBuilder

Builder for spreadsheet triggers.

Method	Return type	Brief description
`create()`	`Trigger`	Creates the trigger and returns it.
`onChange()`	`SpreadsheetTriggerBuilder`	Specifies a trigger that will fire when the spreadsheet's content or structure is changed.
`onEdit()`	`SpreadsheetTriggerBuilder`	Specifies a trigger that will fire when the spreadsheet is edited.
`onFormSubmit()`	`SpreadsheetTriggerBuilder`	Specifies a trigger that will fire when the spreadsheet has a form submitted to it.
`onOpen()`	`SpreadsheetTriggerBuilder`	Specifies a trigger that will fire when the spreadsheet is opened.

Detailed documentation

Creates the trigger and returns it.

Trigger — The created trigger.

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

var sheet = SpreadsheetApp.getActive();
ScriptApp.newTrigger("myFunction")
  .forSpreadsheet(sheet)
  .onChange()
  .create();

SpreadsheetTriggerBuilder — a builder for chaining

Specifies a trigger that will fire when the spreadsheet is edited.

var sheet = SpreadsheetApp.getActive();
ScriptApp.newTrigger("myFunction")
  .forSpreadsheet(sheet)
  .onEdit()
  .create();

SpreadsheetTriggerBuilder — a builder for chaining

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

var sheet = SpreadsheetApp.getActive();
ScriptApp.newTrigger("myFunction")
  .forSpreadsheet(sheet)
  .onFormSubmit()
  .create();

SpreadsheetTriggerBuilder — A builder for chaining.

Specifies a trigger that will fire when the spreadsheet is opened.

var sheet = SpreadsheetApp.getActive();
ScriptApp.newTrigger("myFunction")
  .forSpreadsheet(sheet)
  .onOpen()
  .create();

SpreadsheetTriggerBuilder — a builder for chaining