setvalue function in html code example Example: setValue() SpreadsheetApp.getActive().getRange("A1").setValue('abc');