Telecom sales · Hong Kong

Quotation and document automation for a Hong Kong telecom sales business

From order log to finished forms and quotes — in seconds.

-98%form & quote prep time
+25%quotes sent same-day
HK$32,000admin cost saved / month

This team sells telecom plans to business customers. Every order used to be re-typed by hand into supplementary order forms and quotation documents. We built a generator that reads their order log and produces every document automatically — formatted, accurate and ready to send.

The challenge

Two staff spent most of every day copying details from the order log into forms and quotes, one at a time — close to an hour per batch, several batches a day. Manual copying meant the occasional wrong figure or missed field — and a customer chasing a corrected quote.

The solution

A tool that reads the Customer Order Log spreadsheet and generates a filled order form plus quotation for every customer — individually or the whole batch as a ZIP — using their exact document templates.

The workflow we built

  1. Upload once. The team drops in the order log exactly as they already keep it — no new format to learn.
  2. Parse & validate. Each row is checked for missing or inconsistent fields before any document is generated.
  3. Generate documents. Order form + quotation per customer, correctly formatted and filled from the source data.
  4. Batch export. One click produces the full batch as a ZIP, named and ready to send.

A week before, a week after

TopicBeforeAfter
Data entryTwo staff copied each order from the log into an order form and a quotation, one field at a time.The team uploads the order log exactly as they already keep it.
Time per batchEach batch took close to an hour, and there were several batches a day.The batch takes seconds; staff look it over and send it.
ErrorsA wrong figure or a missed field was often found only when the customer spotted it.Every row is checked for missing or inconsistent fields before anything is generated.
CorrectionsA corrected quote meant redoing the document by hand while the customer waited.One click produces the order form and quotation for every customer, as one ZIP.
Same-day quotesOrders that came in late in the day often waited until the next day for a quote.A quarter more quotes go out the same day the order arrives.

How the saving adds up

  • Two staff each spent about 145 hours a month on this work — roughly 6½ hours of every working day copying orders into forms and quotes, and fixing mistakes.
  • 2 staff × 145 hours ≈ 290 hours a month.
  • 290 hours × HK$110 an hour ≈ HK$32,000 a month.
  • 290 ÷ 173 hours (one full-time month) ≈ 1.7 full-time staff.
  • HK$110 an hour is about HK$19,000 a month for one full-time admin staff, MPF included.

These are the working assumptions behind the figure, not an audited result.

How the project ran

  1. Free audit. We sat with the two staff and watched a real batch go from the order log to finished forms and quotes.
  2. Built on their own files. The generator was built and tested on a sample of their real order log, using their exact document templates.
  3. Side by side. For a period the team kept preparing batches by hand while the generator ran on the same orders, and the two were compared line by line.
  4. Live, then monitored. Once the output matched, the manual batches stopped. We monitor it and fix anything that comes up after go-live.

Questions owners usually ask

  • Did anyone lose their job?
    The hours went into selling. What to do with freed-up time is always the owner's decision, not ours.
  • What happens when it gets something wrong?
    Every row is checked before any document is generated. A row with a missing or inconsistent field is flagged for the team to fix, so it never becomes a wrong quote.
  • Where does our data live?
    The order log stays in the spreadsheet the team already keeps, and the finished documents come back to them as a ZIP. Who has access to what is agreed with you during the free audit, before anything is built.

Tools we used

ClaudeGoogle Sheetsn8n

The results

  • A batch that took close to an hour is now generated in seconds, with zero copying errors.
  • A quarter more quotes go out the same day the order arrives, which customers notice.
  • Around HK$32,000 of admin time saved every month — the work of about 1.7 full-time admin staff, redirected into selling.

Representative example — figures illustrative, client anonymised.

Have an operation that looks like this?

Tell us the process and we'll show you exactly how to automate it — free, and no obligation.

Get a Free Automation Audit →