BACK TO ALL BUILDSSYSTEM_DOSSIER // 06
Serverless Data Ingestion
SHIPPED
Newsletter Herald
Automated liturgical bulletin processing, dual LLM summarization & distribution
System Overview
An automated document processing pipeline. Parses incoming multi-megabyte PDF and Word newsletters, standardizes metadata, generates multi-stage AI summaries, and dispatches weekly newsletters to a parish subscriber directory.
Architectural Decisions & Build Log
Automated a weekly manual 4-hour parish newsletter preparation cycle into a 90-second autonomous review pipeline.
ENGINEERING SPECIFICATIONS
Dual LLM routing: dispatches real-time web tasks to Groq Cloud and delegates historical bulk parsing to local Ollama.
Cloudflare R2 presigned storage with PyMuPDF compression reducing multi-megabyte PDFs by 70%.
Neon serverless Postgres backing an admin audit log console with 1-click manual overrides.
LESSONS LEARNED & TAKEAWAYS
▸Always provide a human review gate with confidence scores before triggering email dispatch.
TECHNOLOGIES & RUNTIMES
Next.js 15FastAPINeon PostgresCloudflare R2Groq Llama 3.1Ollama Local