AI Powered CRM System Template

The skill Copy

Comprehensive Notion CRM template with AI automation for sales pipeline management.

## Overview

This CRM system combines Notion's database capabilities with AI to:
- Automate lead qualification
- Generate follow-up suggestions
- Analyze customer interactions
- Predict deal outcomes
- Create personalized communication templates

## Database Structure

### 1. Companies Database

| Property | Type | Description |
|----------|------|-------------|
| Company Name | Title | Business name |
| Industry | Select | Industry sector |
| Size | Select | Employees (1-10, 11-50, 51-200, 201+) |
| Website | URL | Company website |
| Location | Text | City, Country |
| Contacts | Relation | Link to Contacts DB |
| Deals | Relation | Link to Deals DB |
| Status | Select | Active, Inactive, Prospect |
| Notes | Text | General notes |
| AI Summary | Text | AI-generated company summary |

### 2. Contacts Database

| Property | Type | Description |
|----------|------|-------------|
| Name | Title | Contact name |
| Company | Relation | Link to Companies DB |
| Role | Text | Job title |
| Email | Email | Email address |
| Phone | Phone | Phone number |
| LinkedIn | URL | LinkedIn profile |
| Stage | Select | Lead, Qualified, Customer, Lost |
| Source | Select | Referral, Website, Event, Cold Outreach |
| Last Contact | Date | Last interaction date |
| Next Action | Text | AI-suggested next step |
| Priority | Select | High, Medium, Low |
| Tags | Multi-select | Interests, pain points |
| Interactions | Relation | Link to Interactions DB |

### 3. Deals Database

| Property | Type | Description |
|----------|------|-------------|
| Deal Name | Title | Opportunity name |
| Company | Relation | Link to Companies DB |
| Contact | Relation | Primary contact |
| Value | Number | Deal value ($) |
| Stage | Select | Prospecting, Proposal, Negotiation, Closed Won/Lost |
| Probability | Select | 10%, 25%, 50%, 75%, 90% |
| Expected Close | Date | Target close date |
| Owner | Person | Sales rep |
| Product/Service | Multi-select | What's being sold |
| Notes | Text | Deal details |
| AI Win Prediction | Text | AI analysis of win likelihood |
| Next Steps | Text | AI-suggested actions |

### 4. Interactions Database

| Property | Type | Description |
|----------|------|-------------|
| Subject | Title | Interaction topic |
| Date | Date | When it occurred |
| Contact | Relation | Who you talked to |
| Type | Select | Call, Email, Meeting, Demo |
| Notes | Text | Detailed notes |
| Outcome | Select | Positive, Neutral, Negative |
| AI Summary | Text | AI-generated summary |
| Follow-up | Checkbox | Requires follow-up |
| Follow-up Date | Date | When to follow up |

## AI Automation Workflows

### Lead Qualification

**When**: New contact added

**AI Prompt:**
```
Qualify this lead based on available information:

Company: [Company Name]
Industry: [Industry]
Size: [Company Size]
Contact Role: [Job Title]
Source: [How found]

Provide:
1. Qualification Score (1-10)
2. Ideal Customer Profile Match (%)
3. Key Decision Maker? (Yes/No/Unknown)
4. Budget Likelihood (High/Medium/Low)
5. Timing (Immediate/3-6 months/Long-term)
6. Recommended Next Action
7. Priority Level (High/Medium/Low)
```

### Company Research Summary

**Prompt:**
```
Generate company summary for:

Company: [Name]
Website: [URL]
Industry: [Industry]

Provide:
- Business model overview
- Key products/services
- Target market
- Recent news/developments (if known)
- Potential pain points we can address
- Suggested talking points
- Competitive landscape
```

### Next Action Suggestions

**After each interaction:**

**Prompt:**
```
Based on this interaction, suggest next steps:

Contact: [Name] at [Company]
Interaction Type: [Call/Email/Meeting]
Date: [Date]
Notes: [Interaction notes]
Current Stage: [Stage]
Deal Value: [Amount]

Suggest:
1. Specific Next Action (with timeline)
2. Communication Approach
3. Key Topics to Cover
4. Resources to Share
5. Success Metrics
6. Potential Objections to Address
```

