Class SpreadsheetTriggerBuilder
컬렉션을 사용해 정리하기
내 환경설정을 기준으로 콘텐츠를 저장하고 분류하세요.
스프레드시트트리거빌더
스프레드시트 트리거의 빌더입니다.
자세한 문서
create()
트리거를 만들고 반환합니다.
리턴
Trigger
: 생성된 트리거입니다.
onChange()
스프레드시트의 콘텐츠 또는 구조가 변경될 때 실행되는 트리거를 지정합니다.
const sheet = SpreadsheetApp.getActive();
ScriptApp.newTrigger('myFunction').forSpreadsheet(sheet).onChange().create();
리턴
SpreadsheetTriggerBuilder
: 연결을 위한 빌더
onEdit()
스프레드시트가 수정될 때 실행되는 트리거를 지정합니다.
const sheet = SpreadsheetApp.getActive();
ScriptApp.newTrigger('myFunction').forSpreadsheet(sheet).onEdit().create();
리턴
SpreadsheetTriggerBuilder
: 연결을 위한 빌더
onOpen()
스프레드시트가 열릴 때 실행할 트리거를 지정합니다.
const sheet = SpreadsheetApp.getActive();
ScriptApp.newTrigger('myFunction').forSpreadsheet(sheet).onOpen().create();
리턴
SpreadsheetTriggerBuilder
: 연결을 위한 빌더
달리 명시되지 않는 한 이 페이지의 콘텐츠에는 Creative Commons Attribution 4.0 라이선스에 따라 라이선스가 부여되며, 코드 샘플에는 Apache 2.0 라이선스에 따라 라이선스가 부여됩니다. 자세한 내용은 Google Developers 사이트 정책을 참조하세요. 자바는 Oracle 및/또는 Oracle 계열사의 등록 상표입니다.
최종 업데이트: 2025-07-26(UTC)
[null,null,["최종 업데이트: 2025-07-26(UTC)"],[[["\u003cp\u003eSpreadsheetTriggerBuilder facilitates the creation and customization of triggers specific to Google Spreadsheets.\u003c/p\u003e\n"],["\u003cp\u003eIt offers methods to set triggers for various events, such as changes in content or structure (\u003ccode\u003eonChange()\u003c/code\u003e), edits (\u003ccode\u003eonEdit()\u003c/code\u003e), form submissions (\u003ccode\u003eonFormSubmit()\u003c/code\u003e), and spreadsheet opening (\u003ccode\u003eonOpen()\u003c/code\u003e).\u003c/p\u003e\n"],["\u003cp\u003eEach trigger specification method returns a builder object, enabling chained configurations for flexibility and conciseness in trigger setup.\u003c/p\u003e\n"],["\u003cp\u003eThe \u003ccode\u003ecreate()\u003c/code\u003e method finalizes the trigger definition and returns a Trigger object, instantiating the trigger for execution based on the specified event.\u003c/p\u003e\n"]]],[],null,["# Class SpreadsheetTriggerBuilder\n\nSpreadsheetTriggerBuilder\n\nBuilder for spreadsheet triggers. \n\n### Methods\n\n| Method | Return type | Brief description |\n|-----------------------------------|--------------------------------------------------|--------------------------------------------------------------------------------------------|\n| [create()](#create()) | [Trigger](/apps-script/reference/script/trigger) | Creates the trigger and returns it. |\n| [onChange()](#onChange()) | [SpreadsheetTriggerBuilder](#) | Specifies a trigger that will fire when the spreadsheet's content or structure is changed. |\n| [onEdit()](#onEdit()) | [SpreadsheetTriggerBuilder](#) | Specifies a trigger that will fire when the spreadsheet is edited. |\n| [onFormSubmit()](#onFormSubmit()) | [SpreadsheetTriggerBuilder](#) | Specifies a trigger that will fire when the spreadsheet has a form submitted to it. |\n| [onOpen()](#onOpen()) | [SpreadsheetTriggerBuilder](#) | Specifies a trigger that will fire when the spreadsheet is opened. |\n\nDetailed documentation\n----------------------\n\n### `create()`\n\nCreates the trigger and returns it.\n\n#### Return\n\n\n[Trigger](/apps-script/reference/script/trigger) --- The created trigger.\n\n*** ** * ** ***\n\n### `on``Change()`\n\nSpecifies a trigger that will fire when the spreadsheet's content or structure is changed.\n\n```javascript\nconst sheet = SpreadsheetApp.getActive();\nScriptApp.newTrigger('myFunction').forSpreadsheet(sheet).onChange().create();\n```\n\n#### Return\n\n\n[SpreadsheetTriggerBuilder](#) --- a builder for chaining\n\n*** ** * ** ***\n\n### `on``Edit()`\n\nSpecifies a trigger that will fire when the spreadsheet is edited.\n\n```javascript\nconst sheet = SpreadsheetApp.getActive();\nScriptApp.newTrigger('myFunction').forSpreadsheet(sheet).onEdit().create();\n```\n\n#### Return\n\n\n[SpreadsheetTriggerBuilder](#) --- a builder for chaining\n\n*** ** * ** ***\n\n### `on``Form``Submit()`\n\nSpecifies a trigger that will fire when the spreadsheet has a form submitted to it.\n\n```javascript\nconst sheet = SpreadsheetApp.getActive();\nScriptApp.newTrigger('myFunction')\n .forSpreadsheet(sheet)\n .onFormSubmit()\n .create();\n```\n\n#### Return\n\n\n[SpreadsheetTriggerBuilder](#) --- A builder for chaining.\n\n*** ** * ** ***\n\n### `on``Open()`\n\nSpecifies a trigger that will fire when the spreadsheet is opened.\n\n```javascript\nconst sheet = SpreadsheetApp.getActive();\nScriptApp.newTrigger('myFunction').forSpreadsheet(sheet).onOpen().create();\n```\n\n#### Return\n\n\n[SpreadsheetTriggerBuilder](#) --- a builder for chaining"]]