Cool things to do on Appscript

appscript.js

// Enter value in a cell
var valueRange = Sheets.newValueRange();
valueRange.values = [["text"]];
const result = Sheets.Spreadsheets.Values.update(valueRange,
  SHEET_ID, A1_NOTATION, {valueInputOption: "RAW"});
  
// Fetches values as a multidimensional array
Sheets.Spreadsheets.Values.get(SHEET_ID, RANGE)


var valueRange = Sheets.newValueRange();
valueRange.values = [[event.id]];
const result = Sheets.Spreadsheets.Values.update(valueRange,
  SHEET_ID, "J"+cellVal, {valueInputOption: "RAW"});
Logger.log('result:' + result);