### Email Template Generation

**Prompt:**
```
Generate personalized email for:

To: [Contact Name] at [Company]
Purpose: [Follow-up/Proposal/Check-in/Demo invite]
Context: [Previous interaction summary]
Goal: [What you want to achieve]

Email should:
- Reference previous conversation
- Provide value/insight
- Include clear call-to-action
- Be 150-200 words
- Professional but warm tone
```

### Deal Win Prediction

**Prompt:**
```
Analyze this deal's likelihood to close:

Deal: [Name]
Value: [Amount]
Stage: [Current stage]
Time in Pipeline: [Days]
Contact Engagement: [High/Medium/Low]
Decision Maker Access: [Yes/No]
Competition: [Known competitors]
Budget Confirmed: [Yes/No]
Timeline: [Expected close date]
Recent Activity: [Summary]

Provide:
1. Win Probability (0-100%)
2. Key Strengths
3. Risk Factors
4. Actions to Improve Chances
5. Red Flags
6. Recommended Timeline
```

### Meeting Preparation

**Prompt:**
```
Prepare briefing for upcoming meeting:

Contact: [Name, Title]
Company: [Name, Industry]
Meeting Type: [Discovery/Demo/Negotiation]
Previous Interactions: [Summary]
Deal Stage: [Stage]
Objectives: [Your goals]

Provide:
- Company context refresher
- Key talking points
- Questions to ask
- Objections they might raise
- Value propositions to emphasize
- Success metrics to discuss
- Next steps to propose
```

## Views

### Contacts: Active Pipeline
**Filter**: Stage is not "Lost"
**Sort**: Priority (High → Low), Last Contact (Old → New)
**Group**: Stage
**Properties**: Name, Company, Stage, Last Contact, Next Action, Priority

### Contacts: Needs Follow-up
**Filter**: Last Contact is more than 14 days ago AND Stage is not "Customer" or "Lost"
**Sort**: Priority, Last Contact
**Properties**: Name, Company, Last Contact, Next Action

### Deals: Active Opportunities
**Filter**: Stage is not "Closed Won" or "Closed Lost"
**Sort**: Expected Close Date
**Group**: Stage
**Properties**: Deal Name, Company, Value, Probability, Expected Close, Owner

### Deals: This Quarter
**Filter**: Expected Close is within this quarter
**Sort**: Value (High → Low)
**Properties**: All

### Interactions: Recent Activity
**Filter**: Date is within last 30 days
**Sort**: Date (New → Old)
**Group**: Type
**Properties**: Subject, Contact, Company, Date, Outcome

## AI Usage Examples

### Example 1: New Lead Processing

**Scenario**: Sales rep meets prospect at conference

**Workflow:**
1. Add new contact with basic info
2. Use AI to qualify lead:
   ```
   Qualify this lead:
   Name: Sarah Chen
   Company: TechStart Inc
   Industry: SaaS
   Size: 50 employees
   Role: VP Product
   Source: Conference
   
   AI Output:
   - Score: 8/10
   - ICP Match: 85%
   - Decision Maker: Yes
   - Budget: High likelihood
   - Timing: 3-6 months
   - Next Action: Send personalized email within 48h
   - Priority: High
   ```

3. Generate follow-up email:
   ```
   Email for conference follow-up...
   
   AI Output:
   Subject: Great connecting at [Conference]
   
   Hi Sarah,
   
   It was great meeting you at [Conference] yesterday...
   [Personalized content]
   ```

### Example 2: Deal Review

**Scenario**: Weekly pipeline review

