code.js

function createNewRowAndWriteToSheet(parameters) {
  var sheet = getSheet();
  var headers = getHeaders(sheet);
  var newRow = createRow(headers, parameters);
  callWithScriptLock(writeRowToSheet, sheet, newRow);
  return newRow;
}

function getSheet() {
  var spreadsheet = SpreadsheetApp.openById(SCRIPT_PROPERTIES.getProperty("spreadsheetId"));
  return spreadsheet.getSheetByName(SCRIPT_PROPERTIES.getProperty("sheetName"));
}

function getHeaders(sheet) {
  return sheet.getRange(1, 1, 1, sheet.getLastColumn()).getValues()[0];
}

function createRow(headers, parameters) {
  var row = [];
  
  for (i in headers){
    if (headers[i] == "timestamp"){
      row.push(new Date());
    } else {
      row.push(parameters[headers[i]]);
    }
  }
  
  return row;
}

function writeRowToSheet(sheet, row) {
  var nextRow = sheet.getLastRow()+1;
  sheet.getRange(nextRow, 1, 1, row.length).setValues([row]);
}