Tools & Technology¶
An overview of all software systems, tools, and technology used at GYC Group.
Core Systems¶
1. GYC OPS Dashboard¶
URL: ops.gychomes.com
Stack: Next.js 16 · TypeScript · React 19 · NextAuth.js v5 · Google APIs · Cloud Run
Repo: mason-dowell/gyc-dashboard (private, GitHub)
Maintained by: Mason Dowell, Kyle
The central operations hub for GYC. A web application that replaces paper-based operations by connecting to Google Sheets, Gmail, and Drive for live data. No traditional database — all persistence is Google Sheets.
What It Does¶
| Module | Status | Description |
|---|---|---|
| Projects | ✅ Live | Interactive map, project listing, project creation, structure dashboards |
| Estimates | ✅ Live | Budget overview, detail breakdowns, bid tracker, estimate organizer |
| Invoices | ✅ Live | Gmail → Drive → Sheets pipeline, dashboard with inline PDF viewer |
| Proposals | 🔶 Partial | Proposal inbox (live), status tracking (needs build) |
| Billing Packages | 🔴 Mock | Needs API + Sheet tab wiring |
| Subcontractors | ✅ Live | Full directory with CSV import, duplicate audit, document upload |
| Clients | ✅ Live | Client profiles from project ledger data |
| Toolkit | ✅ Live | Property lookup — SDAT records, geocoding, permit office links |
| Admin | ✅ Live | User role management |
| Kanban / Tasks | ✅ Live | Drag-and-drop task boards with voice-to-task |
| Schedule / Gantt | ✅ Live | Interactive Gantt charts from Drive schedule files |
Access Roles¶
| Role | Who Gets It | Access Level |
|---|---|---|
admin |
Mason, Kyle | Everything including user management |
project-manager |
PMs | Projects, estimates, proposals, invoices, subs, clients |
accounting |
Accounting staff | Invoices, packages, subs, clients |
field |
Field personnel | Toolkit + read-only estimates |
Infrastructure¶
- Hosting: Google Cloud Run (
gyc-opsservice,us-east4region) - CI/CD: Git push to
main→ Cloud Build → Docker → Cloud Run (auto-deploy) - Secrets: 25 environment variables in Google Secret Manager
- Auth: Google OAuth restricted to
@gychomes.comdomain, 4-layer security
2. Google Workspace¶
GYC uses Google Workspace as the foundation for all communication and document management.
| Tool | Primary Use |
|---|---|
| Gmail | All business email. Invoice ingestion and proposal tracking via the dashboard. Domain: @gychomes.com |
| Google Drive | Document storage — estimates, proposals, contracts, billing packages, project files. Organized by project folders |
| Google Sheets | Acts as the database for the OPS Dashboard — Project Ledger, Invoice Log, Subcontractor Directory, Roles, per-project Estimates |
| Google Docs | Contract templates, proposals, general documentation |
| Google Calendar | Scheduling (limited integration with dashboard currently) |
| Google Maps / Places | Address autocomplete, geocoding, project mapping in dashboard |
3. GYC Wiki (This System)¶
Location: Git repository at /Users/gyc/Documents/Development/GYC-Wiki
Format: Markdown files with YAML frontmatter
Editor: Obsidian (primary), any text editor
Purpose: Institutional knowledge base — people, processes, projects, decisions
Inspired by Karpathy's llm-wiki pattern: a persistent, compounding knowledge artifact maintained by both humans and AI agents.
4. Voice-to-Wiki Pipeline (Planned)¶
Status: Not yet deployed
Purpose: Record PM meetings, auto-transcribe and structure into wiki pages
| Component | Tool |
|---|---|
| Transcription | WhisperX (local, on M4 Max Mac Studio) |
| Structuring | Ollama + Qwen 3.5 27B (local LLM) |
| Orchestration | Python script (watch folder → transcribe → structure → commit) |
Development Tools¶
| Tool | Used By | Purpose |
|---|---|---|
| Git / GitHub | Mason, Kyle | Version control for all code and wiki content |
| VS Code | Mason | Primary code editor |
| Obsidian | Kyle, Mason | Wiki editing, note-taking |
| Antigravity IDE | Kyle | AI-assisted coding |
| Docker | Mason | Containerization for Cloud Run deployment |
| clasp | Kyle | Google Apps Script deployment from Git |
| Ollama | Mason | Local LLM hosting (M4 Max Mac Studio) |
Automation Scripts¶
| Script | Owner | Purpose |
|---|---|---|
| Project folder creator | Kyle | Apps Script — auto-creates Drive folders for new projects |
| Project promotion | Kyle | Apps Script — moves projects to active status post-contract |
deploy.sh |
Mason | Manual Cloud Build + Cloud Run deploy trigger |
Related Documents¶
- Document Management Process
- OPS Dashboard README (full technical reference)