About the Project
Inspiration
Universities and student organizations frequently need to send hundreds of personalized emails for tasks such as certificate distribution, assignment notifications, event confirmations, and announcements. Most of this process is done manually, which is time-consuming and prone to mistakes like sending the wrong attachment or incorrect recipient details.
We wanted to solve this problem by creating a system that can automate personalized email communication at scale. Our goal was to allow organizers and faculty to generate professional emails, personalize them automatically, and send them to large groups with minimal effort.
What the Project Does
Draftpal is an AI-powered email automation platform designed to simplify large-scale personalized communication. Users can create email templates, upload an Excel sheet containing recipient details, and automatically send customized emails to hundreds of recipients at once.
The platform supports dynamic placeholders such as {{name}}, {{event_name}}, and {{certificate_link}}, which are automatically replaced with data from the uploaded spreadsheet.
Draftpal can be used for multiple university workflows including certificate distribution after events, assignment submission notifications, event confirmations, and automated reminders.
How We Built It
We built Draftpal using a full-stack architecture:
- Frontend: React / Next.js for an intuitive user interface and template editor.
- Backend: Node.js with Express to process email workflows and handle personalization logic.
- Data Processing: Excel parsing libraries to extract recipient information and dynamic fields.
- Email Service: SMTP/Nodemailer to send bulk personalized emails.
- AI Integration: Gemini API to generate email templates, improve email wording, and suggest dynamic placeholders based on uploaded data.
Challenges We Faced
One of the biggest challenges was building a reliable system that could dynamically replace placeholders for each recipient while maintaining performance when sending many emails. Another challenge was ensuring HTML email templates render correctly across different email clients.
We also had to carefully integrate AI features so they provide meaningful assistance, such as generating useful templates and improving email content.
What We Learned
Through this project, we learned how to design scalable automation systems and handle dynamic content generation from structured data like spreadsheets. We also gained experience integrating AI tools to improve productivity and user experience.
Additionally, we learned how important good workflow design is when building automation tools that are meant to simplify repetitive tasks.
Future Improvements
In the future, we plan to expand Draftpal with additional features such as automated certificate generation, workflow automation triggers, email analytics, and deeper integration with university systems.
Our vision is to turn Draftpal into a complete communication automation platform that helps universities and organizations manage large-scale personalized communication efficiently.
Log in or sign up for Devpost to join the conversation.