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.