Triggers let your Apps Script run automatically — without you having to click anything. They can fire on a schedule (every hour, daily, weekly), when a spreadsheet is opened or edited, or when a form is submitted.

There are two types of triggers:

• Simple triggers — built-in, no setup required: onOpen(), onEdit(), onFormSubmit()
• Installable triggers — set up programmatically or via the Apps Script UI, with more power and flexibility

In this series, we follow the Acme Corp sales team. Their Sales Tracker sheet uses triggers to validate data entry, send automated daily reports, sync form submissions, and notify managers on key events.

All examples use a Sales Tracker Google Sheet with the following columns:

• Introduction to Triggers
• Time-Driven Triggers
• onEdit Trigger
• onOpen Trigger
• onFormSubmit Trigger
• Manage Triggers Programmatically