Process Automation & Workflows

Manual data entry is expensive, error-prone, and soul-crushing. The automation projects on this page replace repetitive human tasks with Python scripts that run continuously on Synology NAS hardware — no cloud subscriptions, no API rate limits, no monthly fees. When an invoice email arrives, it gets downloaded, parsed, and converted to a CSV file ready for accounting import before anyone even opens their inbox.

The invoice pipeline alone saves hours of weekly manual work. Instead of an accounts payable clerk opening each email, downloading the PDF, copying line items into a spreadsheet, and filing the original — a two-stage Python pipeline handles all of it automatically. Stage one monitors email files for invoice URLs and downloads the PDFs. Stage two watches for those PDFs, extracts the data with pdfplumber, and generates properly formatted CSV files with standardized naming conventions.

These automations are built for reliability, not novelty. They use Python's watchdog library for file system monitoring, which means they detect new files within milliseconds and process them immediately. Error handling includes automatic retries, logging, and alerting so nothing falls through the cracks. The IT dashboard generator takes a different approach — instead of monitoring in real time, it aggregates infrastructure data on demand and renders it into a clean HTML report using Jinja2 templates, giving a snapshot of server health across the entire stack.