function f() { id="1LiyXNPFrE4uKxPC2L-R86MOR4PsLP-izj3PZ9qHDuCg"; var ex1 = SpreadsheetApp.openById(id); var sheet = ex1.getSheetByName("data"); var str=sheet.getRange(2, 2).getValue(); sheet.getRange(4, 4).setValue(str); }