Your Apps Script Has No Tests Because Jest Can’t Load SpreadsheetApp. Here’s the Fix.

A 4-layer test pyramid for Google Apps Script — pure functions, mocked services, sheet integration, and clasp-driven CI.