Designed and developed an automated data pipeline that retrieves tariff rates and import licensing requirements from Indonesia's National Single Window (INSW) portal. The solution reduces repetitive manual lookups by collecting, structuring, and exporting regulatory data into Excel and JSON formats for operational reporting and analysis.
Browser automation workflow for researching tariff and licensing information from INSW and exporting structured Excel / JSON outputs.
HS Code lookups were repetitive and time-consuming when handled manually across many products.
Designed and built the automation workflow, extraction logic, and output structure with AI-assisted support.
Incomplete HS codes are read from Excel, browser automation searches the INSW portal, and the extracted regulatory values are structured for export.
The workflow reduces repetitive regulatory lookups, improves consistency, and creates a structured output that can support import planning, compliance review, and reporting.
Browser automation, ETL-style data extraction, structured reporting, and practical process improvement.
This page uses a public-safe summary only. It does not expose private company data, credentials, or internal trade records.
The full implementation, documentation, and project structure are available on GitHub.
Repository includes:
End-to-end automation process used to collect HS Code tariff and import licensing information from INSW and transform it into structured datasets.
User Enters HS Codes
Load Workbook & Detect Missing Data
Browser Automation
Trade Regulation Source
Extract Tariffs & Permits
Structured Data Model
Tariff & Tax Data
Import Permit Data
Excel & JSON Files