kwikly-enrich

A collection of PHP command-line tools that enrich and validate CSV data for dental offices. The suite fills missing website URLs, identifies which Dental Service Organization (DSO) a practice belongs to, finds primary contacts (office managers, dentists) via web search, and validates addresses, phone numbers, and emails using Google, Twilio, and ZeroBounce APIs. Designed for cleaning and augmenting DMSI (dental market data) office lists.

Built to automate tedious data-cleaning and enrichment work for a dental-industry dataset. The project solves the problem of incomplete or unvalidated practice information by combining rule-based matching (for DSO classification) with LLM web-search (Perplexity) and third-party validation APIs. Likely created to support a business process involving lead generation, CRM import, or market analysis for dental practices.

PHP 8.0 (CLI scripts), Perplexity API (LLM with web search), Google Address Validation API, Twilio Lookup v2 (phone line-type detection), ZeroBounce (email validation). No framework; plain procedural PHP with environment-variable config and CSV I/O.

Last active Feb 24, 2026 — 1 commit across 1 active day (spanning 0 days).

Single-commit snapshot captured on one day (2024-02-24). All four enrichment scripts and DSO reference data appear complete and documented. This represents a focused burst of work—likely refactoring or packaging existing scripts into a shareable repo—rather than gradual development.

The repository contains four production-ready CLI scripts with clear help text, dry-run modes, limit flags, and error handling. Each tool integrates paid third-party APIs and solves a distinct real-world data-enrichment problem. Multiple input and output CSV files are committed, indicating actual use on real datasets. The comprehensive README and detailed DSO reference list (dso-list.md) suggest this was built to solve an ongoing business need, not a one-off experiment.