How it works
Google Drive
Every file: raw footage, V+S edits, finished renders (_ENGINE/02-review), thumbnails. Nothing is deleted unless it's saved here.
GitHub
The engine: rules, brand voice, scripts, scrapers and agents (andrewpreneur/content-management), video components (andrews-components) and this app (content-hq).
Convex
The live data this app shows: post queue, approvals, library of everything posted, YouTube upload tracker.
The loop
- You film what's on the filming list and drop it in Drive.
- Agents make the content (reels, carousels, captions, ads) and add it to the post queue.
- You tap Approve, Change (one-line note) or Skip in the Post queue. That's your only job.
- The scheduler drafts approved posts in GHL Social Planner at their slot, inside the daily limits. Threads, X, Skool and email come as copy-paste text.
- The scraper refreshes the Library from YouTube, TikTok and Instagram, and the upload checker compares the Drive V+S folders with the YouTube channel.
- The reporter pulls weekly numbers and feeds the next plan.
Saving changes
Approvals and "mark uploaded" need the team passcode (asked once per device). Agents read your taps from Convex and write them back to GitHub so the repo stays the backup.