Google Sheets Apps Script Triggers and Permissions Review
Review scripts attached to a spreadsheet for risks.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
[VERIFY] is an editorial flag, not a blank to fill. Wherever the prompt shows [VERIFY], check that item against a reliable source before you use it.
Review the scripts attached to a Google Sheet as a defensive review of my own sheet. Script purpose and code summary or key functions: [SCRIPT_DESCRIPTION]. Triggers in order of frequency: [TRIGGERS]. Authorisations requested: [AUTHORISATIONS]. Who can edit the sheet: [EDITORS]. Check for scripts that send email or change many rows without confirmation, triggers that run too often (estimate runs per day from the trigger list and show the arithmetic), access to more data than needed, hard-coded email addresses or identifiers, no logging, no error handling, and code written by people who have since left. Explain who can run the script and under whose authority. Rank findings by the harm a mistake could do, and say what a non-programmer can check. Return a table of findings with risk and fix, a plain-language description of the script for the owner and users, a short summary for managers (what it does, what it can access, who owns it, how often it is reviewed), and an annual review plan. Mark permission names [VERIFY]. Do not ask me to paste secrets.
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.