I keep a master customer list in both Google Sheets and Zoho CRM, and I need those two sources to stay perfectly aligned. Each week I receive new or revised records covering three areas—contact details (phone, email, address), purchase history, and stated customer preferences. Your job is to make sure those updates land in both places without a hitch and with strict validation. Here’s what I’m looking for: • Initial clean-up and audit of the current Google Sheet and Zoho CRM data to spot duplicates, blanks, or mismatches. • A repeatable weekly process—automated with Apps Script, Zoho API, or another efficient method—to import the new records, update existing ones, and flag inconsistencies before anything goes live. • Validation rules that won’t let malformed phone numbers, bad emails, or incomplete addresses slip through. I want failed entries highlighted in a separate “Errors” tab (or similar) so they’re easy to fix. • A short hand-off guide so anyone on my team can trigger or schedule the weekly sync after you’re done. • Basic change log reporting so I can trace what was added, modified, or skipped in a given week. Tools you choose are flexible as long as they work smoothly with Google Sheets and Zoho CRM, preserve data integrity, and can be maintained without exotic licenses. Deliver the initial clean-up, the working weekly sync, and the documentation. Once everything runs reliably for one full cycle, the project is complete.