Export Cleanup Pipeline

The spec — copy this

Set up a new bot for me I can trigger on any raw export. Walk me through connecting my document store and spreadsheet, then configure it: take the export and produce a clean dataset plus a data-quality report. Normalize dates to a single format and flag any that are impossible, out of range, or ambiguous between day-first and month-first; standardize picklist and free-text variants to the canonical values I define; split or join name and address fields consistently; normalize phone numbers and mark the invalid ones; and deduplicate on the keys I specify with a stated confidence level on every proposed merge. Never silently drop, merge, or auto-correct a row — everything it cannot clean goes to an exceptions file with the reason and the original value preserved, and the counts have to reconcile: rows in, rows clean, rows excepted, and they must add up on the face of the report. Show me the fill rate for every column before and after. Ask me for my canonical values, my dedupe keys and confidence threshold, my valid date ranges, and which columns are required versus optional, run it against an export I have already cleaned by hand so I can diff its output against mine, then save it.