Integrations

/**
 * MuxForms → Google Sheets
 * 1. Extensions → Apps Script → paste this file → Save
 * 2. Run setupSheet once (authorize when prompted)
 * 3. Deploy → New deployment → Web app → Execute as: Me, Who has access: Anyone
 * 4. Copy the /exec URL into MuxForms → Integrations → Google Sheets
 */
const SHEET_NAME = "MuxForms";

function setupSheet() {
  const ss = SpreadsheetApp.getActiveSpreadsheet();
  let sheet = ss.getSheetByName(SHEET_NAME);
  if (!sheet) sheet = ss.insertSheet(SHEET_NAME);
  sheet.clear();
  sheet.appendRow(["submitted_at", "submission_id", "form_name", "form_project", "origin"]);
}

function doPost(e) {
  const lock = LockService.getScriptLock();
  lock.waitLock(30000);
  try {
    const data = JSON.parse(e.postData.contents);
    const ss = SpreadsheetApp.getActiveSpreadsheet();
    let sheet = ss.getSheetByName(SHEET_NAME);
    if (!sheet) {
      setupSheet();
      sheet = ss.getSheetByName(SHEET_NAME);
    }
    const fields = data.fields || {};
    const keys = Object.keys(fields).filter(function (k) {
      return k.indexOf("_") !== 0;
    }).sort();
    const header = sheet.getRange(1, 1, 1, sheet.getLastColumn()).getValues()[0];
    const baseCols = ["submitted_at", "submission_id", "form_name", "form_project", "origin"];
    const needed = baseCols.concat(keys);
    if (header.join("") === "" || header[0] !== "submitted_at") {
      sheet.getRange(1, 1, 1, needed.length).setValues([needed]);
    } else {
      const existing = header.filter(Boolean);
      const merged = existing.slice();
      keys.forEach(function (k) {
        if (merged.indexOf(k) === -1) merged.push(k);
      });
      if (merged.length > existing.length) {
        sheet.getRange(1, 1, 1, merged.length).setValues([merged]);
      }
    }
    const rowHeader = sheet.getRange(1, 1, 1, sheet.getLastColumn()).getValues()[0];
    const row = rowHeader.map(function (col) {
      if (col === "submitted_at") return data.createdAt || "";
      if (col === "submission_id") return data.submissionId || "";
      if (col === "form_name") return (data.form && data.form.name) || "";
      if (col === "form_project") return (data.form && data.form.project) || "";
      if (col === "origin") return data.origin || "";
      return fields[col] != null ? String(fields[col]) : "";
    });
    sheet.appendRow(row);
    return ContentService.createTextOutput(JSON.stringify({ ok: true })).setMimeType(
      ContentService.MimeType.JSON,
    );
  } finally {
    lock.releaseLock();
  }
}