Internal Systems Audit

Getting Obsidian, ClickUp, and Google Drive to agree

A ground-truth scan of all three systems, what is actually misaligned, and a concrete plan to give them one shared spine. The short version: the three tools are not the problem. They have three different organizing principles and no shared key, so every session files things differently.

Prepared by Woz, 2026-06-07. Sources: live filesystem scan of ~/Documents/AceHQ, ClickUp workspace hierarchy API, and gog drive listings across both Google accounts. Every count below carries its source.

1The one-sentence diagnosis

Each system organizes the same businesses by a different axis, and inside each system the rules drifted from reality, so agents (me included) file the same thing in two or three places.

Obsidian groups by topic folder, ClickUp groups THM by legal entity and eComHD by function, and Drive splits everything across two Google accounts and 17 shared drives. There is no shared join key tying "the HOURP hotel" together across the three. Fixing the tools means picking one spine and making all three mirror it.

618
non-markdown files sitting in the Obsidian vault, which is supposed to hold zero (vault scan 2026-06-07)
3
separate places THM lives inside ClickUp (workspace hierarchy API 2026-06-07)
4
empty "Vault" spaces in ClickUp that mirror nothing (workspace hierarchy API 2026-06-07)

2How the same business looks in each system

This table is the heart of the problem. Read each row left to right: the same entity wears a different name and a different shape in every tool. There is no consistent key a human or an agent can follow.

EntityObsidian (folder)ClickUp (space / folder)Google DriveAligned?
THM (hotels) 20-business/THM by property code (HOURP, HOUUS, HOUZN, HOUZV) Space "Texas Hotel MGT" by legal entity (HI Hotels LP, Rodeo Hotels LP, Howdy Hotels LP) plus "THM-General / THM-HOUZN / THM-HOUUS" folders in the ACE space plus an empty "THM Vault" space 5 separate drives: Hotel Research, THM-Accounting, THM-Admin, THM-Hotels, THM-Resources. THM-Hotels uses property codes (HOURP, HOUZN, DFWCE...) No, 3 axes
eComHD 20-business/eComHD Space "eComHD" by function, folders numbered 01-08 plus an "eComHD" folder in the ACE space Drive "eComHD", folders numbered 00-08 by function Mostly, see #4
RevParPro (the product) 20-business/RevParPro (specs, projects, sessions) Folder "RPP - RevPAR Pro" nested inside the eComHD space (11 phase lists) plus an empty "RevPAR Pro Vault" space No dedicated drive (it is a software product, lives in the code repo) No, misfiled
MHD 20-business/MHD by sub-entity LLC Space "Management HD" by sub-entity LLC plus a "Management HD" folder in the ACE space Drive "Management HD" + a separate "Accounting" drive Close
StickyMetrics 20-business/StickyMetrics Empty "StickyMetrics Vault" space, no task space No dedicated drive Vault only
UF (Umbrella Fund) 20-business/UF "Umbrella Fund" folder inside the ACE space (not surfaced this scan) Thin
Personal 30-personal (family, finance, health, travel, wine, home) Scattered across the ACE space: "Personal", "Travel", "Wine Cellar" folders Mixed into personal Drives Scattered

Source: ClickUp get_workspace_hierarchy (14 spaces) and gog drive drives on both accounts, 2026-06-07.

3What is broken inside each system

Obsidian: two taxonomies running at once

The vault was renamed to a numbered structure (00-system, 10-agents, 20-business, 30-personal, 80-archive), but the rulebook that is supposed to govern it, 00-system/TAXONOMY.md, still describes the old structure (businesses/, personal/, references/). The rulebook and the reality disagree, which is exactly why filing drifts.

ClickUp: THM and RevParPro live in the wrong places, plus empty shells

Google Drive: the most coherent of the three, just split by account

Drive is in the best shape. It is split cleanly by Google account: THM lives under ace@texashotelmgt.com (5 drives), everything else under ace@ecomhd.com (12 drives). That account boundary is reasonable and worth keeping. Two things to note:

4The model that already works: eComHD

eComHD is the proof that congruence is achievable. Its Drive folders and its ClickUp folders use the same numbered functional spine:

