var number; var loandi=new Array(); function myFunction() { var id="1oGPEIhiEdPV4w0Blu7vZ6GwfnmIdiscex3hr6b31b24"; var ex1 = SpreadsheetApp.openById(id); var shb = ex1.getSheetByName("b"); var v_b=shb.getRange(1, 1,67,7).getValues(); number=66; for(s=1;s<number+1;s++){ loandi[s]=v_b[s][2]; Logger.log(loandi[s]); } }