Personalized donor recognition documents are generated without any manual document work. The system was built and demonstrated as part of a client engagement, replacing a manual mail-merge process entirely.
The Outcome
An automation triggered by any update to a Google Sheet. The system runs a conditional check, downloads a template file, creates a personalized folder in Drive, merges donor data into the template, uploads the completed file, creates and updates a Google Doc with the donor's information, and logs the completion status back to the sheet. Every step happens automatically from a single sheet update.
What I Built
Nonprofits often recognize donors with personalized documents, letters, or acknowledgments. Producing these manually for every donor update is tedious, error-prone, and pulls staff time away from higher-value work.
The Problem
Nonprofit Donor Recognition Automation