function myFunction() { var id="1lvzX6n2x1tcrDcBoJOjOIlJCpxFCW0gTlQqyYWPl0R0"; ex = SpreadsheetApp.openById(id); n=ex.getNumSheets(); for(s=0;s<n;s++){ var shx = ex.getSheets()[s]; se=shx.getName(); Logger.log(s+","+se); } }