Dynamic Email Personalization GUI System with Excel Integration

We developed a Python-based email automation system with a graphical user interface (GUI), integrating Excel to personalize and send 120 customized emails in under two minutes for a campus event organizer. The application allows for unlimited simultaneous sending of customized emails with different content, utilizing a graphical user interface to significantly enhance the sender's efficiency.
Github Repo Link: CaslowChien/Mass-Customize-Gmail-Sender

My Contribution

Developed a Python email automation system with a GUI.
Created a email sending system linked to the response cheets for personalized massive emails.
Assisted an art organization on campus by sending 120 customized emails in two minutes, saving four hours of work.

Final User Manual

Final Presentation Slides

Final Presentation Video

UI / UX

Since the project is aimed for daily user. I coded a GUI for this system from scratch and consider many UX/UI factors.

Data Cleansing

The system allows users to input an Excel or CSV file. Therefore, we had to clearly define the background cleaning process and error responses to ensure the system works properly.

Project Management

I took on the roles of product manager and data engineer in this project, leading the team toward our common goals with great communication and a friendly environment.

Copyright © Vanessa Huang, modified by Caslow Chien, 2024.