Send calls to Google Sheets

function doPost(e) {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheets()[0];
  var data = JSON.parse(e.postData.contents);

  if (sheet.getLastRow() === 0) {
    sheet.appendRow([
      "Time",
      "Agent",
      "Customer",
      "Phone",
      "Duration (sec)",
      "Outcome",
      "Summary",
      "Transcript",
      "Order",
      "Answered",
      "Direction"
    ]);
  }

  sheet.appendRow([
    data.started_at || data.occurred_at || "",
    data.agent_name || "",
    data.customer_name || "",
    data.customer_phone || "",
    data.duration_sec || "",
    data.call_outcome || "",
    data.summary || "",
    data.transcript || "",
    data.order_number || "",
    data.answered ? "yes" : "no",
    data.direction || ""
  ]);

  return ContentService
    .createTextOutput(JSON.stringify({ ok: true }))
    .setMimeType(ContentService.MimeType.JSON);
}