var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheets()[0]; var range = sheet.getRange('A1:D10'); //range.activate(); var values = range.getValues(); //Logger.log(values[0][0]);