The summary.
READ AND WRITE SPREADSHEET RANGES IN BULK, NEVER CELL BY CELL
Each call is slow, and a loop of them exceeds the execution limit. Reading a range into an array and writing it back once changes execution time dramatically.
ADD FAILURE NOTIFICATION TO EVERY SCHEDULED SCRIPT
A silently failing script is discovered weeks later.
ESTABLISH WHETHER A FORMULA OR BUILT-IN FEATURE ALREADY DOES IT
Scripts are maintenance; formulas are not.
And recognise when a spreadsheet has outgrown its purpose — tens of thousands of rows, many simultaneous editors, and business-critical status all signal it.
REQUEST THE NARROWEST SCOPES THAT WORK
Broad scopes require justification, cause hesitation, and fail verification more often.
BLOCK UNVERIFIED APPLICATIONS AND REVIEW WHAT USERS HAVE AUTHORISED
Applications granted access read everything the user can, and users consent without understanding what they granted.
KEEP ORGANISATIONAL CONTENT IN SHARED DRIVES
Files in personal drives leave with the person, and deleting an account removes what they owned. Transfer ownership before deletion.
USE CHANGE NOTIFICATIONS RATHER THAN POLLING
Polling consumes quota continuously for nothing most of the time.
