Email Attachment Classification and DTM Tracker Automation
Business Problem
Direct-mail emails contain multiple attachments that must be manually downloaded, classified, stored in separate folders, and logged in a tracking spreadsheet.
Solution
Designed an n8n workflow that detects selected emails, validates the sender or subject, extracts the job number, retrieves attachments, classifies files by filename and category, uploads them to the correct Google Drive folders, and updates a Google Sheets tracker.
Workflow
- 01Email Trigger
- 02Sender and Subject Filter
- 03Job Number Extraction
- 04Attachment Retrieval
- 05File Classification
- 06Conditional Routing
- 07Google Drive Upload
- 08Google Sheets Logging
- 09Missing File Validation
- 10Error Notification
Categories
Tools Used
Skills Demonstrated
Note: Uses temporary email forwarding during testing while company account permissions are being reviewed.

