Bolttech Insurance Data Exporter

⚙Robotic Process Automation

A full-stack data export tool with a cloud-hosted browser sandbox. Users authenticate via a live-streamed browser view, then the system automatically scrapes and exports insurance data (quotes, policies, leads, accounts) to CSV with email delivery.

Technology Stack

Next.jsFastAPIPlaywrightWebSocketGoogle Cloud RunFirestoreResend

System Architecture

Loading diagram...

Specifications

▸Live Browser View: Real-time screenshot streaming via WebSocket for human login
▸Remote Interaction: Click and type events forwarded to cloud browser
▸Multi-Section Export: Scrapes quotes, policies, leads, and accounts tables
▸Pagination Handling: Automatically navigates through all table pages
▸Scheduled Exports: Cron-based automation with stored credentials in Firestore
▸Email Delivery: CSV attachments sent via Resend API

Design Decisions

Challenge	Solution
Complex login with MFA/captcha	Human-in-the-loop via live browser streaming
Running browser in serverless	Google Cloud Run with Playwright + headless Chrome
Real-time interaction latency	WebSocket with JPEG screenshots at 2 FPS
Secure credential storage for cron	Firestore with Cloud Run service account

Process Flow

Loading diagram...