Google Sheets CRM Maintenance & Troubleshooting Hub

Common causes of Google Sheets CRM failures and how we resolve them:

Clean, modular Google Apps Script architecture for lead intake and agent routing:

/**
 * Production-Grade Google Sheets CRM Lead Ingress Handler
 * Safe against concurrent submissions & timeout limits
 */
function doPost(e) {
  const lock = LockService.getScriptLock();
  
  // Wait up to 30 seconds for concurrent writes to clear
  if (!lock.tryLock(30000)) {
    return ContentService.createTextOutput(JSON.stringify({
      status: "busy",
      message: "Sheet currently updating. Please retry."
    })).setMimeType(ContentService.MimeType.JSON);
  }

  try {
    const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Master_Leads");
    const payload = JSON.parse(e.postData.contents);
    const nextRow = sheet.getLastRow() + 1;
    
    // Assign sales agent using round-robin logic
    const agent = assignNextAvailableAgent();

    // High-speed atomic write (Single call instead of multiple setValues)
    sheet.getRange(nextRow, 1, 1, 5).setValues([[
      new Date(),
      payload.name,
      payload.channel || "Web Ingress",
      agent,
      "New Inquiry"
    ]]);

    return ContentService.createTextOutput(JSON.stringify({
      status: "success",
      row: nextRow,
      assignedAgent: agent
    })).setMimeType(ContentService.MimeType.JSON);

  } catch (error) {
    Logger.log("Ingestion error: " + error.toString());
    return ContentService.createTextOutput(JSON.stringify({
      status: "error",
      message: error.toString()
    })).setMimeType(ContentService.MimeType.JSON);

  } finally {
    // Always release lock so next lead processes immediately
    lock.releaseLock();
  }
}