From Spreadsheets to a Centralized Rep CRM
December 2023 - January 2024 | 3-person rep group | Monday Work Management | Custom CRM | Route Optimization
"What began as five disconnected spreadsheets became a unified, mobile-ready CRM that tracks meetings, routes, and results across every brand."
Pain Points
No multi-brand visibility: the same dealers appeared on different brand spreadsheets with no unified CRM view.
No mass outreach: reps could not email all accounts by brand or track engagement.
Trade-show disorganization: meeting times and notes lived in text threads and notebooks, not a system.
Manual routing: trip planning was done by hand in Google Maps, disconnected from account data.
Solution
Unified CRM in Monday.com: all brand boards linked to a single dealer list.
Mass Email Integration: send ATS files and assets to filtered dealer groups, log opens and deliveries automatically.
Trade Show Tracker: GOA & ATX schedule boards with meeting times, rep assignments, shared notes, and outcomes.
Route Builder: pull dealer addresses from the CRM into eMaps, generate optimized routes, and sync to Google Maps.
Live Dashboards: season-over-season totals, order progress, and active dealer stats visible per brand.
Impact & ROI
Centralized operations: one workspace for dealers, brands, meetings, and follow-ups.
400+ accounts unified across five brands.
Duplicate entry eliminated.
Approximately 400 hours saved per season from faster show prep, route planning, and follow-up.
Improved communication: reps manage updates, notes, and emails from the field.
Scalable foundation: the system can expand as new brands are added.