Google Sheets Lead Management System Creation

Need Google Sheets Lead Management & Agent Allocation System

I run a Women Health / Ayurveda business and receive leads on WhatsApp.

I need an experienced Google Sheets / MIS Automation expert to create a complete lead management system.

Requirements:

1. Master Lead Sheet
- All leads stored in one master sheet
- Date, Name, Mobile Number, Source, City, Status

2. Agent Allocation System
- Leads can be assigned to different agents
- Agent-wise lead tracking
- Automatic or easy lead allocation

3. Follow-up Tracking
- New Lead
- Contacted
- Follow-up
- Order Confirmed
- Not Interested
- Closed

4. Daily MIS Dashboard
- Total Leads
- Leads Assigned
- Orders Confirmed
- Pending Leads
- Agent-wise Performance Report

5. Duplicate Lead Check
- System should identify duplicate mobile numbers

6. Easy to Use
- MIS Executive should be able to manage the entire system daily without technical knowledge.

Please share:
- Similar projects completed
- Timeline
- Total cost

Budget: Open for discussion.