Auto Parts · DistributionB2B Manufacturing & DistributionAuto Parts

From Excel to an AI Agent — a 5x Higher Close Rate on Automotive Parts Quotes

AI agents split up the parts pricing and quote writing that used to run on Excel. Automatic price updates, auto-attached part photos, and margin optimization — a 5x quote close rate.

Auto-parts quoting AI · full-AX of an Excel workflow

After launch, here’s what changed
×5
quote close rate (vs. the old Excel workflow)
Half a day → 14 sec
time to write one quote
Real-time
automatic parts price & stock updates
Autopeople — Auto-parts quoting AI · full-AX of an Excel workflow
Before

Where things stood
before the project

  • 01Parts pricing and quote writing both ran on Excel, so every market price change had to be checked and updated by hand.
  • 02Margins and prices swung even for the same part and the same customer — the quote close rate was never consistent.
  • 03Plain table-style quotes with no photos or descriptions carried little pricing power, and prices got knocked down in negotiation again and again.
  • 04A single quote took half a day on average — sales were tied up quoting and routinely missed the next consultation.
Approach

How we solved it

Rather than “throwing away” Excel, we went the other way and preserved the Excel workflow exactly as it was. The sales team keeps using the templates they know; we built a Sheet Bridge that syncs those templates two ways, then layered three agents on top — parts price sync, quote drafting, and margin optimization. Market prices arrive via automated crawling and normalization every morning before dawn; the quote-drafting agent matches catalog photos and even line-level part codes. Margins are recommended per line by a model trained on 6,000+ historical quotes and closed deals.

Inside

How it works on the inside

Work that one person used to handle is split across multiple agents. The automation runs across the entire flow — not just a few steps.

01 · Agent

Parts Price Sync Agent

Crawls and normalizes prices from major parts makers and dealer networks daily — daily market swings Excel could never capture are reflected instantly

02 · Agent

Quote Drafting Agent

Customer requirements → parts matching → auto-drafted quotes (with a human review step)

03 · Agent

Auto Photo-Attach Agent

Auto-matches catalog and real part photos to every quote line — quotes customers can see and understand

04 · Agent

Margin Optimization Agent

Recommends per-part margins and discounts from past transaction and deal-close data — lost quotes are recycled as training data

05 · Agent

History RAG

Vector-indexes past quotes, wins/losses, and repurchase patterns — similar cases recalled instantly

06 · Agent

Excel Bridge

Two-way sync with the existing Excel templates — preserves the sales team’s familiar workflow

07 · Agent

Owner Dashboard

Quotes sent, close rate, average margin, and repurchase rate on a single screen

After

What changed
after launch

  • Time to write one quote: half a day → 14 seconds on average.
  • 5x quote close rate vs. the old Excel workflow (90-day cumulative).
  • Missed parts-price updates effectively zero — automatic refresh daily at 06:00.
  • Line-level photos, price movements, and margin rationale are all visible — cutting customer review time and reducing rounds of renegotiation.
Runtime

Project details

Duration
2 weeks design + 6 weeks build + 2 weeks stabilization
Team
TreeSoop team of 4 (1 PM / 2 AI engineers / 1 backend)
Operating mode
SaaS · daily use by the sales team · automatic price refresh daily at 06:00 KST
Stack

Tech stack

STACK
LangChain · DeepAgents · FastAPI
DATA
Parts pricing · history RAG
STATUS
Production

CEO Donghyuk Nam · a dedicated retailer of new automotive parts. A full-AX transformation of a quote workflow once handled by hand in Excel — no price change goes unnoticed, and every quote comes out as a “self-explanatory quote” complete with part photos and optimized margins. With sales no longer tied up writing quotes, the same team handles more consultations and closings — and the quote close rate improved 5x.

More

Other work in a similar vein

Facing a similar challenge?
Let’s talk it through

Excel workflows, chatbots, AI marketing — whatever the domain, it can be redesigned the same way.The initial assessment and quote are free — the contact form is the fastest way to reach us.