ZZZ Digital Lab

Back to Google Sheets CRM repair

before/Code.gs

/* DELIBERATELY BROKEN, SYNTHETIC. Never deploy. */
function brokenCrm() {
  var book = SpreadsheetApp.getActiveSpreadsheet();
  var inbox = book.getSheetByName('Inbox').getDataRange().getValues().slice(1);
  var leads = book.getSheetByName('Leads');
  // No lock, no checkpoint, no idempotency, one write per row, no log.
  inbox.forEach(function(row) {
    var date = new Date(row[3]); // Host locale guesses ambiguous dates.
    leads.appendRow(['lead_' + row[0], row[1], row[2], date.toISOString(), row[4], row[0]]);
  });
  // Accidental full-sheet rewrite destroys the client's notes and formulas.
  var values = leads.getDataRange().getValues().map(function(row) { return row.slice(0, 6).concat(['', '']); });
  leads.getRange(1, 1, values.length, 8).setValues(values);
}