ZZZ Digital Lab

Back to Google Sheets CRM repair

Sample client deliverable: $25 bounded CRM diagnosis

SYNTHETIC CASE. Engineering with AI coding tools, tests and written handoff. No customer system was accessed.

Scope: inspect one existing form-to-leads path using supplied synthetic examples. The $25 tier delivers findings, risks, a fix plan and a conditional estimate. Implementation is quoted separately. This small tier is narrower than a full workflow diagnostic.

Finding Evidence from the synthetic reproduction Risk Fix plan
Duplicate leads and trigger replay Baseline appends the same two valid submissions twice Incorrect follow-up and totals Normalize email; stable submission ID; output-based deduplication; shared script lock
Dates guessed from host locale Baseline accepts 03/04/2026 without an agreed interpretation Wrong day/time Strict format and configured source timezone; reject ambiguous or impossible dates
Quota/time failure A simulated 2-write budget interrupts a row-at-a-time baseline Partial changes and duplicate retry Bounded batches, cursor and cooperative runtime budget; replay after service recovery
Unsafe range rewrite Baseline clears owner note and =40+2 formula Data loss Own only A:F; validate header; do not rewrite manual columns
No diagnostic trail Baseline emits no structured logs Hard-to-locate failures Code/row/count logs and dry-run preview; omit contact values

The repaired fixture adds 3 leads, skips 2 duplicates and rejects 3 invalid rows. All 17 local mock tests pass, including a write-before-checkpoint interruption. These results establish the behavior of the local example, not Google production performance.

Proposed acceptance: exact header mapping; default preview makes no writes; note/formula remain intact; direct and reset-cursor replay add no duplicates; invalid dates/missing email are visible; quota failure resumes without duplicate rows.

Conditional implementation estimate: 3-5 engineering hours for one similar bounded ingest path, plus 30-60 minutes for client-controlled staging acceptance. Example scoped repair quote: $350 after confirming sheet size, business rules, permissions and any integrations. This is an estimate, not a measured turnaround guarantee. Existing record merging, additional workflows, document generation and third-party APIs are excluded.

Before staging: confirm which columns are automation-owned, the source timezone, duplicate business rule, inbox ordering policy, trigger inventory and restore procedure. Existing CRM duplicates require a separate merge plan. See HANDOFF.md for the copy-first verification and rollback procedure.