Client Intelligence: The Dog Wizard
Client Overview
- Domain: The Dog Wizard (WayCup Creative LLC Client)
- Tech Stack: Firebase, Google Cloud Platform (GCP), Google Apps Script (Clasp).
- Core Workflow: Quo-to-Sheets (Robust ETL).
- Client Identity:
kevin.dockman@thedogwizard.com(Use for domain-specific workspace and resource access).
Architectural Standards
- Nomenclature: All code must adhere to the WayCup professional standard (DRY, pitch-ready, unbranded nomenclature).
- Tooling Preferences:
clasp: Apps Script management.firebase-tools: Infrastructure management (Legacy).
- Constraint: FIREBASE IS DEPRECATED for new projects. Maintain stability for legacy projects but do not expand.
High-Level Goals
Perfect the ETL pipeline and ensure robust data synchronization between quoting systems and Google Sheets.
Project History
Workspace Intelligence Sync (2026-05-18)
- Goal: High-fidelity synchronization of Google Workspace User and Group data.
- Engine:
admin-sdk-script(Apps Script Library). - Interface:
local-sheet-script(Thin wrapper). - Outcome: Successfully implemented license-aware sync (including Cloud Identity Free), custom schema mapping (
Staff_Type), and stateful data preservation for manual notes/exclusions. - Key Insight: Directory API does not expose storage bytes for this domain; sync focuses on administrative metadata and licensing.