←Back to Portfolio
AI

Automated Sales Quotations with an LLM for an Electronics Retailer

An electronics retailer receives many bulk inquiries and requests for custom quotes. We built a system that takes a customer’s request and returns a branded PDF quotation within minutes.

Industry: Electronics retail

Automated Sales Quotations with an LLM for an Electronics Retailer

Challenge

  • Sales staff compiled specifications and prices by hand, which led to delays and mistakes.
  • Product information became outdated when prices or availability changed.
  • Quotations varied in tone and format, which weakened the brand.
  • Building and emailing the PDF took time.

Solution

  • A Google Form captures the customer’s requirements, and Zapier passes each submission to a custom REST API.
  • The API searches a vector database of semantically indexed product data to find relevant, current products.
  • A large language model drafts the quotation in natural language, guided by predefined style guidelines so the tone matches the brand.
  • A PDF generator formats the draft into a branded document, and the API emails it to the customer.
  • All transfers use HTTPS, and fallbacks handle errors and suggest alternative products.

Results

  • Customers receive a formatted quotation within minutes of a request.
  • Product recommendations reflect current availability, pricing and specifications.
  • Sales staff spend less time compiling quotes.
  • The system can take on new product lines and a larger catalog without more manual work.

Technologies

Large language modelVector databaseREST APIZapierGoogle FormsPDF generation