getValues google script key name column code example

Example 1: set cell value google script

function doTest() {
  SpreadsheetApp.getActiveSheet().getRange('F2').setValue('Hello');
}

Example 2: google script range get cell values

var myCell = myRange.getCell(row, column)	//Returns a given cell within a range.