Create CRM lead and deal from new sheet row

Your Google Sheet lead rows use inconsistent phone and zip formats, which leaves campaign managers with incomplete contacts. Capture cleaned contact info into CRM and add a deal so sales can act same day.