CRM data migration & sync script

Python ETL from Google Sheets through validation, mapping, and duplicate detection into a client CRM API with rate-limit aware uploads.

Built a custom Python script that pulls structured data from Google Sheets, applies business logic and decision-making rules including field validation, conditional mapping, data transformation, and duplicate detection, then programmatically uploads records to a client CRM via its API. Handles edge cases like missing fields, conflicting data, and rate limiting for clean, reliable data transfer.