Google Sheet: Insert Checkbox with App Script

App Script to insert check boxes in selected cells on sheet.

function insertCheckbox(){
var ss=SpreadsheetApp.getActiveSpreadsheet();
var sh=ss.getActiveSheet();
var activeRange=sh.getActiveRange();
var checkbox=SpreadsheetApp.newDataValidation().requireCheckbox().setAllowInvalid(false).build();
activeRange.setDataValidation(checkbox).setValue(true);
}

Видео Google Sheet: Insert Checkbox with App Script канала S S