Back to Portfolio
Case Study

Automated WhatsApp Media Storage & Folder Management System

Smart, rule-based workflow that organizes WhatsApp media files at scale with dynamic folder hierarchies

ABOUT THIS PROJECT

The client needed a fully automated solution for capturing WhatsApp Business incoming media (images, videos, audio, files), identifying senders based on email/phone, fetching existing folder structure from backend, creating Year → Company → Month → Date folders dynamically, uploading each media file in serial order inside its correct date folder, keeping logs and backend records in sync, and handling 6+ branching scenarios depending on folder existence. The earlier approach was manual, prone to human error, and did not maintain any consistent storage rules.

Result:

This automation delivered 100% automated media management with no manual downloading or creating folders, perfectly structured Google Drive storage where every file is sorted by Year → Company → Month → Date, zero duplicates thanks to backend checks & serial file numbering, intelligent branching that handles 6+ folder existence cases seamlessly, full observability with every action logged in the backend through APIs, and high scalability supporting unlimited WhatsApp traffic.

OUR INVOLVEMENT

  • Workflow Design
  • API Integration
  • Backend Development
  • Automation Logic
  • Error Handling

TECHNOLOGIES

  • Make.com
  • WhatsApp Business Cloud API
  • Django REST APIs
  • Google Drive API
  • Database Management

Two-Workflow Architecture

We implemented a sophisticated two-workflow architecture using Make.com, Django APIs, and Google Drive to automatically store and organize all incoming WhatsApp media. The Primary Workflow handles message intake, capturing messages, extracting media type, sender info, and file URLs, then routing through media classification branches. The Secondary Workflow manages folder creation and file upload, performing user validation, determining the correct folder path from 6 possible cases, creating necessary folders dynamically, and uploading files with serial numbering.

Both workflows use the Django backend for logging, user validation, and managing the folder structure database, ensuring perfect synchronization and data integrity.
The Primary Workflow triggers on any message received on the WhatsApp Business account. It captures the message, extracts media type, sender info (email/phone), and File URL. A router instantly splits messages into separate branches for Image, Video, Audio, and Document. The workflow then triggers the Secondary Workflow by sending a payload containing email, phone, media URL, and media type to the Django API. All inbound requests are separately logged for complete traceability.
Project feature

Intelligent Folder Management - 6 Dynamic Cases

The Secondary Workflow uses the returned data from the Django API to determine the correct path through intelligent case handling. The system minimizes folder creation overhead by checking folder existence and creating only what's needed. From 'All Folders Exist' (direct upload) to 'User Does Not Exist' (admin alert), each case is handled automatically with three critical backend API calls after every successful upload: record creation, folder path storage, and detailed log entry.
100%
Automated
6 Cases
Intelligent Handling
Zero
Manual Work
WhatsApp workflow overview

Complete automation workflow architecture

Google Drive folder structure

Dynamic Year → Company → Month → Date hierarchy

Dashboard Interface

Centralized management and monitoring dashboard

Make.com workflow diagram

Advanced routing and branching logic

Perfect Organization Hierarchy

The system creates a predictable, consistent folder structure for every upload.

  • 1Google Drive Root → Year (e.g., 2025)
  • 2Year → Company (e.g., AcmeLogistics_123456)
  • 3Company → Month (e.g., January)
  • 4Month → Date (e.g., 12)
  • 5Serial file numbering (1.jpg, 2.jpg, 3.jpg...)

Dynamic Folder Management Logic

The workflow handles all possible folder existence scenarios automatically.

  • 1Case 1: All Folders Exist → Direct upload to Date folder
  • 2Case 2: Year Missing → Create Year → Company → Month → Date → Upload
  • 3Case 3: Month Missing → Use Year, Create Company → Month → Date → Upload
  • 4Case 4: Date Missing → Use Year → Company → Month, Create Date → Upload
  • 5Case 5: Company Missing → Use Year, Create Company → Month → Date → Upload
  • 6Case 6: User Does Not Exist → Send admin alert, no processing

Complete API Synchronization

Every action is tracked and logged through Django REST APIs.

  • 1/api/send-to-make-webhook/ triggers Secondary Workflow
  • 2/api/search-email/ validates user and fetches folder status
  • 3/api/create-record/ stores dashboard record for upload
  • 4/api/create-email-folder/ writes folder path to database
  • 5/api/create-make-log-entry/ creates detailed log for analytics

Key Results

1

100% Automated Media Management

No manual downloading or folder creation required

2

Zero Duplicates

Backend checks and serial file numbering ensure clean organization

3

6+ Folder Scenarios Handled

Intelligent branching handles all possible folder existence cases

4

Full Observability

Every action logged through APIs for complete traceability

The Impact

This project demonstrates how advanced routing, backend synchronization, and API-driven storage automation can completely transform media handling operations. The system supports unlimited WhatsApp traffic with perfect organization, zero manual intervention, and complete audit trails.

This automation replaces messy manual WhatsApp media handling with a smart, rule-based, multi-branch workflow that organizes all files at scale.