function myFunction() { var id="1ChIck64wMEkXXgODwSeCcXJt65q8Sm3Q0smCne0KMgw"; var ex1 = SpreadsheetApp.openById(id); var sheet = ex1.getSheetByName("d"); var str="33333"; for(s=1;s<11;s++){ sheet.getRange(s,s).setValue(str); } }