Juniper Lane School's office runs on one spreadsheet: a device loan log, trip consent forms and trip fees. Each task automates one chore with the tools from this unit: a simple onEdit trigger, an installable form-submit trigger, MailApp and a time-driven trigger.
Decide first which kind of trigger the task needs. An edit in the sheet calls onEdit without setup. A form response needs a trigger installed by a setup function you run once. A schedule needs a time-driven trigger. Email is never sent from a simple trigger.
Every task is checked by playing the same edits, responses or timer through your script and a reference script, on this data and, where it matters, on a changed copy. No new skills: if one stalls you, go back to the lesson it comes from.
Every onEdit starts by returning for the edits it should ignore.