THE PROBLEM

Chartered Accountancy firms and businesses often face "Digital Chaos" on Google Drive due to unsystematic file uploads, client-provided data with cryptic names, or inconsistent naming conventions across years.

Common pain-points:

1. Cryptic File Names: Scanned documents often arrive as IMG_202401.pdf or Scan_001.jpg, making search and retrieval impossible.
2. Manual Renaming Fatigue: Renaming hundreds of files manually is a low-value, high-effort task prone to typos and burnout.
3. Inconsistent Organisation: Lack of standardized prefixes (e.g., ClientName_AY24-25_) makes audit trails difficult to follow.
4. Time Leakage: A dedicated staff member might spend weeks organizing a single large client’s data repository.
5. Scalability Issues: Manual renaming doesn't scale; as the number of clients grows, the digital clutter becomes unmanageable.

THE SOLUTION: DriveOrganizer Pro

A custom-built Google Apps Script automation that leverages Google Sheets as a "Control Center" to perform bulk renaming and organization within Google Drive.

Key capabilities:

1. Folder ID Integration: Simply paste any Google Drive Folder ID to target a specific directory.
2. Bi-Directional Sync: Extracts existing file names into a Google Sheet for a bird's-eye view.
3. Dynamic Renaming: Supports bulk addition of Prefixes and Suffixes to standardize filenames.
4. Format Agnostic: Works seamlessly across all file types (Docs, Sheets, PPTs, PDFs) and even Folder names.
5. Real-time Preview: Allows users to see the "Desired File Name" in the sheet before committing changes to the Drive.
6. Massive Throughput: Renames 1,000+ files in approximately 60 seconds.

HOW IT WORKS

1. Input Folder ID: User enters the unique Google Drive Folder ID into a designated cell in the Google Sheet.
2. Extract File List: The script crawls the folder and lists all current file names, extensions, and file IDs in the sheet.
3. Define Logic: User inputs the desired Prefix (e.g., "Tax_Audit_") and Suffix (e.g., "_FY23-24") in the control columns.
4. Preview Generation: A formula or script-function displays a preview of how the files will look after the transformation.
5. Execute Rename: Upon clicking the "Run" button, the script iterates through the list and updates the setName() property of each file via the Google Drive API.
6. Confirmation: The sheet updates with a "Success" status for every file renamed, providing an instant audit log.

KEY BENEFITS

TECHNOLOGIES USED

1. Google Apps Script (GAS): The engine that interacts with the Google Drive API.
2. Google Sheets: The User Interface (GUI) for data entry, previewing, and status tracking.
3. ChatGPT (OpenAI): Used as the logic architect to generate and debug the JavaScript-based Apps Script code.
4. Drive API: The backend service that performs the actual file modifications.

MEASURABLE IMPACT

USE CASES

1. Audit Documentation: Standardizing "Working Paper" names across different audit folders.
2. Tax Filings: Renaming thousands of client challans or acknowledgments with PAN and Assessment Year.
3. Onboarding: Organizing client KYC documents (Aadhar, PAN, MOA) into a uniform format.
4. Historical Archiving: Converting old, messy folders into structured archives for easy retrieval during assessments.