Build a Mobile-Friendly C2C Used Car Lead Matching System with WhatsApp Alerts & Smart Automation
Budget: ₹12,500 – ₹37,500 INR
PROJECT DESCRIPTION
We run a Bangalore-based used car business called Renew Cars and need a lean, mobile-first C2C lead matching system that connects buyers and sellers of used cars through Google Sheets, Forms, and WhatsApp alerts.
⸻
OBJECTIVE
To automate the collection of buyer and seller leads, intelligently match them based on car preferences and budget, and notify buyers via WhatsApp when a match is found — while keeping the process mobile-optimized and lightweight.
⸻
SCOPE OF WORK
1. Lead Capture Forms
• Create two mobile-friendly forms (Google Forms or Tally.so):
• Buyer Interest Form
• Seller Car Submission Form
• Fields should include car model, year, fuel type, kms, asking price, photos (for seller), and budget and preferences (for buyers)
2. Lead Database Setup
• Google Sheet setup with:
• Buyer Watchlist Sheet
• Seller Leads Sheet
• Matching Logic Sheet to automatically match leads by model and budget
3. Matching Logic with Smart Filters
• Implement keyword-based model matching (e.g., “i20”, “Swift ZXi”)
• Set price buffer logic (±10% budget)
• Include location filter or pin code if needed
• Add a match score column out of 100
• Add urgency/star rating column for lead priority
• Use conditional formatting to color-code high-priority leads
4. WhatsApp Notification Integration
• Use AiSensy, Interakt, or Twilio
• Automatically trigger WhatsApp alerts to matched buyers when a new seller car is submitted
• Help with WhatsApp Business API setup and message template approvals
• Example message:
“New Match: 2019 Honda City VX CVT, 40K km – ₹8.4L
Verified by Renew Cars. Interested? Reply YES.”
5. Inspection Flow Setup
• Internal Google Form for inspection checklist used by the field team
• Fields to include: tyre condition, service history, scratches, engine noise, rating
• Auto-store seller documents and photos in Drive folders (linked via Sheet)
6. Booking and Payment Integration
• Integrate Razorpay or UPI link to collect token amount from buyers
• Optional: Set up a test drive or inspection scheduler using Google Calendar or Calendly
7. Admin Dashboard
• Use Google Data Studio (or Google Sheets dashboard view) to display:
• Total new buyer leads
• New seller cars
• Match count
• Most requested models
• Unmatched hot leads
8. Weekly Match Report Generator
• Sheet that auto-logs:
• Matches found this week
• Buyer requests with no matches
• Recommendations for what to procure
• Unclosed deals or stale leads
⸻
OPTIONAL ADDITIONS (Include in Scope)
• Auto-tagging buyer preferences in Sheet
• Flag rare or niche keywords like “Hybrid” or “Electric”
• Deal Tracker Sheet:
Car ID | Buyer Name | Seller Name | Token Paid | Status | Remarks
• Manual override: Add/remove leads from alerts manually
• Instructions guide (no video needed) for team to use the system on mobile
⸻
PREFERRED TOOLS
• Google Forms or Tally.so
• Google Sheets
• AiSensy or Interakt or Twilio (for WhatsApp alerts)
• Google Data Studio
• Razorpay (optional)
We run a Bangalore-based used car business called Renew Cars and need a lean, mobile-first C2C lead matching system that connects buyers and sellers of used cars through Google Sheets, Forms, and WhatsApp alerts.
⸻
OBJECTIVE
To automate the collection of buyer and seller leads, intelligently match them based on car preferences and budget, and notify buyers via WhatsApp when a match is found — while keeping the process mobile-optimized and lightweight.
⸻
SCOPE OF WORK
1. Lead Capture Forms
• Create two mobile-friendly forms (Google Forms or Tally.so):
• Buyer Interest Form
• Seller Car Submission Form
• Fields should include car model, year, fuel type, kms, asking price, photos (for seller), and budget and preferences (for buyers)
2. Lead Database Setup
• Google Sheet setup with:
• Buyer Watchlist Sheet
• Seller Leads Sheet
• Matching Logic Sheet to automatically match leads by model and budget
3. Matching Logic with Smart Filters
• Implement keyword-based model matching (e.g., “i20”, “Swift ZXi”)
• Set price buffer logic (±10% budget)
• Include location filter or pin code if needed
• Add a match score column out of 100
• Add urgency/star rating column for lead priority
• Use conditional formatting to color-code high-priority leads
4. WhatsApp Notification Integration
• Use AiSensy, Interakt, or Twilio
• Automatically trigger WhatsApp alerts to matched buyers when a new seller car is submitted
• Help with WhatsApp Business API setup and message template approvals
• Example message:
“New Match: 2019 Honda City VX CVT, 40K km – ₹8.4L
Verified by Renew Cars. Interested? Reply YES.”
5. Inspection Flow Setup
• Internal Google Form for inspection checklist used by the field team
• Fields to include: tyre condition, service history, scratches, engine noise, rating
• Auto-store seller documents and photos in Drive folders (linked via Sheet)
6. Booking and Payment Integration
• Integrate Razorpay or UPI link to collect token amount from buyers
• Optional: Set up a test drive or inspection scheduler using Google Calendar or Calendly
7. Admin Dashboard
• Use Google Data Studio (or Google Sheets dashboard view) to display:
• Total new buyer leads
• New seller cars
• Match count
• Most requested models
• Unmatched hot leads
8. Weekly Match Report Generator
• Sheet that auto-logs:
• Matches found this week
• Buyer requests with no matches
• Recommendations for what to procure
• Unclosed deals or stale leads
⸻
OPTIONAL ADDITIONS (Include in Scope)
• Auto-tagging buyer preferences in Sheet
• Flag rare or niche keywords like “Hybrid” or “Electric”
• Deal Tracker Sheet:
Car ID | Buyer Name | Seller Name | Token Paid | Status | Remarks
• Manual override: Add/remove leads from alerts manually
• Instructions guide (no video needed) for team to use the system on mobile
⸻
PREFERRED TOOLS
• Google Forms or Tally.so
• Google Sheets
• AiSensy or Interakt or Twilio (for WhatsApp alerts)
• Google Data Studio
• Razorpay (optional)