~/sajjad $ cat projects/invoice-pipeline
← cd ../projects
Data & reporting
Invoice pipeline automation
Working
Sweeps a full week of mailbox traffic, extracts invoice attachments in mixed formats — PDFs and photographed invoices — and files them by week and supplier. Feeds the weekly cost-of-sales cycle.
Two failed approaches first
- The local mail store never pre-fetches server attachments — roughly 1,200 of 5,000 messages sat as partial files with nothing attached, and forcing a download made it worse.
- The low-code route died on licensing: the mailbox licence was mail-only with no file storage, so the platform could read the mailbox but had nowhere to write.
Re-architected server-side against the Graph API with device-code authentication and a cached token. Runs on the standard library alone.