Project
Automating personalization at scale
Overview
Designed and built the entire production pipeline for Book of Stars (Csillagkönyv) from scratch, enabling fully automated generation of personalized astrology books from order placement through print-ready files and fulfillment.
The Challenge
Each book required a unique natal chart calculation based on the customer's exact birth date, time, and location, with personalized content generated from that data. Manually producing even a handful of books would be time-prohibitive, and scaling to thousands of orders while maintaining quality seemed impossible without significant headcount.
The Solution
I built an end-to-end automation pipeline using Python, webhooks, multiple external APIs, and Google Sheets as a lightweight database. When a customer placed an order, the system automatically calculated their natal chart in real time, generated their personalized book by assembling pre-made content panels based on their unique astrological profile, and ran the output through multiple automated QA checks. Each book was assigned a unique barcode that linked to its corresponding shipping label, and all print-ready files were uploaded to an AWS server accessible by our external print partner.
On the fulfillment side, I built a separate software tool for the print shop location. Workers scanned each book's barcode, and the system instantly printed the matching shipping label via thermal printer, eliminating manual lookup and virtually eliminating mismatch errors. The entire pipeline transformed what would have been hours of manual work per book into a streamlined, near-touchless operation.
Results
- ▹Production time of 100 personalized books in under 1 hour (including manual QA)
- ▹Error rate of less than 1 in 1,000 orders
- ▹Zero additional headcount needed to scale from 0 to 10,000+ books sold
- ▹Enabled expansion to 4 countries without rebuilding infrastructure