Currently, I am working on creating some quick scripts to manipulate spreadsheets in my Google Drive. However, I am cautious about the script unintentionally running and making changes to data before I am ready or executing multiple times after completing its task. For this reason, I am looking for a way to incorporate a popup button or alert within the Google Script editor that prompts the user (usually myself) to confirm if they wish to proceed with running the script.
I have experimented with functions like getUi().alert(), but it seems to be more commonly used when distributing the script as an app. Any suggestions or tips for achieving this functionality?