Google Spreadheets Scripts: check if cell is empty

June 13, 2023 by Tarik

No need to extact the value to determine if the cell is empty. Google Spreadsheet API already has a method for this: Range – isBlank method

var cell = r.getCell(rws-1, 10);

if (cell.isBlank()) {
    cell.setValue("foo");
}