← Catalog
1-lab Case · Used car dealership

Call quality control (QA) · CRM automation

A robot that collects every call into one spreadsheet while you sleep.

Instead of a QA specialist manually copying call recording links from the CRM into Google Sheets, a software worker does the job around the clock. Three years in operation, 100% call coverage, zero data entry errors.

Who it's for
Car dealers, QA teams
In operation
3+ years, around the clock
Payback
1–2 months
Task

A QA specialist spends 3–4 hours a day copying call links from the CRM, and only 20–30% of calls get reviewed

Solution

A robot moves call recordings from the CRM into Google Sheets around the clock and calculates sales reps' commission automatically

Result

Call coverage: 20–30% → 100%; frees up 15–20 hours of the QA specialist's time a week; pays back in 1–2 months

By the numbers

15–20h
QA time freed up a week
3–4 hours of manual copying a day is now 0 minutes
100%
Calls under review
instead of a 20–30% sample; sales reps know every call is heard
1–2mo
Payback
on one QA specialist's salary; then runs for years at no extra cost
0
Commission disputes
sales rep payouts calculated automatically, without errors or Excel

The problem

Where your QA team loses hours every day.

  • QA specialists manually collect call recording links from the CRM into Google Sheets. One person spends three to four hours a day on copy-paste.
  • Only 20–30% of calls get reviewed. The QA specialist simply has no time for the rest. Sales reps know it and get complacent.
  • Recordings get lost: there's no single "sale — rep — call" registry. Finding a specific conversation a month later is nearly impossible.
  • Sales rep commissions are calculated manually in Excel, slowly and with errors, leading to constant disputes with the head of sales.
  • Many CRMs lack a full API. Data has to be pulled "by hand" through the interface, which standard integrations can't do.

How it works

Five steps, repeated every minute.

  1. Logs into the CRM like a regular employee

    Under a dedicated account, over a secure connection. To the CRM, it looks like a regular QA specialist at work.

  2. Checks for new deals every minute

    Filters sales and calls for the current day. Spreads the load evenly: ten deals in the morning, ten in the afternoon, ten in the evening.

  3. Collects everything it needs for each deal

    The call recording link, car make and model, deal amount, and the responsible sales rep. It recognizes full names even with job title prefixes.

  4. Checks whether the deal was already processed

    If it was handled in the last three days, it's skipped. No duplicates in analytics.

  5. Writes to Google Sheets and sends a report

    Every morning at 9:00, the manager and the QA specialist get a Telegram summary of the previous day: how many processed, how many errors, which deals need a manual check.

Features

What's included.

Three parallel workflows

Sales control, client chat control, and sales rep commission calculation: three independent robots with different jobs.

Skips technical calls

The robot ignores calls shorter than 30 seconds: missed connections and test calls. Only real client conversations go into the report.

Self-recovery

If the CRM freezes or the connection drops, the robot waits a minute and resumes on its own. No admin intervention.

Control from your phone

An operator can stop or start the robot directly from Telegram, without logging into the server. Handy for off-hours.

Clean data in Sheets

The parser extracts the rep's name from strings like "UC Smith Anna Manager HQ", so only "Smith Anna" ends up in the spreadsheet.

Commission calculation without disputes

A separate robot calculates sales rep commissions on deals automatically. Transparent numbers leave the head of sales and the reps nothing to argue about.

Runs 24/7

The robot is deployed on a server and restarts automatically after a failure. Round-the-clock work with no vacations or sick days.

Morning digest

Every morning the manager sees a summary of the previous day: how many found, how many processed, how many skipped. Full visibility at the start of the day.

Economics

Before and after in one table.

What changesBeforeAfter
QA specialist's time per day 3–4 hours of manual collection 0 minutes, the robot does it
Call coverage for review 20–30%, spot checks 100%, automatic
Time to reach analytics end of day or end of week within 1–2 minutes
Sales rep commission calculation manual Excel, disputes with the head of sales automatic, error-free
Time per week 15–20 hours of a person's work fully freed up
Payback

Measured against one QA specialist's salary, the solution pays for itself in 1–2 months and keeps running for years with no additional investment.

Who it's for

Where it works.

Anywhere you need to pull data from a CRM into analytics and the vendor offers no direct connection. The solution adapts to any CRM you can log into as a user.

Used car dealerships New car dealerships Car dealership chains Call centers with split telephony QA departments Any business with a complex CRM

What's different

Why this isn't an off-the-shelf service.

Ready-made services need an API

Most CRMs don't provide full API access. Any off-the-shelf integration tool simply fails on the fields you need.

Fits your process

Your time slots, your rules for assigning the rep, your commission formula: this is custom logic no ready-made product will have.

Full control

The robot runs on your server under your account. No subscriptions, no black boxes: you own the solution.

Get a robot like this for your QA team.

Free audit: in a 30 min session, we'll show what can be automated in your CRM and how much it will save per year.

Quiz · 6 questions · 1 minute

Phone only or messenger only is fine. We reply within a day, no spam or newsletters.

Or right away: Telegram · @one_lab_support →  ·  hello@1-lab.dev

1-lab · Call quality control case for a used car dealership Client name anonymized. Figures are actual, from the solution's operation logs.