Edric Russell Ramilo

OpenKitchen

Tool to replace repetitive manual web scraping workflows. Translates plain English instructions into structured JSON execution steps via the Gemini API, drives browser automation in Playwright, and exports formatted tables to Excel via ExcelJS.

Architecture pipeline

01

Prompt input

User submits an automation task in plain English.

02

Gemini API parsing

Converts the plain text request into structured JSON steps.

03

Playwright engine

Opens a headed browser, navigates to the target page, and collects the requested data.

04

DOM parsing

Normalizes raw HTML nodes into structured JSON records using Gemini.

05

Excel export

Formats scraped records and writes them to an Excel spreadsheet with ExcelJS.

Case study

The problem

Repetitive data entry and manual web scraping take hours for operations teams without developer support.

The solution

Parses user instructions into task steps with the Gemini API, runs them in Playwright, and exports the scraped data to Excel files using ExcelJS.

Stack used

PlaywrightGoogle Gemini APINext.jsTypeScriptSupabaseTailwind CSSExcelJS