Services / AI

AI automation & consulting

We connect your email, Excel and Google Sheets to automate repetitive entry and checks.

Automation examples by task

These examples help define the scope of a build. We first check file formats and access permissions to establish what can be automated.

Inquiries & sales
Today
Opening each email or Google Form inquiry and copying it into Excel
With automation
Read inquiries using agreed classification rules.
Required access & files
Access to inquiry emails or Google Form responses, and the destination sheet
Output
Sheet rows with dates, categories and requests, plus notifications to the person in charge
Reviewer & approval
Whoever handles inquiries checks categories and missing information.
Today
Opening purchase orders from customers' emails and copying them into the order ledger
With automation
Read the required fields from purchase orders and flag missing values.
Required access & files
Order attachments, email read access and an order ledger template
Output
Draft ledger entries with items, quantities and delivery dates
Reviewer & approval
Whoever handles orders checks the source and approves entries before they are applied.
Today
Looking up the price list and writing a new quote for every request
With automation
Apply the agreed prices and calculation rules.
Required access & files
Quote requests, a current price list, and discount and tax rules
Output
Draft quotes with item amounts and the prices used
Reviewer & approval
Sales staff check prices, amounts and terms, then approve sending.
Today
Writing and sending a separate notice email to each customer
With automation
Write to the agreed audience and message guidelines.
Required access & files
A customer list, message templates, and email read and draft permissions
Output
Customer email drafts and a reply status list
Reviewer & approval
Sales staff check recipients and content, then approve sending.
Back office & documents
Today
Typing amounts and vendors into Excel from tax invoices and receipts
With automation
Read documents and classify them into the agreed ledger fields.
Required access & files
Tax invoice and receipt files, plus a ledger template. Issuance requests require a separate service account and permissions
Output
Draft ledger entries by vendor, date and amount, plus draft issuance requests if connected
Reviewer & approval
Accounting staff check source documents, amounts and recipients, then approve entries and issuance requests.
Today
Matching bank deposits against the receivables list line by line
With automation
Compare payer names, amounts and dates with receivables.
Required access & files
A bank deposit export and a receivables list for the same reference date
Output
Candidate payment matches and unmatched items
Reviewer & approval
Accounting staff check partial payments and duplicate names before confirming payment status.
Today
Collecting each team's Excel files to build a monthly report
With automation
Aggregate files for the agreed reporting period using consistent rules.
Required access & files
Team Excel files, a report template, aggregation rules and access to the storage location
Output
A draft monthly report and email
Reviewer & approval
Whoever prepares the report checks missing files, the period and recipients, then approves sending.
Today
Replaying a meeting recording to write the minutes
With automation
Organize discussions and follow-up work from the recording.
Required access & files
A recording cleared for business use and a minutes template
Output
Draft minutes and a to-do list
Reviewer & approval
Whoever ran the meeting checks decisions, items on hold, owners and deadlines before sharing.
Trade & purchasing
Today
Copying items, quantities, unit prices and weights from invoices and packing lists into a control sheet
With automation
Read equivalent fields and compare them with the purchase order.
Required access & files
Invoice and packing-list PDFs, the purchase order and a control-sheet template
Output
Draft sheet entries and a list of differences from the order
Reviewer & approval
Trade staff check quantities, amounts and weights. A customs broker handles customs judgments.
Today
Opening quotes from several suppliers to compare unit price, minimum order and lead time
With automation
Organize quotes using the same comparison fields.
Required access & files
Supplier quote files and agreed fields and units
Output
A comparison of prices, minimum orders and lead times
Reviewer & approval
Purchasing staff check currencies, delivery terms and missing values, then select a supplier.
Today
Translating English and Chinese emails and noting changed terms separately
With automation
Compare terms in the previous and new emails.
Required access & files
Both email versions, read access and company terminology
Output
Email translations and a summary of changes to prices, lead times and payment terms
Reviewer & approval
The account manager checks translations and changed terms against the source before replying.
Today
Checking shipping and customs status in forwarder emails and tracking screens
With automation
Compare previous and current status in the available data.
Required access & files
Forwarder emails, shipment identifiers and a check of the data available from public tracking sources
Output
Notifications of changes to shipping dates or clearance stages
Reviewer & approval
Logistics staff check the source and query time, then decide the next action.
Stores & on-site
Today
Checking booking and order notifications in several apps separately
With automation
Identify new bookings and orders in the supplied data.
Required access & files
Booking and order exports, or an API provided by the service with read permissions
Output
A list of new bookings and orders, plus notifications
Reviewer & approval
The store owner checks duplicates and cancellations, then decides how to handle the actual bookings or orders.
Today
Counting stock by hand again and again
With automation
Compare updated stock values with each item's threshold.
Required access & files
An updated stock file or a system that allows stock queries, plus item thresholds
Output
A list of items below their thresholds, plus notifications
Reviewer & approval
Whoever manages stock checks data freshness and physical stock, then decides whether to order.
Today
Totaling each employee's working hours in Excel from clock-in records
With automation
Calculate hours from attendance records using agreed rules.
Required access & files
Employee attendance exports and calculation rules, including breaks
Output
A draft table of working hours per employee
Reviewer & approval
Whoever manages attendance checks missing records and breaks before confirming totals.
Today
Reading each online-store review and writing a reply
With automation
Write replies for the new reviews supplied.
Required access & files
Review exports, or an API provided by the service with read permissions
Output
A list of new reviews and reply drafts
Reviewer & approval
The store owner checks facts and wording, then posts or approves posting.

