Routing rules → Google Apps Script translator

// Google Forms → Slack, with routing rules baked in.
//
// Generated by https://routeforms.com/tools/routing-rules-to-apps-script
//
// Install (90 seconds):
//   1. In your Google Form, click the three-dot menu → Apps Script.
//   2. Replace the placeholder code with this file. Save (Cmd+S).
//   3. Run installFormBridge once from the function dropdown.
//   4. Authorise when Google asks.
//   5. Submit a test response to verify.
//
// The script walks RULES top-to-bottom on every submission. The first
// matching rule wins and its webhookUrl receives the Slack message. If
// no rule matches, DEFAULT_WEBHOOK_URL receives the message. If
// DEFAULT_WEBHOOK_URL is empty, the script logs a warning and does not
// post.

const FORM_NAME_OVERRIDE = "";
const DEFAULT_WEBHOOK_URL = "PASTE_YOUR_DEFAULT_WEBHOOK_HERE";

// Rules are evaluated top to bottom. First match wins.
const RULES = [
  // No rules defined, every response goes to DEFAULT_WEBHOOK_URL.
];

// --- Install ------------------------------------------------------------

function installFormBridge() {
  var form = FormApp.getActiveForm();
  if (!form) {
    throw new Error(
      "No active form. Open this script editor from inside your Google Form: " +
        "Form → three-dot menu → Apps Script."
    );
  }
  // Wipe any existing onFormSubmit trigger so re-running install is safe.
  var existing = ScriptApp.getProjectTriggers();
  for (var i = 0; i < existing.length; i++) {
    if (existing[i].getHandlerFunction() === "onFormSubmit") {
      ScriptApp.deleteTrigger(existing[i]);
    }
  }
  ScriptApp.newTrigger("onFormSubmit").forForm(form).onFormSubmit().create();
  Logger.log("\u2713 Installed. Submit a test response to verify.");
}

// --- Rule evaluation ----------------------------------------------------

function pickField(data, fieldName) {
  if (!data) return null;
  var target = String(fieldName || "").trim().toLowerCase();
  for (var k in data) {
    if (String(k).trim().toLowerCase() === target) {
      var v = data[k];
      if (v === null || v === undefined) return null;
      return String(v);
    }
  }
  return null;
}

function evaluateRule(rule, data) {
  var fieldValue = pickField(data, rule.fieldName);
  var ruleValue = String(rule.value || "").trim();
  var op = rule.operator;

  if (op === "IS_EMPTY") return fieldValue === null || String(fieldValue).trim() === "";
  if (op === "IS_NOT_EMPTY") return fieldValue !== null && String(fieldValue).trim() !== "";
  if (fieldValue === null) return false;

  var fv = String(fieldValue).trim().toLowerCase();
  var rv = ruleValue.toLowerCase();

  if (op === "EQUALS") return fv === rv;
  if (op === "NOT_EQUALS") return fv !== rv;
  if (op === "CONTAINS") return fv.indexOf(rv) !== -1;
  if (op === "DOES_NOT_CONTAIN") return fv.indexOf(rv) === -1;

  if (
    op === "GREATER_THAN" ||
    op === "GREATER_THAN_OR_EQUAL" ||
    op === "LESS_THAN" ||
    op === "LESS_THAN_OR_EQUAL"
  ) {
    // Currency / commas / unit tolerance — '₹50,000' compares as 50000.
    var a = parseFloat(String(fieldValue).replace(/[^\d.-]/g, ""));
    var b = parseFloat(ruleValue);
    if (isNaN(a) || isNaN(b)) return false;
    if (op === "GREATER_THAN") return a > b;
    if (op === "GREATER_THAN_OR_EQUAL") return a >= b;
    if (op === "LESS_THAN") return a < b;
    return a <= b;
  }
  return false;
}

// --- Submission handler -------------------------------------------------

function onFormSubmit(e) {
  try {
    var form = FormApp.getActiveForm();
    var response = e.response;
    var items = response.getItemResponses();
    var data = {};
    for (var i = 0; i < items.length; i++) {
      var ir = items[i];
      var title = ir.getItem().getTitle();
      var answer = ir.getResponse();
      if (Array.isArray(answer)) answer = answer.join(", ");
      data[title] = answer;
    }
    var formTitle = FORM_NAME_OVERRIDE || form.getTitle();

    // Find the first matching rule.
    var matched = null;
    for (var j = 0; j < RULES.length; j++) {
      if (evaluateRule(RULES[j], data)) { matched = RULES[j]; break; }
    }
    var webhookUrl = matched ? matched.webhookUrl : DEFAULT_WEBHOOK_URL;
    if (!webhookUrl) {
      Logger.log("No matching rule and no default webhook, skipping.");
      return;
    }

    var payload = buildSlackPayload(formTitle, data, matched);
    UrlFetchApp.fetch(webhookUrl, {
      method: "post",
      contentType: "application/json",
      payload: JSON.stringify(payload),
      muteHttpExceptions: true
    });
  } catch (err) {
    Logger.log("Form bridge error: " + err);
  }
}

// --- Slack Block Kit message --------------------------------------------

function buildSlackPayload(formTitle, data, matched) {
  var lines = [];
  for (var k in data) {
    if (String(k).indexOf("_") === 0) continue; // skip meta fields
    var v = data[k];
    var rendered = (v === null || v === undefined)
      ? "\u2014"
      : (typeof v === "object" ? JSON.stringify(v) : String(v));
    if (rendered.length > 500) rendered = rendered.slice(0, 500) + "\u2026";
    lines.push("*" + k + ":* " + rendered);
  }
  var matchedLine = matched
    ? ("\n*Matched rule:* " + matched.name)
    : "\n*Matched rule:* (no rule matched, default channel)";
  return {
    text: "New response from " + formTitle,
    blocks: [
      { type: "section", text: { type: "mrkdwn", text: ":inbox_tray: *New form response*" } },
      { type: "section", text: { type: "mrkdwn", text: "*Form:* " + formTitle + matchedLine + "\n*Submitted:* " + new Date().toLocaleString() } },
      { type: "divider" },
      { type: "section", text: { type: "mrkdwn", text: lines.join("\n") || "_(no fields)_" } }
    ]
  };
}