NVRMND Weekly Reports — STATUS

Overview Tasks Crons Activity Chat Raw MD

Raw STATUS.md

# NVRMND Weekly Reports — STATUS

**Linear project:** [NVRMND Weekly Reports](https://linear.app/hippochat/project/5509adceec74)
**Sheet:** [Weekly Fundraising Report](https://docs.google.com/spreadsheets/d/1nQoKh3lqgZsM0udum69BvvNw_lKKcK7f37nCIzMKb1c/edit)
**Spec:** `SPEC.md`
**Status:** Active — Building Tab 0 Dashboard
**Updated:** 2026-02-19

---

## Architecture

**Google Apps Script** (runs Monday 7 AM PST) → HubSpot CRM API → Google Sheet (8 tabs)

Tab 0: Dashboard (charts), Tabs 1–5: automated data, Tabs 6–7: manual (create-once)

---

## Milestones

- [x] Spec finalized (received 2026-02-19)
- [x] HubSpot pipeline + private app token — handled via setupScript() in GAS
- [ ] HubSpot custom properties (last_touch_date, next_step, stage_change_reason, source_tag) — manual setup, non-blocking
- [ ] Google Sheets — confirm access for script
- [x] GAS: Core infrastructure (helpers, config, error handling)
- [x] GAS: Tab 1 Pipeline Snapshot + Tab 2 Activity Scorecard
- [x] GAS: Tab 3 Stage Movement Log + Tab 4 Stalled Deals + Tab 5 Overdue Tasks
- [x] GAS: Manual tabs init (6 & 7)
- [ ] GAS: Tab 0 Dashboard — charts from all data tabs (MIN-1282)
- [ ] Testing & validation with real data
- [ ] Trigger deployed (Monday 7 AM PST)
- [ ] Live ✅

---

## Linear Issues

| Issue | Title | Status |
|-------|-------|--------|
| MIN-1273 | Spec intake | Done |
| MIN-1276 | HubSpot prerequisites | Done |
| MIN-1275 | GAS: Core infrastructure | Done |
| MIN-1278 | GAS: Tab 1 + Tab 2 | Done |
| MIN-1277 | GAS: Tab 3 + Tab 4 + Tab 5 | Done |
| MIN-1279 | GAS: Manual tabs + trigger setup | Done |
| MIN-1282 | GAS: Tab 0 Dashboard | In Progress |
| MIN-1280 | Testing, validation, deployment | In Progress |

---

## Tasks

### Active
- [ ] [T1] Write Tab 0 Dashboard (MIN-1282) — KPI cells + 4 charts from Tabs 1–5

### Backlog
- [ ] [T2] Manual HubSpot custom properties setup (non-blocking for dev)
- [ ] [T3] Test end-to-end with real HubSpot data (MIN-1280)
- [ ] [T4] Deploy trigger + confirm Monday 7 AM runs

### Done
- [x] [T0] Spec intake + project scaffold (2026-02-19)
- [x] All 5 data tabs + 2 manual tabs implemented
- [x] Pipeline + token prereqs resolved via setupScript()

---

## Open Questions

1. **HubSpot custom properties** — manual creation needed: `last_touch_date` (Date), `next_step` (Text), `stage_change_reason` (Textarea) on deals; `source_tag` (Dropdown) on contacts. Non-blocking.
2. **Google Sheet access** — who owns the sheet? Apps Script runs under the owning Google account.

Last activity: 2026-04-02

Loading project...

Raw STATUS.md

# NVRMND Weekly Reports — STATUS **Linear project:** [NVRMND Weekly Reports](https://linear.app/hippochat/project/5509adceec74) **Sheet:** [Weekly Fundraising Report](https://docs.google.com/spreadsheets/d/1nQoKh3lqgZsM0udum69BvvNw_lKKcK7f37nCIzMKb1c/edit) **Spec:** `SPEC.md` **Status:** Active — Building Tab 0 Dashboard **Updated:** 2026-02-19 --- ## Architecture **Google Apps Script** (runs Monday 7 AM PST) → HubSpot CRM API → Google Sheet (8 tabs) Tab 0: Dashboard (charts), Tabs 1–5: automated data, Tabs 6–7: manual (create-once) --- ## Milestones - [x] Spec finalized (received 2026-02-19) - [x] HubSpot pipeline + private app token — handled via setupScript() in GAS - [ ] HubSpot custom properties (last_touch_date, next_step, stage_change_reason, source_tag) — manual setup, non-blocking - [ ] Google Sheets — confirm access for script - [x] GAS: Core infrastructure (helpers, config, error handling) - [x] GAS: Tab 1 Pipeline Snapshot + Tab 2 Activity Scorecard - [x] GAS: Tab 3 Stage Movement Log + Tab 4 Stalled Deals + Tab 5 Overdue Tasks - [x] GAS: Manual tabs init (6 & 7) - [ ] GAS: Tab 0 Dashboard — charts from all data tabs (MIN-1282) - [ ] Testing & validation with real data - [ ] Trigger deployed (Monday 7 AM PST) - [ ] Live ✅ --- ## Linear Issues | Issue | Title | Status | |-------|-------|--------| | MIN-1273 | Spec intake | Done | | MIN-1276 | HubSpot prerequisites | Done | | MIN-1275 | GAS: Core infrastructure | Done | | MIN-1278 | GAS: Tab 1 + Tab 2 | Done | | MIN-1277 | GAS: Tab 3 + Tab 4 + Tab 5 | Done | | MIN-1279 | GAS: Manual tabs + trigger setup | Done | | MIN-1282 | GAS: Tab 0 Dashboard | In Progress | | MIN-1280 | Testing, validation, deployment | In Progress | --- ## Tasks ### Active - [ ] [T1] Write Tab 0 Dashboard (MIN-1282) — KPI cells + 4 charts from Tabs 1–5 ### Backlog - [ ] [T2] Manual HubSpot custom properties setup (non-blocking for dev) - [ ] [T3] Test end-to-end with real HubSpot data (MIN-1280) - [ ] [T4] Deploy trigger + confirm Monday 7 AM runs ### Done - [x] [T0] Spec intake + project scaffold (2026-02-19) - [x] All 5 data tabs + 2 manual tabs implemented - [x] Pipeline + token prereqs resolved via setupScript() --- ## Open Questions 1. **HubSpot custom properties** — manual creation needed: `last_touch_date` (Date), `next_step` (Text), `stage_change_reason` (Textarea) on deals; `source_tag` (Dropdown) on contacts. Non-blocking. 2. **Google Sheet access** — who owns the sheet? Apps Script runs under the owning Google account.