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:

// Slow: N round trips
for (let row = 1; row <= sheet.getLastRow(); row += 1) {
  sheet.getRange(row, 1).setValue(computeValue(row));
}