All case studies

A supplier document library that matches files to products

AppSheet Solutions and the client’s in-house team moved a supplier document library from AppSheet to custom software for a European ingredients distributor.

Page last updated

Status: In daily use

Ask about this project

Islom Ilkhomov

Sample document library: a table of supplier files with match levels and filters, a panel showing the data read from one file and the choice between two products, and the totals of 20,000+ documents matched and about 8,200 files renamed in the client’s test environment.
Illustration. Names and rows are sample data; totals are the project’s.
On this page

Key numbers

  • 20,000+ documents matched to products
  • ≈ 8,200 files renamed

Measured in the client’s test environment.

The problem

Certificates of analysis, specifications and safety data sheets arrive from suppliers in a shared Drive folder, tens of thousands of them. The AppSheet app filed them, but linking each file to the right product, spotting duplicates and naming files consistently still took manual work.

What we did

  • Moved the library from AppSheet into the client’s custom platform: 23,000+ existing records, in the client’s test environment
  • Reading for every file: text extraction, OCR for scans, then AI extraction of document type, product names and codes, batch numbers and dates
  • A rule-based product matcher with regression tests; uncertain matches go to a reviewer instead of being guessed
  • One naming pattern for the files on Drive, and topic tags for search

Built together with the client’s in-house team.

Results

  • 20,000+ archived documents re-read and matched to products, in the client’s test environment
  • About 8,200 files on Drive renamed to one consistent pattern, in the same environment

How it helps

Staff open a product and find its documents. Reviewers can focus on uncertain matches.

More case studies

Sales records and access rules for each team

Measured in the client’s test environment.

Sales teams were moving off an old CRM. Each team should see only its own customers and prices.

Sector
Ingredients distributor · Europe
Platform
Custom software
Status
In daily use

AI meeting-to-task and Workspace security automations

Someone had to write up tasks by hand after long online meetings, and management had no simple view of how company Google accounts and files were used.

Sector
Engineering team
Platform
Gemini + Apps Script
Status
In daily use

Purchasing platform for a machinery manufacturer

A machinery manufacturer needed one shared record for requests, supplier prices, approvals and goods receipt, used by many people at once.

Sector
Machinery manufacturer
Platform
AppSheet + Apps Script
Status
In daily use

Start with a conversation

Let’s make your work easier.

  1. Tell us where work gets stuck.
  2. We clarify what an app could help with.
  3. We agree the next step together.

Tell us about your project

WhatsApp (opens in a new tab)

Need an example?

We want to register our equipment and let field staff report faults from their phones. Today, we track everything in messages.

Add project details (optional)

What is it about?

Book a 30-minute call

Discuss your custom app project with Islom on Google Meet.

Choose an available time
Portrait of Islom Ilkhomov

Islom Ilkhomov

Prefer to write directly? Islom.Ilkhomov@appsheet.com.tr

Istanbul, Türkiye

Prefer a conversation? Write to me directly.

Talk to Islom on WhatsApp (opens in a new tab)+90 501 176 94 71