Add new lead from updated sheet to CRM and dispatch

Lead sheet rows contain messy phones, missing emails and unparsed addresses, leaving dispatch without contact-ready details. It normalizes contact data, creates or updates a CRM contact and notifies stakeholders same day.