# From Manual Filing to Automatic Document Intake

> Automation that turns incoming documents into filed, logged, and findable records, without anyone watching an inbox.

Section: Zapier Automations

Page: https://mburhan.com/case/case-study-from-manual-filing-to-automatic-document-intake

## Overview

Documents used to arrive, sit in an inbox, and wait for someone to notice them, open them, and put them where they belonged. Now they file themselves correctly, every time, with a record left behind.

### The Problem

A document lands in someone’s inbox, and for a while, nobody knows it is there. Maybe it is the filing that should have gone out yesterday. Maybe it is the one that got missed last month, found only after a client called asking where it went. Every day comes down to one person checking an inbox, guessing what matters, and hoping nothing slips through. One missed email is the difference between on time and in real trouble.

### How It Works

The automation sits where the person used to sit, watching the inbox, and runs through the same checks in the same order, without getting tired or distracted partway through:

1. **Watch for the right emails.** It recognizes incoming filings by sender and subject, and ignores everything else.
2. **Confirm there’s actually something attached.** No attachment, no work to do. It moves on instead of acting on an empty notification.
3. **Pull out what matters.** The case number, the subject, and the attachment itself are lifted out of the email automatically.
4. **Log it immediately.** Before anything else happens, the document is recorded in a running sheet, so there’s a timestamped record that it arrived, even before it’s filed.
5. **Check for duplicates.** It looks up whether this exact document has already been filed, so the same thing doesn’t get added twice.
6. **Find the right home.** It looks up the matching folder by case number. If that folder doesn’t exist, nothing gets misfiled into the wrong place.
7. **File it, and say so.** The document is uploaded, and the log is updated to say whether it was newly added or already existed.
8. **Catch failures out loud.** If any step fails, that failure is written into the log instead of disappearing silently, so nothing goes missing without someone knowing.

### The Result

Nobody checks the inbox to find out whether a new filing came in. It is simply already in the right folder by the time anyone looks. The running log answers “did we get this?” on sight instead of requiring a search. Duplicate filings are caught automatically rather than relying on someone to notice a repeat. And when something does fail, it shows up in the log as a visible flag instead of quietly vanishing.

Image (https://mburhan.com/uploads/2eb89e00fb9b0a9f9a64ea9b.png)

Image (https://mburhan.com/uploads/1a7fb6608ba0483a6c6255d1.png)

Image (https://mburhan.com/uploads/f496505a848e981d961535e9.png)

## Tech Stack

- **Microsoft Outlook:** where the pleading emails arrive, sorted into a dedicated folder the automation watches.
- **Zapier:** runs the whole process in the background, handling each attachment separately when several pleadings come in one email.
- **Google Sheets:** the running log, with a row for every pleading showing its case number, file name, time received, and whether it was filed.
- **Box.com:** where each pleading lands, inside the folder that matches its case number.

## Where This Pattern Applies

This isn’t really a story about legal filings. Picture the same automation watching a different inbox for a different business.

A supplier emails an order confirmation. The automation checks it has an attachment, pulls out the purchase order number instead of a case number, logs the confirmation the moment it lands, checks whether it’s already been recorded, finds the folder for that purchase order, and files it, flagging anything that doesn’t match a known order instead of losing track of it.

Swap “purchase order number” for whatever identifier matters in your world, and the same shape shows up everywhere:

- **Insurance:** claims, policy documents, adjuster reports
- **Sales & legal:** signed contracts, NDAs, pleadings, compliance acknowledgments
- **HR & recruiting:** onboarding paperwork, offer letters, background checks
- **Finance & accounting:** vendor invoices, receipts, expense reports, reconciliations
- **Healthcare:** patient intake forms, lab results, referral letters
- **Real estate:** leases, inspection reports, closing documents
- **Logistics & supply chain:** shipping confirmations, customs paperwork, delivery receipts
- **Customer support:** ticket attachments, warranty claims, return requests
- **Government & permitting:** applications, licenses, inspection filings
- **Education:** student applications, transcripts, enrollment forms

The shape never changes: watch, verify, extract, log, match the destination, file, confirm. What changes is only which number you’re matching against. Whatever industry it sits in, the win is the same. Nobody has to be the one remembering to check.
