# NMC Data Sources Inventory
Created: 2026-03-12

## Currently Connected ✅
| Source | Access | What's There |
|--------|--------|-------------|
| Slack | Bot token | 41 channels, all ops/team comms |
| GHL | v2 API token | 13,886 contacts, pipeline, conversations |
| Gmail (personal) | IMAP app password | mikeziarko@gmail.com |
| Google Calendar | Service account | Work + personal calendars |
| QuickBooks | OAuth tokens | Full financials, P&L, invoices |
| Launch27 | API key | Bookings, services, customers (API decommissioned!) |
| YNAB | API token | Family + business budgets |
| Net Worth Sheet | Service account | Google Sheets access |
| Twilio | Auth tokens | Phone/SMS, Leah agent |

## Needs Connection 🔌
| Source | What's There | What I Need |
|--------|-------------|------------|
| **Airtable** | Years of L27 synced data (customers, bookings, contractor invoices) via Zaps. Possibly the richest historical dataset. | API token → `~/.openclaw/secrets/airtable-api-key.txt` + base ID(s) |
| **Slab** | SOPs (outdated but useful as baseline), process docs, company knowledge base | API token → `~/.openclaw/secrets/slab-api-key.txt` |
| **Company Gmail (services@)** ✅ | Customer emails, support threads, booking confirmations, ALL customer-facing email | `~/.openclaw/secrets/gmail-services-app-password.txt` — connected Mar 12 |
| **Google Drive** | Mixed old+new: docs, marketing materials, misc business files | Share relevant folders with service account: harvey@sapient-magnet-421318.iam.gserviceaccount.com OR add Drive scope |
| **Dropbox** | Historical files, marketing materials, business docs | API token → `~/.openclaw/secrets/dropbox-api-key.txt` |
| **FrontApp Export** | Years of customer emails and communication history | Location of export files (Mike's computer? Drive? Dropbox?) |
| **ClickUp** | Old task/project data (sporadic use, partially outdated) | API token if worth pulling, or export |
| **Canva** | Marketing materials, designs, brand assets | API access or manual export of key assets |

## Data Intelligence Notes (from Mike, Mar 12)
- SOPs in Slab are out of date but useful as baseline for building new ones
- Complaint/feedback templates are weak — need to BUILD a new standardized process
- Service definitions: scan nomorechores.com for current info
- Contractor rate cards: Mike will point to where they are
- Marketing materials scattered across Dropbox, Drive, Canva, GHL, local computer
- Customer tiers: currently just by frequency. Recurring = highest value. Mike wants to rethink this.
- Contractor photos/before-afters: HIGH PRIORITY — content for quality standards AND marketing
- Airtable: syncing L27 via Zaps since near the beginning (~10 years of data potentially)
- Launch27 API is decommissioned — Airtable may be the only way to access historical booking data
- ClickUp: stopped using it, data is old but may have useful historical context