Apps Script: Exceeded maximum execution time

Apps Script stops any execution that runs past its time limit and logs this message. Google's quotas page lists a script runtime of 6 minutes per execution for both consumer and Google Workspace accounts. Custom functions (formulas you write in Apps Script and call from a cell) are limited to 30 seconds, and simple triggers such as onEdit and onOpen cannot run longer than 30 seconds either.

The limit is per execution, not per day, so nothing is wrong with your quota. The script simply did too much work in one run. Whatever it finished before the cut-off stays done; whatever came after did not happen, which can leave a sheet half-updated.

The usual culprits are loops that call getValue or setValue one cell at a time, and long sequences of UrlFetchApp.fetch calls, each of which waits on a remote server.

// slow: one service call per cell
for (let r = 2; r <= last; r++) {
  const v = sheet.getRange(r, 1).getValue();
  sheet.getRange(r, 2).setValue(transform(v));
}

// fast: one read, one write
const vals = sheet.getRange(2, 1, last - 1, 1).getValues();
sheet.getRange(2, 2, vals.length, 1).setValues(vals.map(([v]) => [transform(v)]));

Design long jobs as resumable batches from the start: track a cursor in script properties, check elapsed time inside the loop, and exit cleanly at around 4 to 5 minutes. Keep spreadsheet reads and writes in bulk. Remember that time-driven trigger runs also count against a daily total trigger runtime (90 minutes a day on consumer accounts, 6 hours on Workspace), so faster code protects that budget too.