var a=new Array(); function myFunction() { var id="1Mxnz53KzQXG-0WFeFmRZ6yP1utzVIeZL4PH4VfpgDEU"; ex = SpreadsheetApp.openById(id); var sheet = ex.getSheetByName("data"); var x=sheet.getRange(2,2,3,3); for(s=0;s<11;s++){ a[s]=new Array(); } a=x.getValues(); Logger.log(a[2][2]); }