Submit to google sheet

function doGet(e){
  return handleResponse(e);
}

var SCRIPT_PROP = PropertiesService.getScriptProperties(); // new property service


function queryToObject(query){
  return query.split('&').reduce(function (acc,curr){
    const split = curr.split('=')
    acc[decodeURI(split[0]).toLowerCase()] = decodeURI(split[1])
    return acc 
  },{})
}

function handleResponse(e) {
  const lock = LockService.getPublicLock();
  lock.waitLock(30000);  // wait 30 seconds before conceding defeat.

  const params = queryToObject(e.queryString);

  try {
    // next set where we write the data - you could write to multiple/alternate destinations
    const doc = SpreadsheetApp.openById(SCRIPT_PROP.getProperty("key"));
    const sheet = doc.getSheetByName("Form Responses");


    const headers = sheet.getRange(1, 1, 1, sheet.getLastColumn()).getValues()[0];
    const nextRow = sheet.getLastRow() + 1; // get next row
    const row = [];
    
    headers.forEach(header => {
      const item = params[header.toLowerCase()]
      // else use header name to get data
      row.push(item);
    })
    
    // more efficient to set values as [][] array than individually
    sheet.getRange(nextRow, 1, 1, row.length).setValues([row]);
    
    // return json success results
    return ContentService
      .createTextOutput(JSON.stringify({"result": "success"}))
      .setMimeType(ContentService.MimeType.JSON);
  } catch (e) {
    // if error return this
    return ContentService
      .createTextOutput(JSON.stringify({"result": "error", e: "Something went wrong"}))
      .setMimeType(ContentService.MimeType.JSON);
  } finally { //release lock
    lock.releaseLock();
  }
}

function setup() {
    var doc = SpreadsheetApp.getActiveSpreadsheet();
    SCRIPT_PROP.setProperty("key", doc.getId());
}