u/mayaswelltrythis - replace "Suggestion"

//Makes many calls to the sheet api..
function getTranslationSuggestions() {
  //Change sheetname
  const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Data');
  //Change starting row
  const startRow = 2;
  const data = sheet.getRange(startRow, 1, sheet.getLastRow(), 5).getValues();

  for (i = 0; i < data.length; i++) {
    const row = data[i];
    if (row[2] === 'Suggestion' && row[3] !== 'OK') {
      sheet.getRange(i + startRow, 3).setValue(row[4])
    }
  }
}

//Build the hole dataset and makes one write call to the sheet.
function getTranslationSuggestionsReplaceHoleDataSet() {
  //Change sheetname
  const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Data');
  //Change starting row
  const startRow = 2;
  const data = sheet.getRange(startRow, 1, sheet.getLastRow(), 5).getValues();

  const converted = data.map(row => {
    if (row[2] === 'Suggestion' && row[3] !== 'OK'){
      row[2] = row[4]
      return row
    } else {
      return row
    }
  })

  sheet.getRange(startRow,1,converted.length, 5).setValues(converted)

}