Apps Script Services

Available scripts

• scripts/fetch_policy.py — the shared fetching contract the script below fetches through: it names the script and the repository in the User-Agent, reads robots.txt before the target, paces requests, and stops rather than retries on 403/429/503. Vendored from template/scripts/fetch_policy.py; don't edit it here.
• 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));
}