Revenue Acceleration Unit Live Lead System (RAULLS)

RAU-LLS (Live Lead System) is a Lead-driven admin platform built for managing sales agents and distributing leads reliably from Google Sheets. The system allows administrators to configure a live Google Sheet as the single source of truth for leads, manage agents, and control lead ownership through a locking mechanism. Each agent receives assigned leads, while admins retain full visibility and control over agent activity, lead status, and system configuration.

The platform is designed for sales and outreach teams that rely heavily on spreadsheets but need stronger structure, access control, and accountability without moving fully to a complex CRM.

Sales teams using shared Google Sheets often face:

• Multiple agents contacting the same lead
• No clear ownership or locking of leads
• Poor visibility into agent activity
• Manual agent onboarding and access control
• High risk of data conflicts and accidental edits

RAU-LLS solves this by turning a Google Sheet into a controlled, structured lead pipeline with enforced agent assignment and locking.

• Built a backend system that connects directly to Google Sheets and validates required lead columns.
• Implemented agent management (create, activate/deactivate, reset passwords, delete).
• Designed a lead locking mechanism to prevent multiple agents from handling the same lead.
• Added admin configuration tools to define which Google Sheet and worksheet tab to sync from.
• Structured lead fields such as callback dates/times, appointment scheduling, disposition, notes, and agent assignment.
• Implemented role-based access (admin vs agent) to protect sensitive operations.
• Ensured reliable synchronization between live spreadsheet data and the application backend.

• Eliminated duplicate lead handling and agent conflicts.
• Improved accountability and traceability of agent actions.
• Allowed teams to keep using Google Sheets while gaining CRM-like control.
• Reduced operational errors and manual coordination for sales managers.
• Demonstrates real-world backend problem-solving: third-party integration, access control, data consistency, and admin tooling.