FunctionDrive folderClickUp folder
Brand Management01 - eHD - Brand Management01 - eHD - Brand Management
Product Development02 - eHD - Product Development02 - eHD - Product Development
Supply Chain03 - eHD - Supply Chain03 - eHD - Supply Chain
Amazon Marketing04 - eHD - Amazon Marketing04 - eHD - Amazon Marketing
Graphics05 - eHD - Graphics05 - eHD - Graphics

A person or agent who knows "03 is supply chain" finds it the same way in both tools. THM has no equivalent. The fix is to give THM (and the others) the same treatment, using the property code as the shared number.

5The recommendation: one spine, three layers

Do not try to make the three tools hold the same content. Make them hold the same spine while each plays a distinct role. Congruence is "same skeleton, different organ," not "three copies of everything."

5a. Give every system one role, and stop the overlap

SystemIts one jobWhat does NOT belong there
Google DriveThe file store. Source documents and binaries: OMs, financials, STR reports, photos, spreadsheets, PDFs.Tasks, decisions, analysis prose.
ClickUpThe action layer. What needs doing, by whom, by when, and its status.Reference docs, file storage, knowledge notes.
ObsidianThe brain. Synthesis, decisions, analyses, session recaps, the connective tissue that links a Drive file to a ClickUp task.Binaries, scratch workspaces, raw data dumps.

A single hotel then looks like this across the three: the HOURP Drive folder holds the documents, the HOURP tasks in ClickUp track the work, and an Obsidian note named for HOURP links to both and holds the thinking. Same key, three layers.

5b. Lock the shared spine

5c. Decide what ClickUp's empty "Vault" spaces were for

The four empty "* Vault" spaces suggest someone wanted ClickUp to also be the knowledge base. My recommendation is no: Obsidian is the brain, ClickUp is the action layer. Delete the four empty spaces rather than populate them. If you want ClickUp tasks to reach knowledge, link out to the Obsidian note instead of duplicating it.

6The cleanup, in priority order

These are the concrete moves. Roughly top to bottom by impact-per-effort. I can execute any of these on your say-so; none are destructive without your go-ahead.

1
Update TAXONOMY.md to match the numbered reality, then delete the dead trees.
Rewrite the rulebook to describe 20-business / 30-personal / 10-agents / 00-system as it actually is. Then merge the handful of stray recent notes out of businesses/ and personal/ into their live equivalents and delete the dead folders. This is the single highest-leverage fix because the stale rulebook is the root cause of the double-filing. root cause
2
Evict the 618 non-markdown files from the vault.
Move the houzn-houzv-gap/ scratch workspace (about 95% of the violations) to the THM-Hotels Drive under HOUZN, or delete it if it was throwaway analysis. Sweep the remaining txt/PDF/xlsx out the same way. Remove the nested .obsidian/ inside 20-business/THM. md-only rule
3
Move RevParPro out of the eComHD ClickUp space.
Promote "RPP - RevPAR Pro" to its own top-level space (or reuse the empty "RevPAR Pro Vault" space, renamed). It is a hotel-tech product, not an Amazon brand. miscategorized
4
Consolidate THM in ClickUp to one space.
Fold the "THM-General / THM-HOUZN / THM-HOUUS" folders from the personal ACE space into "Texas Hotel MGT", and delete the empty "THM Vault" space. Decide on property-code organization while you are in there. 3 places to 1
5
Delete the 4 empty "Vault" spaces.
THM Vault, RevPAR Pro Vault, StickyMetrics Vault, AceOfBase Vault hold nothing and imply a structure that does not exist. cruft
6
Collapse the eComHD meeting-list sprawl.
Turn the 30-plus dated lists in "08 Team Meeting" into tasks inside one or two recurring lists (one for PPC/BM, one for Supply Chain). tidy
7
Write the property-code map note and the spine into the rulebook.
One Obsidian note mapping property code to LP entity to H### deal code, plus a short "where things go" section in TAXONOMY.md covering all three systems, not just the vault. This is what keeps it congruent after the cleanup. durable

7Open items I did not assume