Spreadsheet Automation Script Audit
Review cloud spreadsheet scripts for reliability and permissions.
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 scripts attached to a cloud spreadsheet. Script code with secrets removed: [SCRIPT_CODE]. Triggers and permissions requested: [TRIGGERS_PERMISSIONS]. Data touched: [DATA_TOUCHED]. Check whether permissions are broader than needed, triggers could run at the wrong time, quotas could be exceeded, errors are logged, sensitive data is sent anywhere, and edits can be undone. Explain the flow in plain language. Return a table with Area, Finding, Risk (red, amber, green) and Fix, a score from 1 to 10 for safety and reliability, and a deployment checklist with a rollback. Privacy rules are [VERIFY] for [JURISDICTION]. Also suggest logging each run with date and result, a limit on the number of rows processed, and a person to receive failure notices. Mention that permissions should be reviewed whenever the script is changed or transferred to a new owner. Keep severity honest: separate confirmed issues from possible ones, give the evidence for each, and recommend a retest after fixes so that closure is verified and not assumed.
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.