Model the task before writing the script
Identify the initiating event, required inputs, destinations, and expected output. Establish which spreadsheet, document, or system owns each fact instead of using a sheet as an accidental database.
- ✓ Trigger and workflow inventory
- ✓ Input validation and ownership rules
- ✓ Service identity and scope review
Plan for quotas and maintenance
Account for execution limits, authorization changes, duplicate triggers, and partial completion. Document deployment ownership and provide a visible way to inspect errors and rerun safe operations.
- ✓ Document the evidence and owner behind each decision.
- ✓ Agree acceptance criteria before implementation begins.
Scope and delivery decisions
Workspace licensing, account permissions, and API access must be confirmed. Other runtimes may fit better when scale or execution limits exceed Apps Script.
- ✓ Confirm system access, dependencies, and data handling during discovery.
- ✓ Receive a scoped recommendation with responsibilities and verification steps.