4-Agent CRM Automation System
A complete CRM automation built on Google Sheets, Gmail, Calendly, and OpenRouter. Four AI agents handle every stage of the pipeline — from lead intake to no-show recovery — running 24/7 for approximately $5/month.
The Problem
Business owners face an impossible choice: serve existing clients or nurture new leads. Every hour spent on follow-ups is an hour not spent on delivery. A single missed follow-up on a $10,000 deal is $10,000 lost — and most businesses miss dozens every month.
Architecture
graph LR
A[New Lead] --> B[CRM Agent]
B --> C[Follow-up Agent]
C --> D{Booked?}
D -->|Yes| E[Concierge Agent]
D -->|No| C
E --> F{Showed up?}
F -->|Yes| G[Sales Call]
F -->|No| H[No-Show Agent]
H --> C
Each agent is a separate n8n workflow that reads from and writes to the same Google Sheet — your single source of truth. No lead falls through the cracks because every agent knows exactly where every prospect stands.
The Four Agents
Agent 1: CRM Agent — The Foundation
What it does: Processes every new lead automatically. When someone fills out a form, sends an email, or gets added manually, this agent creates a structured entry in your Google Sheets CRM — contact details, source, timestamp, status, and any context available.
Why it matters: Without a clean, centralized record, everything else breaks. This agent ensures that from the moment a lead exists, the system knows about it.
CRM columns:
| Column | Purpose |
|---|---|
| Name | Lead’s full name |
| Contact email | |
| Company | Company name |
| Source | Where the lead came from |
| Status | New / Contacted / Booked / Closed / Lost |
| Notes | AI-generated context |
| Last Contact | Date of most recent touchpoint |
| Next Action | What happens next and when |
Agent 2: Follow-up Agent — The Closer
What it does: Sends 3 personalized follow-up emails at timed intervals. Each email is AI-generated based on the lead’s specific data — not a mail-merge template, but actual personalized content that references their industry, company size, and stated pain points.
The sequence:
| Timing | Content Strategy | |
|---|---|---|
| 1 | Immediate | Value-first introduction. Lead with insight, not a pitch. |
| 2 | +2 days | Share a relevant case study or industry insight. |
| 3 | +5 days | Final direct ask. Clear call-to-action with urgency. |
How AI personalization works: The AI reads the lead’s CRM data (company name, industry, pain point) and generates each email to sound like it was written by a human who did 10 minutes of research. At scale, this is impossible manually. With AI, every lead gets the same quality of attention whether you have 10 or 1,000.
Agent 3: Concierge Agent — The Welcomer
What it does: Monitors Calendly for new bookings. When a lead books a call, it instantly:
- Updates the CRM status to “Booked”
- Sends a confirmation email with prep materials
- Notifies the salesperson with full lead context
Why it matters: The gap between “booked” and “attended” is where many deals die. This agent fills that gap with professionalism — the lead feels expected and valued.
Agent 4: No-Show Agent — The Recovery System
What it does: Detects when a lead books but doesn’t show. Sends a re-engagement email (“I noticed we missed each other — want to reschedule?”) and resets the follow-up sequence.
Reality check: No-show rates for sales calls range from 20-40%. Without this agent, those leads are lost. With it, a significant portion rebook and eventually convert.
Implementation Guide
Step 1: Set Up the CRM (15 minutes)
Step 2: Build the Follow-up Agent (1 hour)
In n8n, create a workflow:
- Trigger: New row in Google Sheet (or webhook from your web form)
- AI Node: OpenRouter generates a personalized email based on the lead’s data
- Gmail Node: Sends the email
- Update Sheet: Marks status as “Contacted” and logs the timestamp
- Wait Node: 2-day delay
- Repeat: Send email 2 (case study), wait 3 days, send email 3 (direct ask)
Step 3: Add Calendly Integration (30 minutes)
Create a second workflow:
- Trigger: Calendly webhook fires when someone books
- Find lead in Sheet: Match by email address
- Update status: Change to “Booked”
- Send notification: Slack or email with full lead context
Step 4: Run and Iterate
AI Nurturing Sequences
For leads not yet ready to buy, the system runs AI-personalized nurture sequences:
| Week | Email Type | AI Personalization |
|---|---|---|
| 1 | Value insight | Industry-specific statistic or trend |
| 2 | Case study | Matched to lead’s company size and industry |
| 3 | Tool or resource | Free template relevant to their pain point |
| 4 | Soft ask | “Would a 15-minute call make sense?” |
| 6 | Re-engagement | New angle based on recent industry news |
| 8 | Final value | “Here’s what companies like yours achieved” |
| Aspect | Traditional Drip | AI Nurturing |
|---|---|---|
| Content | Same email to everyone | Personalized per lead’s context |
| Schedule | Fixed intervals | Adaptive based on engagement |
| Learning | No adjustment | Adjusts on opens, clicks, replies |
| Quality | Generic templates | Industry-matched content |
The system watches for engagement signals:
- Lead opens email within an hour? Move up the next email — they’re interested.
- No opens in 2 weeks? Pause, then re-engage with a different angle.
- Lead clicks a pricing link? Alert the salesperson immediately — hot lead.
This uses n8n’s wait nodes combined with webhook triggers from your email tool.
Proposal Generator
After a sales call, AI turns transcripts into proposals in minutes, not hours:
graph LR
A[Sales Call] --> B[Fathom.ai Records]
B --> C[Transcript Cleanup]
C --> D[AI Extracts 18+ Fields]
D --> E[Populates Google Slides]
E --> F[Human Reviews 2-5 min]
F --> G[Send to Client]
| Metric | Value |
|---|---|
| Proposal creation time | 2-4 hours |
| Proposals per week | 3-5 |
| Consistency | Variable quality |
| Cost per proposal | Your hourly rate |
| Metric | Value |
|---|---|
| Proposal creation time | 2-5 minutes + review |
| Proposals per week | 15-20 |
| Consistency | Template-enforced |
| Cost per proposal | ~$0.02 per AI extraction |
Results
| Metric | Before | After |
|---|---|---|
| Lead response time | Hours to days | Immediate (24/7) |
| Forgotten follow-ups | Frequent | Zero |
| Scalability | Limited by headcount | Handles 10 or 1,000 identically |
| Pipeline visibility | Manual tracking | Real-time CRM status |
| Proposal turnaround | 2-4 hours | 2-5 minutes |
| No-show recovery | Lost leads | Automated re-engagement |
Cost Breakdown
| Component | Cost |
|---|---|
| Google Sheets | Free |
| Gmail | Free |
| Calendly | Free |
| n8n (self-hosted) | Free |
| OpenRouter (AI) | ~$5/mo |
| Total | ~$5/month |