I had 48,000 files on Google Drive. Five terabytes of video, photos, documents. No naming convention. No folder structure. My editors spent 20 minutes searching for a single clip.
So I built an AI system to fix it. One overnight run. Zero cost. Here’s exactly what I did.
The Problem
Only 34% of my files followed any kind of naming convention. The rest were things like IMG_4829.MOV, Bali B roll computer, JOBS, screenshots. Folders inside folders inside folders with no logic.
When my editors needed a drone shot from Bali, they’d scroll through thousands of files hoping to recognize a thumbnail. Twenty minutes to find one clip. That’s not a workflow. That’s a treasure hunt.
Step 1: Catalog Everything
I wrote a Python script that walked through all 48,000 files and logged every path, filename, file size, date, and extension into a spreadsheet. Took about 90 seconds.
That gave me a map of the mess. 72% of my storage was video, 15% photos, and the rest was documents, audio, and screenshots scattered everywhere.
Step 2: AI Describes Every Video
This is the part that changed everything. I wrote a second script that pulls one frame from each video using FFmpeg, sends it to Google’s Gemini AI (free tier), and gets back a description.
Wedding ceremony footage, bride walking down aisle, outdoor garden setting.
Aerial drone shot, Bali rice terraces at sunset, golden hour.
Talking head, man speaking to camera about pricing.
5,733 videos analyzed. 19 content categories tagged automatically. The AI knew the difference between B-roll, interviews, drone footage, screen recordings, and talking heads.
Total cost: $0. Gemini’s free API tier handled all of it.
Step 3: Auto-Sort Into 7 Folders
The third script read every file’s tags and moved it to the right folder:
01_ACTIVE PROJECTS: Videos still being edited + ready to post
02_B-ROLL LIBRARY: Sorted by category: Travel, Tech, Lifestyle, Nature
03_POSTED CONTENT: Published videos only
04_CLIENT WORK: Photography jobs organized by client name
05_BUSINESS: Contracts, SOPs, training materials
06_TEMPLATES: Thumbnails, branding assets, screenshots
07_ARCHIVE: Old raw footage for long-term storage
53,220 files moved in 19 seconds. Google Drive’s file system treats moves as metadata changes, so nothing had to re-download. Just instant reorganization.
Step 4: Searchable Content Database
I built an HTML search tool that sits on my Drive. My editors open it, type “drone bali sunset,” and get instant results with AI descriptions and category tags. No more scrolling through folders.
Finding a clip went from 20 minutes to 5 seconds.
The Results
53,220 files reorganized
5,733 videos described by AI
19 content categories auto-tagged
$0 total cost
1 overnight run
My editors now open Google Drive and find what they need immediately. The folder structure makes sense. The search tool handles everything else.
The Folder Structure
Here’s the exact structure I used. Every top-level folder has a number prefix so they always sort in order:
01_ACTIVE PROJECTS/ To Edit/ Ready To Post/ 02_B-ROLL LIBRARY/ Travel/ Tech/ Lifestyle/ Nature/ Events/ 03_POSTED CONTENT/ Reels/ YouTube/ Interviews/ 04_CLIENT WORK/ [Client Name]/ 05_BUSINESS/ Contracts/ SOPs/ Training/ 06_TEMPLATES/ Thumbnails/ Branding/ 07_ARCHIVE/ [Year]/
Scripts I Used
Script 1: File Catalog: Walks the entire Drive folder, logs every file’s path, size, date, and extension to a spreadsheet.
Script 2: AI Video Analysis: Extracts one frame per video with FFmpeg, sends it to Gemini 2.5 Flash for a description, tags it into one of 19 categories.
Script 3: Auto-Sort: Reads the tags and categories, creates the folder structure, moves every file to its new home.
The whole system ran overnight while I slept. I woke up to an organized Drive.
This Is One Piece of the System I Build for Clients
The full system: one 2-hour recording session turns into 30 Reels. AI handles the editing, sorting, and scheduling. Everything gets auto-posted daily. You own the whole thing in 3 months.
Most creators and experts I work with have real expertise and real revenue. Their content just doesn’t match their caliber. They’ve tried agencies, videographers, ads. Nothing stuck because nobody built them a system.
If you want me to personally help you build a content system for your business, I have a few spots open for free strategy calls.