Total Leads
0
All time
New Today
0
Leads added today
Deals Won
0
Closed successfully
Open Repairs
0
Pending delivery
Monthly Revenue
₹0
From invoices
Miners Sold
0
Total units
Total Invoices
0
↗ Click to manage
Recent Leads
No leads yet
Recent Repairs
No repairs yet
Lead Pipeline
Recent Invoices
No invoices yet
Lead Management
No leads found
Inventory / Stock
0 units
No stock data
Repair Center
No repair tickets
Lead Conversion
0%
Avg Deal Size
₹0
Repair Revenue
₹0
This Month Leads
0
Monthly Revenue
Lead Sources
Top Miners by Revenue
No data
New Invoice
SBC-001
Add Miner Item
No items added yet
Serial Number Management
0 serials
Summary
Subtotal₹0
GST (0%)₹0
Grand Total₹0
Advance– ₹0
Balance Due
₹0
Last 3 Invoices
No invoices yet
💬 Quick Message
Templates — Click to Send
📲 Telegram Buy Lead Sync
Send lead details via Telegram message → auto-added to CRM
Not connected
📋 Message Format Guide (click to expand)
📥 Add New Lead:
✏️ Update Existing Lead (by phone):
✏️ Update by name:
✏️ Update multi-line format:
📋 Updatable fields: status, name, phone, city, miner, budget, notes, assignedto
📊 Status values: New, Contacted, Hot, Quoted, Won, Lost
Name: Ramesh Gupta
Phone: 9876543210
City: Jodhpur
Miner: Antminer S21
Budget: 50000
✏️ Update Existing Lead (by phone):
UPDATE LEAD 9876543210 status=Hot notes="Follow up done" budget=75000
✏️ Update by name:
UPDATE LEAD "Ramesh Gupta" status=Won
✏️ Update multi-line format:
UPDATE LEAD 9876543210
Status: Hot
Notes: Very interested
Budget: 80000
📋 Updatable fields: status, name, phone, city, miner, budget, notes, assignedto
📊 Status values: New, Contacted, Hot, Quoted, Won, Lost
Activity log will appear here...
👥 Employees
📊 Google Sheets Sync
Not Connected
Paste your Google Apps Script deployment URL here
📋 How to Set Up (one-time, 5 minutes)
1
Create Google Sheet
Go to sheets.google.com → New Sheet → Name it SB CRM
2
Open Apps Script
In the Sheet → Extensions → Apps Script → Delete existing code → Paste this:
Loading...
3
Deploy as Web App
Click Deploy → New Deployment → Type: Web App → Execute as: Me → Who has access: Anyone → Deploy
4
Paste URL Above
Copy the Web App URL → Paste in the field above → Click Save
🔗 Quick Links
🏢 Company Info
📍 312 Mahadev Nagar, Pal Road, Jodhpur
📧 sharadborana17@gmail.com
🌐 SB Consultancy Mining ERP v2.0
📤 Import / Export Data
Export — Download Your Data
Import — Load Data From File
Click to choose file or drag & drop here
Supports: .json (full backup), .csv (leads)
Supports: .json (full backup), .csv (leads)