Automation Case Study

Loan Consultant CRM Automation: Building a Lead Pipeline That Works While You Sleep

A home loan DSA in Pune with 3 relationship managers was manually managing 150+ monthly leads across bank portals, JustDial, and referrals. Manual follow-up meant many leads went cold between contact attempts. We built an automated CRM with a qualification flow and 30-day nurture sequence.

20 April 2026Pune, Maharashtra, IndiaFinance & Fintech
Loan Consultant CRM Automation: Building a Lead Pipeline That Works While You Sleep

Client

Home loan and personal loan DSA

Team size

3 relationship managers, 150+ monthly leads

Industry

Finance & Fintech

Build

Multi-source lead intake → credit profile qualification → RM assignment → 30-day WhatsApp nurture → document collection → disbursement tracking

Leads going cold between manual follow-up attempts and no pipeline visibility

The DSA received leads from HDFC, SBI, Bajaj Finance portals, JustDial, and referrals simultaneously. Three RMs managed their individual leads in personal WhatsApp — no shared view, no pipeline, no systematic follow-up. Leads that didn't convert on the first call sat untouched. Qualified leads that needed document collection were reminded verbally — documents often arrived weeks late, delaying disbursement and commission.

Centralised CRM with WhatsApp qualification, RM assignment, and automated nurture

We built a centralised lead intake into EspoCRM with automated WhatsApp qualification. Every lead receives a 5-question qualification flow (loan type, amount, employment type, existing EMIs, property status for home loans). Responses score and route the lead to the right RM. A 30-day nurture sequence maintains contact with warm leads. Document collection requests fire automatically when the RM marks a lead as "document stage".

Documented delivery scope

What this case study can evidence

This case study is based on the delivery scope documented on this page: multi-source lead intake → credit profile qualification → rm assignment → 30-day whatsapp nurture → document collection → disbursement tracking for a home loan and personal loan dsa in Pune, Maharashtra, India. It is an implementation record, not a promise that another business will see the same outcome.

Workflow evidence

The recorded build includes unified lead intake from all sources, whatsapp qualification flow, credit profile scoring and rm assignment, 30-day whatsapp nurture sequence, document collection automation, disbursement and referral follow-up. Each step is shown below so readers can see the stated handoffs rather than infer hidden work.

Tools and ownership

The listed tools support the defined workflow: EspoCRM for lead pipeline, rm assignment, document stage tracking; WhatsApp Business API for qualification flow, nurture sequence, document requests; n8n for scoring logic, routing, sequence orchestration; Google Sheets for bank portal lead import and rm performance reporting; Webhooks for bank dsa portal integrations. Final operating ownership remains with the client team.

How to read results

The results section reports only the stated lead response time and pipeline visibility and document collection speed and lead wastage. Context, offer quality, team response, and adoption affect any future implementation.

Workflow Built

1

Unified lead intake from all sources

Bank portals, JustDial, website, and referral entries all route to EspoCRM via n8n webhooks and API connectors. Each lead is tagged with source, loan type interest, and entry timestamp.

2

WhatsApp qualification flow

Every new lead receives a 5-question WhatsApp qualification: (1) Loan type (home/personal/business/car), (2) Loan amount required, (3) Employment type (salaried/self-employed), (4) Monthly income range, (5) Existing EMI commitments.

3

Credit profile scoring and RM assignment

Responses generate a suitability score. High-suitability leads go to senior RMs. Mid-tier leads go to junior RMs. Low-suitability leads (income mismatch, high existing EMI) enter a long-term nurture sequence.

4

30-day WhatsApp nurture sequence

Leads in consideration phase receive: Day 3 — EMI calculator and current rate snapshot. Day 7 — eligibility guide for their loan type. Day 14 — customer testimonial from a similar profile. Day 21 — special processing offer. Day 30 — final outreach from RM.

5

Document collection automation

When RM moves a lead to "document stage" in CRM, a WhatsApp message fires automatically with a checklist of required documents and upload instructions. Reminders fire at day 3 and day 7 if documents are not received.

6

Disbursement and referral follow-up

Post-disbursement, the borrower receives a congratulations message and a referral request. Referrals are tracked back to the original contact's CRM record for incentive calculation.

Results

Lead response time

All leads receive immediate WhatsApp contact vs. previous average of 4–8 hours

Pipeline visibility

Full real-time view of all leads by stage for all 3 RMs in one CRM

Document collection speed

Automated requests and reminders reduced average document collection delay

Lead wastage

Warm leads previously lost between manual follow-ups are now nurtured systematically over 30 days

FAQs

Can this system work across multiple lenders (HDFC, SBI, Bajaj, ICICI simultaneously)?+

Yes. The CRM tracks which lender's product each lead is being processed for. n8n routes document requests to lender-specific checklists. If you offer multiple lender products, the RM can switch a lead to a different lender product within the CRM without losing history.

Is this compliant with RBI DSA regulations?+

The automation handles operational tasks (scheduling, documentation, communication) — it does not make credit decisions or provide financial advice, which remain with the licensed RM. Ensure all WhatsApp communications include required regulatory disclosures for financial communications, which we configure as part of message templates.

Can the qualification flow detect a lead that is not eligible at all and stop wasting RM time?+

Yes. The qualification flow includes hard disqualification logic: income below minimum threshold, no income documentation possible, or loan requirement outside any lender's product range. Disqualified leads receive a polite message explaining ineligibility and are removed from the RM pipeline, saving time for viable leads.

How do we track which marketing channel is producing the highest quality leads?+

Source attribution is captured at lead entry (which portal, which campaign, which referrer). The CRM can report conversion rate by source — giving you clear data on which acquisition channel produces leads that actually disburse.

Can this integrate with CIBIL or bureau check APIs?+

Integration with credit bureaus requires a registered FI or DSA agreement with that bureau. If your DSA has this access, we can integrate a bureau pull into the qualification flow. This is an advanced implementation — we assess feasibility and compliance requirements during discovery.

Want a Workflow Like This?

We can map your lead flow, identify manual delays, and build the automation layer that makes follow-up instant.

Book a Free Automation Audit
Chat on WhatsApp