function myFunction() { id="1kCcC1bb1fujtlkEgwBXA-E4xQAjCKi3i3_7t5xoPt5k"; var ex1 = SpreadsheetApp.openById(id); var sheet = ex1.getSheetByName("data"); n=100*Math.random(); m=Math.floor(n); sheet.getRange(1,1).setValue(m); }