CRM Onboarding Workflow
Overview
Systematically set up a CRM (HubSpot, Salesforce, Pipedrive, or ClickUp) for a new team or business: data migration strategy, field mapping, pipeline definition, team onboarding, user permissions, and go-live checklist.
When to Use
- "Set up a CRM for my team"
- "Import customer data into CRM"
- "I need a sales pipeline defined"
- "Onboard my team to HubSpot"
CRM Selection Guide
Tier: Small Business (1-10 users)
| CRM |
Price |
Best For |
Key Limits |
| HubSpot Free |
$0 |
Startups, solopreneurs |
1,000,000 contacts, 1,000 emails/day |
| Freshsales Free |
$0 |
Sales teams, simple needs |
10 users, 100MB storage |
| Agile CRM |
$8.99/user |
All-in-one small biz |
1000 contacts, email + phone |
Tier: Growth (10-100 users)
| CRM |
Price |
Best For |
Key Limits |
| Pipedrive |
$14.90/user |
Sales pipeline, deal management |
Unlimited deals, no limits on records |
| ActiveCampaign |
$21/user |
Marketing + Sales automation |
15,000 contacts |
| HubSpot Starter |
$45 |
Sales + Marketing + Service |
1,000 contacts, limited features |
Tier: Enterprise (100+ users)
| CRM |
Price |
Best For |
Key Limits |
| Salesforce Essentials |
$25/user |
Full enterprise features |
All Salesforce capabilities |
| Salesforce Unlimited |
$300+ |
Custom enterprise workflows |
Everything + support |
| Monday CRM |
$22-25/user |
Project-based selling |
Unlimited boards, 5GB storage |
Phase 1: Planning (Week 1)
1. Define Your Sales Process
Map your current sales workflow before touching the CRM:
Lead Source → Lead Capture → Qualification → Demo/Meet → Proposal → Negotiation → Closed Won/Lost
Document:
- Average deal size per stage
- Time spent in each stage
- Common objections by stage
- Key handoff points between team members
2. Data Migration Strategy
Inventory all data sources:
| Source |
Type |
Volume |
Quality |
Migration |
| Excel/CSV |
Contacts, deals |
1,200 rows |
Low (duplicates) |
Clean + Import |
| Email |
Lead captures |
Ongoing |
Good |
Auto-sync |
| LinkedIn |
Prospects |
500 |
Medium |
Manual import |
| Previous CRM |
All data |
5,000 records |
Variable |
API export |
Critical Decision: Start with clean data or bring everything?
- Clean data only: Import only contacts with valid emails and recent activity (last 12 months)
- Full import: All historical data, requires deduplication
3. Field Mapping Template
Use the xlsx tool to design your field mapping:
| Source Field |
Target Field |
Data Type |
Required |
Notes |
Contact Name |
contact.name |
string |
yes |
Split into first/last |
Email |
contact.email |
email |
yes |
Validate format |
Phone |
contact.phone |
phone |
no |
Standardize to E.164 |
Company |
account.name |
string |
yes |
Create if new |
Job Title |
contact.title |
string |
no |
|
Source |
lead.source |
picklist |
no |
Map to standard values |
Lead Status |
lead.status |
picklist |
yes |
(new, working, closed) |
Last Contact |
activity.date |
date |
no |
|
Phase 2: Setup (Week 2)
1. Pipeline Configuration
Create deal stages with probability and quota:
| Stage |
Probability |
Quota % |
Description |
| Qualify to Buy |
10% |
0 |
Initial interest confirmed |
| Meeting Scheduled |
20% |
0 |
Demo or call booked |
| Demo Given |
35% |
0 |
Product shown, questions answered |
| Proposal Sent |
55% |
0 |
Custom quote sent |
| Negotiation |
75% |
0 |
Back-and-forth on terms |
| Contract Sent |
90% |
0 |
Final agreement for e-signature |
| Closed Won |
100% |
100 |
Payment received |
| Closed Lost |
0% |
0 |
Lost to competitor/price/no fit |
2. Team Onboarding
Each user gets:
- Login credentials (set up by admin)
- Role-based access level (see Permissions matrix below)
- 30-min platform walkthrough
- Assigned territory/segments
- Test record in each pipeline stage (practice only)
3. Automation Rules
Set up 3 essential automations for day one:
Automation 1: New Lead Assignment
- Trigger: New lead created
- Action: Assign to sales rep (round-robin)
- Action: Send notification email to rep
Automation 2: Deal Stage Alerts
- Trigger: Deal stage change to "Demo Given" or later
- Action: Notify sales manager
- Action: Add to weekly forecast report
Automation 3: Stale Lead Reminder
- Trigger: Lead not contacted within 2 hours
- Action: Send reminder to assigned rep
- Action: Escalate to manager after 24 hours
4. Email Templates
Pre-build these templates so reps can send immediately:
- Initial outreach (from lead assignment workflow)
- Meeting follow-up (with calendar link and deck)
- Proposal delivery (with pricing tiers)
- Win announcement (internal: notify ops, sales ops, success)
- Loss follow-up (with feedback request)
Phase 3: Go-Live (Week 3)
1. Permissions Matrix
| Role |
Records Access |
Features |
| Sales Rep |
Own + team leads |
Create/edit deals, contacts, activities |
| Sales Manager |
All team + own |
Forecasting, reports, team management |
| Operations |
All records |
Import/export, field management, workflows |
| Admin |
Everything |
User management, billing, integrations |
| Read-Only |
Assigned accounts |
Viewing only |
2. Reporting Dashboard
Set up the 4 essential dashboards everyone needs:
- Pipeline Health: Deals by stage, weighted pipeline value
- Activity Volume: Calls, emails, meetings booked (per rep)
- Conversion Rates: Lead→MQL→SQL→Win rates
- Forecast: Projected revenue by quarter (weighted deals)
3. Integration Checklist
Common Pitfalls
Data migration chaos — importing everything including duplicates, invalid emails, and outdated records. Clean first, migrate second.
Over-configuration — building every possible field and view upfront. Start minimal (5-7 key fields) and expand based on usage patterns.
Skipping user training — reps won't use the CRM if they don't know how. Schedule 1-on-1 walkthroughs for each user.
No ownership of cleanup — without an admin, the CRM becomes a data graveyard. Assign a CRM admin (rotates monthly).
Wrong access levels — giving everyone full access to everything creates privacy risk and data chaos. Use territory/role-based access.
Too many pipelines — one pipeline with clear stages. Multiple pipelines confuse reporting and forecasting.
No data hygiene rules — without clear rules for required fields, data quality degrades rapidly. Make email required on all contacts.
Verification Checklist
1---2name: crm-onboarding-workflow3description: Use when setting up CRM. Data import, team onboarding.4license: MIT5---67# CRM Onboarding Workflow89## Overview10Systematically set up a CRM (HubSpot, Salesforce, Pipedrive, or ClickUp) for a new team or business: data migration strategy, field mapping, pipeline definition, team onboarding, user permissions, and go-live checklist.1112## When to Use13- "Set up a CRM for my team"14- "Import customer data into CRM"15- "I need a sales pipeline defined"16- "Onboard my team to HubSpot"1718## CRM Selection Guide1920### Tier: Small Business (1-10 users)21| CRM | Price | Best For | Key Limits |22|-----|-------|----------|-----------|23| HubSpot Free | $0 | Startups, solopreneurs | 1,000,000 contacts, 1,000 emails/day |24| Freshsales Free | $0 | Sales teams, simple needs | 10 users, 100MB storage |25| Agile CRM | $8.99/user | All-in-one small biz | 1000 contacts, email + phone |2627### Tier: Growth (10-100 users)28| CRM | Price | Best For | Key Limits |29|-----|-------|----------|-----------|30| Pipedrive | $14.90/user | Sales pipeline, deal management | Unlimited deals, no limits on records |31| ActiveCampaign | $21/user | Marketing + Sales automation | 15,000 contacts |32| HubSpot Starter | $45 | Sales + Marketing + Service | 1,000 contacts, limited features |3334### Tier: Enterprise (100+ users)35| CRM | Price | Best For | Key Limits |36|-----|-------|----------|-----------|37| Salesforce Essentials | $25/user | Full enterprise features | All Salesforce capabilities |38| Salesforce Unlimited | $300+ | Custom enterprise workflows | Everything + support |39| Monday CRM | $22-25/user | Project-based selling | Unlimited boards, 5GB storage |4041## Phase 1: Planning (Week 1)4243### 1. Define Your Sales Process44Map your current sales workflow before touching the CRM:45```46Lead Source → Lead Capture → Qualification → Demo/Meet → Proposal → Negotiation → Closed Won/Lost47```4849Document:50- Average deal size per stage51- Time spent in each stage52- Common objections by stage53- Key handoff points between team members5455### 2. Data Migration Strategy56Inventory all data sources:57| Source | Type | Volume | Quality | Migration |58|--------|------|--------|---------|-----------|59| Excel/CSV | Contacts, deals | 1,200 rows | Low (duplicates) | Clean + Import |60| Email | Lead captures | Ongoing | Good | Auto-sync |61| LinkedIn | Prospects | 500 | Medium | Manual import |62| Previous CRM | All data | 5,000 records | Variable | API export |6364**Critical Decision**: Start with clean data or bring everything?65- **Clean data only**: Import only contacts with valid emails and recent activity (last 12 months)66- **Full import**: All historical data, requires deduplication6768### 3. Field Mapping Template69Use the `xlsx` tool to design your field mapping:7071| Source Field | Target Field | Data Type | Required | Notes |72|-------------|-------------|-----------|----------|-------|73| `Contact Name` | `contact.name` | string | yes | Split into first/last |74| `Email` | `contact.email` | email | yes | Validate format |75| `Phone` | `contact.phone` | phone | no | Standardize to E.164 |76| `Company` | `account.name` | string | yes | Create if new |77| `Job Title` | `contact.title` | string | no | |78| `Source` | `lead.source` | picklist | no | Map to standard values |79| `Lead Status` | `lead.status` | picklist | yes | (new, working, closed) |80| `Last Contact` | `activity.date` | date | no | |8182## Phase 2: Setup (Week 2)8384### 1. Pipeline Configuration85Create deal stages with probability and quota:8687| Stage | Probability | Quota % | Description |88|-------|-------------|---------|-------------|89| Qualify to Buy | 10% | 0 | Initial interest confirmed |90| Meeting Scheduled | 20% | 0 | Demo or call booked |91| Demo Given | 35% | 0 | Product shown, questions answered |92| Proposal Sent | 55% | 0 | Custom quote sent |93| Negotiation | 75% | 0 | Back-and-forth on terms |94| Contract Sent | 90% | 0 | Final agreement for e-signature |95| Closed Won | 100% | 100 | Payment received |96| Closed Lost | 0% | 0 | Lost to competitor/price/no fit |9798### 2. Team Onboarding99Each user gets:100- Login credentials (set up by admin)101- Role-based access level (see Permissions matrix below)102- 30-min platform walkthrough103- Assigned territory/segments104- Test record in each pipeline stage (practice only)105106### 3. Automation Rules107Set up 3 essential automations for day one:108109**Automation 1: New Lead Assignment**110- Trigger: New lead created111- Action: Assign to sales rep (round-robin)112- Action: Send notification email to rep113114**Automation 2: Deal Stage Alerts**115- Trigger: Deal stage change to "Demo Given" or later116- Action: Notify sales manager117- Action: Add to weekly forecast report118119**Automation 3: Stale Lead Reminder**120- Trigger: Lead not contacted within 2 hours121- Action: Send reminder to assigned rep122- Action: Escalate to manager after 24 hours123124### 4. Email Templates125Pre-build these templates so reps can send immediately:1261. **Initial outreach** (from lead assignment workflow)1272. **Meeting follow-up** (with calendar link and deck)1283. **Proposal delivery** (with pricing tiers)1294. **Win announcement** (internal: notify ops, sales ops, success)1305. **Loss follow-up** (with feedback request)131132## Phase 3: Go-Live (Week 3)133134### 1. Permissions Matrix135| Role | Records Access | Features |136|------|----------------|----------|137| Sales Rep | Own + team leads | Create/edit deals, contacts, activities |138| Sales Manager | All team + own | Forecasting, reports, team management |139| Operations | All records | Import/export, field management, workflows |140| Admin | Everything | User management, billing, integrations |141| Read-Only | Assigned accounts | Viewing only |142143### 2. Reporting Dashboard144Set up the 4 essential dashboards everyone needs:145- **Pipeline Health**: Deals by stage, weighted pipeline value146- **Activity Volume**: Calls, emails, meetings booked (per rep)147- **Conversion Rates**: Lead→MQL→SQL→Win rates148- **Forecast**: Projected revenue by quarter (weighted deals)149150### 3. Integration Checklist151- [ ] Email syncing (Gmail/Office 365) — sync sent/received emails as activities152- [ ] Calendar sync — meetings appear in CRM, auto-log153- [ ] Phone system (if using) — log calls automatically with recordings154- [ ] Email marketing tool (Mailchimp, HubSpot, ActiveCampaign)155- [ ] Website forms → CRM lead capture156- [ ] Payment processor → deal won trigger157158## Common Pitfalls1591601. **Data migration chaos** — importing everything including duplicates, invalid emails, and outdated records. Clean first, migrate second.1611622. **Over-configuration** — building every possible field and view upfront. Start minimal (5-7 key fields) and expand based on usage patterns.1631643. **Skipping user training** — reps won't use the CRM if they don't know how. Schedule 1-on-1 walkthroughs for each user.1651664. **No ownership of cleanup** — without an admin, the CRM becomes a data graveyard. Assign a CRM admin (rotates monthly).1671685. **Wrong access levels** — giving everyone full access to everything creates privacy risk and data chaos. Use territory/role-based access.1691706. **Too many pipelines** — one pipeline with clear stages. Multiple pipelines confuse reporting and forecasting.1711727. **No data hygiene rules** — without clear rules for required fields, data quality degrades rapidly. Make email required on all contacts.173174## Verification Checklist175176- [ ] Sales process documented (5-7 stages with clear definitions)177- [ ] Data sources inventoried (3-5 sources mapped)178- [ ] Field mapping completed (core fields + custom fields)179- [ ] Pipeline configured with stages, probabilities, quotas180- [ ] 3 automations set up (lead assignment, stage alerts, stale reminders)181- [ ] Email templates pre-built (5 core templates)182- [ ] User roles defined with permissions matrix183- [ ] 4 reporting dashboards configured184- [ ] 5 core integrations verified185- [ ] CRM admin assigned with monthly cleanup schedule