Practical Apps Script guides

Duplicate the spreadsheet for a throwaway dry-run of tonight’s job

Ask for fewer OAuth scopes so your client actually clicks Allow

Validate Form answers before they hit your master sheet

Version-pin an Apps Script library so “latest” doesn’t break client scripts

Debounce onEdit so your sheet automation doesn’t thrash

Checkpoint a long run so the next trigger finishes the job

Import a Drive CSV into a sheet in safe chunks

Pin a stable web app URL with versioned deployments

Stay under someone else’s API rate limit

Export last night’s filtered rows to a dated CSV in Drive

Point your script at staging so you never write prod by accident