Renaming 13,000+ files for a US-based marketing agency with an automation integrating Gemini AI capabilities, saving 216+ hours of manual work.
How Gemini AI and Google Apps Script rescued a marketing agency from a file-naming crisis, renaming 13,000+ Google Drive files by content in a single afternoon.
02: The Crisis
13,000 files. Zero readable names.
The agency had been capturing thousands of photos and videos for a client project. But every single file in their Google Drive had an auto-generated, unreadable name, and the client had noticed. The deadline was approaching, and manual renaming would take weeks.
Unreadable filenames
Over 13,000 files had auto-generated names like 'IMG_20240315_092847.jpg', making it impossible for anyone to find or identify content without opening each file individually.
Client frustration
The client had specifically flagged the chaotic file names and requested meaningful renaming before delivery. The agency's professional reputation was on the line.
Impossible manual timeline
Renaming each file by hand, opening it, analyzing the content, writing a descriptive name, would have taken weeks of full-time work the team didn't have.
Delivery deadline at risk
The project deadline was imminent. Missing it would jeopardize the client relationship and potentially cost the agency future business.
This was a business-threatening situation. Manual renaming would have missed the deadline, damaged the client relationship, and potentially cost the agency future contracts. The team needed a solution that worked in hours, not weeks.
03: The Solution
AI That Sees and Names
Flowbetta built a custom automation pipeline that combined Gemini AI's vision capabilities with Google Apps Script, allowing the system to analyze each file's actual content and generate a meaningful, descriptive filename automatically.
The solution worked entirely within their existing Google Drive, required no migration or new software, and preserved the original folder structure throughout the process.
AI Content Analysis
Each image and video was passed to Gemini AI, which analyzed the visual content, identifying products, people, settings, and key details to understand what each file actually contained.
Intelligent Name Generation
Based on the content analysis, the AI generated a descriptive, human-readable filename for each file, transforming 'IMG_20240315_092847.jpg' into something like 'green-smoothie-product-shot-kitchen.jpg'.
Bulk Rename Execution
The automation processed files in optimized batches, renaming thousands of files directly in Google Drive without moving, duplicating, or disrupting the existing folder hierarchy.
Structure Preservation
The original folder organization was kept completely intact. Files stayed in their existing locations, only their names changed, making the transformation seamless for the team.
Quality Verification
Built-in checks ensured every file received a valid, meaningful name. Edge cases, like blurry images or ambiguous content, were flagged for human review rather than guessed.
04: The Impact
Crisis averted. Client impressed.
The automation transformed what would have been weeks of tedious manual work into a few hours resolution, saving the project, the deadline, and the client relationship.
Files Renamed
Every file in the Drive received a meaningful, content-based name, automatically and accurately.
Time Saved
Over 216 hours of manual work eliminated, the equivalent of more than 5 full work weeks.
On-Time Delivery
The project was delivered to the client on schedule, with professionally organized files.
Client Satisfaction
The agency maintained their client relationship and established better file management for future projects.
Working with Joseph has been an absolute game-changer for our team. He brings not only deep technical expertise but also a strategic mindset that consistently elevates our workflows. Joseph has a rare ability to simplify complex systems, build elegant solutions, and deliver results that are both scalable and sustainable. Simply put, Joseph is exceptional at what he does, and a pleasure to work with.