**Prompt:**
```
Analyze this deal's status:

Deal: Enterprise License - Acme Corp
Value: $50,000
Stage: Negotiation
Days in Pipeline: 45
Last Contact: 7 days ago
Decision Maker: Met CEO once
Competition: Known - CompetitorX
Budget: Confirmed
Close Date: 30 days

AI Output:
- Win Probability: 65%
- Strengths: Budget confirmed, clear pain point
- Risks: Long silence, competitor has incumbent advantage
- Actions: 1) Schedule call this week, 2) Address concerns, 3) Provide case study
- Red Flags: CEO hasn't responded to last two emails
- Timeline: Push close date by 2 weeks, more realistic
```

### Example 3: Customer Health Check

**Prompt:**
```
Assess customer health:

Customer: Beta Industries
Contract Value: $30K/year
Last Interaction: 60 days ago
Product Usage: Declining
Support Tickets: 3 in last month
Renewal Date: 90 days

AI Output:
- Health Score: 4/10 - At Risk
- Warning Signs: Low engagement, support issues, radio silence
- Action Plan:
  1. Immediate: Schedule check-in call
  2. Week 1: Address support issues
  3. Week 2: Executive business review
  4. Week 4: Present renewal options
- Talking Points: ROI, new features, success stories
- Risk: 40% chance of non-renewal
```

## Formulas

### Days Since Last Contact
```
dateBetween(now(), prop("Last Contact"), "days")
```

### Deal Health Indicator
```
if(prop("Days Since Last Contact") > 14, "🔴 Urgent",
  if(prop("Days Since Last Contact") > 7, "🟡 Follow-up",
    "🟢 Active"))
```

### Weighted Pipeline Value
```
prop("Value") * (prop("Probability") / 100)
```

## Best Practices

### 1. Daily Routine
- Review "Needs Follow-up" view
- Use AI to generate follow-up actions
- Update interaction notes
- Check deal health indicators

### 2. Weekly Routine
- Pipeline review with AI analysis
- Update deal stages and probabilities
- Plan next week's priorities
- Generate reports

### 3. Data Hygiene
- Update contact info regularly
- Archive lost deals
- Merge duplicate entries
- Tag contacts consistently

### 4. AI Integration Tips

**Do:**
- Provide context for better AI suggestions
- Review and customize AI output
- Build prompt templates
- Track which prompts work best

**Don't:**
- Use AI output without review
- Share sensitive client data carelessly
- Rely solely on AI predictions
- Ignore your intuition

## Reporting

### Monthly Sales Report Prompt
```
Generate sales summary for [Month]:

New Deals: [Count]
Closed Won: [Count, Total $]
Closed Lost: [Count]
Pipeline Value: [Total $]
Average Deal Size: [Amount]
Conversion Rate: [%]
Top Performing Rep: [Name]

Provide:
- Executive summary
- Key wins and losses
- Trends observed
- Recommendations for next month
- Areas needing attention
```

## Getting Started

### Week 1: Setup
1. Duplicate this template
2. Customize property options
3. Import existing contacts
4. Test AI prompts

### Week 2: Adoption
1. Train team on system
2. Establish data entry standards
3. Create AI prompt library
4. Set up automations

### Week 3: Optimization
1. Review what's working
2. Refine AI prompts
3. Add custom views
4. Integrate with other tools

## Advanced Features

### Automated Lead Scoring

Create formula combining:
- Company size score
- Industry match
- Role importance
- Engagement level
- Time in pipeline

### Integration Ideas
- Email sync (Gmail/Outlook)
- Calendar integration
- Slack notifications
- Zapier automations
- LinkedIn data enrichment

## Conclusion

This AI-powered CRM helps sales teams:
- Spend less time on admin
- Make data-driven decisions
- Personalize customer interactions
- Never miss follow-ups
- Close more deals

Start with basic features, then gradually incorporate AI automation as your team gets comfortable with the system.

How to install it Copy

1. Open the tool and start a new conversation, project or template.
2. Paste the text below wherever the tool keeps standing instructions
   — usually called system prompt, instructions, or persona.
3. Save it so it applies to every run rather than a single message.

Did it work for you?

Where it came from

2025 Anfernee