get google sheet cell value in script code example

Example 1: set cell value google script

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

Example 2: get cell value from string google sheets

=CONCAT("value is ", C5)