LAB STATUS // ACTIVE
BACK TO ALL BUILDSSYSTEM_DOSSIER // 06
Serverless Data Ingestion
SHIPPED

Newsletter Herald

Automated liturgical bulletin processing, dual LLM summarization & distribution

Key Metrics: Dual LLM Route • R2 Proxy Delivery • Zero-Cost Cloud Pipeline

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