plugin
05 of 06
Product & Materials Research
Build a master FF&E product library through research, web extraction, PDF parsing, and image processing.
View on GitHub →
5 skills
The problem
Interior designers spend hours manually collecting product data — browsing vendor sites, copying dimensions and pricing into spreadsheets, downloading images, normalizing inconsistent formats. Data ends up scattered across browser bookmarks, email attachments, PDF catalogs, and half-filled spreadsheets with mismatched columns.
How it works
One master Google Sheet with a 33-column schema. Multiple ways to get products in — research briefs, browser clipping, URL batches, PDF catalogs. Every entry is structured the same regardless of source. Utility skills handle normalization and image processing.
Workflows (getting products in)
| Source | Skill | How it works |
|---|---|---|
| Research brief | /product-research | Describe what you need, Claude searches the web and returns curated candidates with specs and reasoning |
| Browser | Norma Jean | Chrome extension — Alt+C on any product page, extracted and saved in ~3 seconds |
| URL list | /product-spec-bulk-fetch | Batch-extract specs from a list of product page URLs |
| PDF catalog | /product-spec-pdf-parser | Extract specs from price books, fact sheets, and spec sheets |
Utilities (processing products)
| Skill | What it does |
|---|---|
/product-spec-bulk-cleanup | Normalize casing, categories, dimensions, materials, language across the sheet |
/product-image-processor | Download, resize, and remove backgrounds from product images |
/spec-package | Run fetch, cleanup, and images in sequence |
Skills
| Skill | Type | Description |
|---|---|---|
/product-research | Workflow | Give a brief, get curated candidates with specs and reasoning |
/product-spec-bulk-fetch | Utility | Batch-extract specs from product page URLs |
/product-spec-bulk-cleanup | Utility | Normalize casing, categories, dimensions, materials, language |
/product-spec-pdf-parser | Utility | Extract specs from PDF catalogs, price books, and spec sheets |
/product-image-processor | Utility | Download, resize, and remove backgrounds from product images |
Master schema
All skills write to a shared 33-column Google Sheet:
| Section | Columns |
|---|---|
| Product (A–J) | Link, Thumbnail, Product Name, Description, SKU, Brand, Designer, Vendor, Collection, Category |
| Dimensions (K–P) | W, D, H, Seat H, Unit, Weight |
| Materials (Q–S) | Materials, Colors/Finishes, Selected Color/Finish |
| Pricing (T–V) | List Price, Sale Price, Currency |
| Logistics (W–AA) | Lead Time, Warranty, Certifications, COM/COL, Indoor/Outdoor |
| Meta (AB–AC) | Clipped At, Image URL |
| Research (AD–AG) | Tags, Notes, Status, Source |