Import Curve card data into a Google Sheet

main.gs

function doPost(e) {
  var output = null;
    try {
      var requestData = JSON.parse(e.postData.contents);
      var workbook_id = requestData.sheetID;
      var contentValue = requestData.content;
      var EXPENSE_SHEET_NAME = "New_Expenses";
      var workbook = SpreadsheetApp.openById(workbook_id);
      var sheet = workbook.getSheetByName(EXPENSE_SHEET_NAME);
      if (!sheet) {
        sheet = workbook.insertSheet(EXPENSE_SHEET_NAME, workbook.getSheets().length);
      }
      else {
        sheet.deleteRows(1, sheet.getLastRow()-1);
      }
      var rows = contentValue.split("\n").filter(row => row.trim() !== "");
      if (rows.length > 0) {
        var numColumns = rows[0].split(";").length;
        var range = sheet.getRange(1, 1, rows.length, numColumns);
        range.setValues(rows.map(row => row.split(";")));
        range.createFilter();
      }
      output = buildOutput(200,"✅ Caricamento di "+ rows.length + " righe completato!")
    }
    catch(error) {
      output = buildOutput(400,"😡 Errore nel caricamento: " + error.message);
  }
  finally {
    return output;
  }
}

function buildOutput(status, message) {
    var response = {
      status: status,
      message: message
    };
    var output = ContentService.createTextOutput(JSON.stringify(response));
    output.setMimeType(ContentService.MimeType.JSON);
    return output;
}