Example: checking trade documents

  1. What comes in

    • Purchase orderPO-118.xlsx
    • Commercial invoiceCI-0921.pdf
    • Packing listPL-0921.pdf

    The three documents received by email are read. The original files are not changed.

  2. Check result

    Values are pulled from the three documents and set side by side. Differences and blanks are marked with where they appear in the original. “Match” only means the values are the same; it does not approve the documents.

    ItemPOInvoicePacking listResult
    Item A quantity800800800Match
    Item B quantity1,2001,2001,150Differspacking list p.2, line 3
    Total amountUSD 8,400USD 8,640n/aDiffersinvoice p.1, total
    Gross weightn/a1,320 kgblankCheck neededmissing on the packing list
  3. A person checks

    Correction request to the supplier · draft

    The invoice total (USD 8,640) and the item B quantity on the packing list (1,150) do not match the purchase order. The gross weight is also missing from the packing list. Please check and send corrected copies.

    Awaiting approvalIt is sent only after your staff review and approve it.

Built from mock documents, not real trade records. In real work, we first agree on the document formats and what to check.

How it can be used in each industry

Industry examples. In every case we first agree which files and accounts are connected, and your staff check anything sent outside or any amount before it is final.

IndustryWhat comes inWhat it producesWhat a person checks
Online stores & e-commerceProduct information, customer inquiries and reviews, orders from each storeListing forms, draft replies, courier waybill format, product page translationsSending replies, translated text
Manufacturing & factoriesPurchase order emails, work logs and defect records, material stockProduction plan sheet, daily report, low-stock alertsProduction schedule, whether to reorder
Trade & distributionPurchase orders, invoices and packing lists, supplier emails and quotes, exchange ratesMarked differences, summary of changed terms, quote comparison table, rate alertsCorrection requests, choice of supplier
Restaurants & cafésBooking and delivery notifications, photos of delivery statements, reviewsOrder list, cost ledger entries, draft review repliesLedger amounts, posting replies
Academies & educationConsultation inquiries, attendance and assignment records, class materialsConsultation sheet, draft messages to parents, draft practice questionsSending messages, question content
Hair & beauty salonsBooking change requests, visit recordsProposed schedule changes, after-treatment messages, draft messages for lapsed customersConfirming changes, message wording
Real estate brokerageListing information, client conditions (area, budget, size), contract datesDraft listing text, matching listings, date remindersListing details, messages to clients
Tax, accounting & labor officesClient supporting documents, reply status, payroll dataDocuments sorted by type, document request emails, payslips per employeeSorting results, payslip amounts
Travel agenciesTravel inquiries, consultation notes, booking detailsTravelers, dates and budget sorted, draft itinerary, confirmation and pre-departure emailsItinerary and prices, sending emails
Interior & constructionSite photos and notes, quote requests, material price listDaily progress report, draft quote, schedule notices to subcontractorsQuote amounts, work schedule
Office & services in generalMeeting recordings, contracts, scattered Excel files, payment statusMinutes and to-do list, marked key clauses, weekly report, draft payment remindersClause interpretation, report figures, sending reminders
Companies bidding on public tendersKONEPS (Korea's public procurement system) noticesList of matching notices, required documents and deadlines, deadline alertsWhether to bid, documents to submit

What we build depends on the work

When your current tools are enough

We keep your email, Excel and Google Sheets, and set up the AI’s work instructions and tool connections around them.

  • Summarize contracts and quotes in a table.
  • Find emails that need a reply and prepare drafts.

When the work needs its own screen

We move work passed around in Excel and messengers into a web app for your company.

  • Manage quotes, orders and stock in one place.
  • Connect leave and expense requests to approvals.

When outside customers will use it

We build services with sign-up, payments and an admin screen.

  • Extend an internal tool into a subscription service.
  • Apply our experience building Flobi’s payslips and electronic employment contracts to other work.

How the project works

  1. Review the work

    We review your work and tools to choose a task to automate.

    You prepare
    Describe the task and tools (Excel, email, KakaoTalk, etc.), and share samples without personal data

    Task listCurrent workflow notes

  2. Scope and quote

    We define the automation scope and schedule. Any recurring service fees are listed separately.

    You prepare
    Choose the scope and person who will review results

    Scope table: automation / human reviewQuote

  3. Build and test

    We test with samples that have personal information removed before using real data.

    You prepare
    Check test results

    Test results: pass / hold per sample

  4. Handover

    We document how to use it, check results and find error details.

    You prepare
    Review the handover materials

    How to use itHow to check resultsWhere to check errors

Deliverables for inquiry automation

Example data

Work instructions
Extract the company, contact, inquiry type and request. Leave uncertain fields blank.
Sheet columns
Date received, company, contact, type, request, owner, status
Handover checks
Check blank fields and the inquiry type, then review the reply draft. If an error occurs, compare the “Needs review” log entry with the original inquiry.

What we need for a quote

We quote each project based on its feature scope and include a scope table.

  • Industry
  • The repetitive task (e.g. copying purchase orders from customer emails into an Excel order ledger each day)
  • Current tools: Excel / Google Sheets / KakaoTalk / email / internal ERP or POS / other
  • Frequency: daily / weekly / monthly
  • What you need: review and consulting only / implementation too / decide after discussion
  • Does the data include personal information?: yes / no / unsure

Mark undecided items as “unsure” or “decide after discussion.”

Steps that need human review

AI can misread or misclassify information. A person checks before amounts are confirmed, messages are sent externally or records are submitted. Legal, tax, labor and customs decisions remain with the appropriate specialists.

Web & app development and operations

These are web and mobile services built and run by TNT. Explore their actual screens and service links.

Frequently asked questions

Which AI do you use?

We select an AI model that fits the task. Work that can be handled with rules alone does not use AI.

Can we send company data to an external AI?

During design, we identify the data sent outside and its processing route. Data that must not be sent is handled without AI or excluded. A specialist should review the legal basis for handling personal and confidential data; retention conditions depend on the service terms.

Can it connect to our Excel, ERP or store admin tools?

The method depends on whether the program supports integrations or file downloads. We explain in advance if a separate service account is needed, as with electronic tax invoices or KakaoTalk Alimtalk. Usage fees for AI and automation tools are set by their providers.

What happens to failed items?

Failed items are gathered separately and reported to the person in charge.

Send an AI automation inquiry

Describe the task and name the tools you use in the inquiry form.