function myFunction() { var id="1ghmf1VFxy9iHgnE0JIFdJ1QNo4HoXNw4yZQHJPro-Rs"; ex1 = SpreadsheetApp.openById(id); sheet = ex1.getSheetByName("data"); sheet.getRange(1,1).setValue("a"); sheet.getRange(3,2).setValue("b"); }