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);
}