Autonomous Web Data to Spreadsheet Pipeline

AUTONOMOUS WEB ADAPTER & SPREADSHEET PIPELINE

Turns supplier-style HTML product pages into validated CSV and Excel workbooks. The deterministic pipeline normalizes prices and stock, resolves duplicate SKUs, rejects malformed records, and exports a stable business-ready schema.

MOCK DATA NOTICE Every product, supplier page, and benchmark input is synthetic mock data created for demonstration. No real company or customer data is included.

PROOF OF WORK • 250 parser runs • 1,500 records processed • 100% record-count consistency • 0.114 ms median latency per six-record page • 51,840 observed records/second • 7 automated tests passing

AUTONOMOUS AI PROOF A live local model discovers extraction adapters for unseen HTML layouts. Deterministic validators test both a sample and a separate canary page. A mapping is promoted automatically only when required fields, types, counts, SKUs, prices, and stock values pass. Invalid output is repaired from semantic evidence without human approval.

• 200 independent layouts • 200/200 raw AI mappings correct in the controlled benchmark • 100/100 decoy-element stress layouts approved • 800 sample and canary records validated • 200/200 final machine-approved cases • 0 human approvals

The 100% result describes this reproducible bounded benchmark, not universal scraping accuracy. Every approved case also had to match disclosed generated truth and pass the deterministic canary gate.

HOW IT WORKS Mock HTML → parser → type/range validation → SKU deduplication → CSV/XLSX. AI is an optional acceleration layer for new layouts; the base export remains operational without a model provider.

REPRODUCE THE EVIDENCE Clone the public repository, install the package, run the automated tests, execute the CLI against data/mock, and regenerate proof/benchmark.json. The repository contains all 200 case decisions and a CI workflow that reruns the checks on every push.

https://raw.githubusercontent.com/Milo318/web-data-to-sheets-poc/main/proof/portfolio-thumbnail.pngRepository: https://github.com/Milo318/web-data-to-sheets-poc