Automated
File Sorter.

The Overview

The Automated File Sorter eliminates the tedious, error-prone process of manually organizing files across SharePoint libraries. It was used to move 1.5 Terabyte of data fully automated. Built as an internal automation tool, it monitors designated folders and automatically classifies, renames, and routes documents to their correct destinations based on configurable rules — saving hours of repetitive administrative work each week.

How It Works

The automation pipeline follows a clear, rule-based flow to ensure accurate and consistent file organization:

• File DetectionMonitors incoming files in designated SharePoint drop zones, detecting new uploads in real time via the Microsoft Graph API.
• Classification EngineAnalyzes file metadata — name patterns, file type, and timestamps — against a set of configurable sorting rules to determine the correct destination.
• Automated RoutingMoves each file to its designated SharePoint folder or library, applying standardized naming conventions and folder structures.
• Logging & Error HandlingEvery operation is logged for auditability. Failed operations are flagged and queued for retry, ensuring no file is lost in transit.

Architecture & Integration

The solution is built in Python and leverages the Microsoft Graph API for seamless integration with SharePoint Online. Authentication is handled through Azure Active Directory app registrations, ensuring secure, token-based access to organizational resources. The modular architecture allows sorting rules to be updated independently, making it easy to adapt to changing organizational file structures without modifying the core automation logic.