Here's a quick video demonstrating and explaining the Google Apps Script authorization flow, explaining Google's blatant warning screen, the little-known @OnlyCurrentDoc secret, the onEdit authorization error, script scopes, and thinking about security when it comes to Google Apps Script.
If you want to make a copy of the Google Sheet I demo-ed in this video, you can get it at the following link: https://bit.ly/4dRC0cd
Chapters
0:00 Script Authorization
2:30 @OnlyCurrentDoc
3:55 onEdit Error
5:22 Script Scopes
7:55 UrlFetchApp - Security