apps-script-services

# Apps Script Services ## Available scripts - **`scripts/check-quotas.sh`** — fetches current Apps Script quotas/limitations from the official docs (see Checking current quotas below). Run with `--help` for options. ## SpreadsheetApp: batch, don't loop Every `getValue()`/`setValue()`/`getRange(row, col)` call is a remote call to the Sheets backend — a loop over N cells makes N round trips. Read and write in one call: ```ts // Slow: N round trips for (let row = 1; row <= sheet.getLastRow(); row += 1) { sheet.getRange(row, 1).setValue(computeValue(row)); } // Fast: 2 round trips total (one read, one write) const range = sheet.getRange(1, 1, sheet.getLastRow(), 1); const values = range.getValues(); const updated = values.map(([value]) => [computeValue(value)]); range.setValues(updated); ``` `appendRow` inside a loop has the same problem — collect rows and call `getRange(...).setValues(rows)` once, or `sheet.getRange(sheet.getLastRow() + 1, 1, rows.length, rows[0].length).setValues(rows)`. ## PropertiesService: size limits `ScriptProperties`/`UserProperties`/`DocumentProperties` each cap a single value at **9 KB** and the total store at **500 KB**. Storing structured state means `JSON.stringify` on write, `JSON.parse` on read — and checking the serialized size before writing, since GAS throws a generic error on overflow rather than telling you which key exceeded the limit: ```ts function setJsonProperty(store: GoogleAppsScript.Properties.Properties, key: string, value...