Respected Sir/Ma'am,
I am a Full stack web developer, with 3+ years of experience in Google App Script, being a college representative, I completely understand the need of your requirements, I have implemented the exact model various times in the past for managing events and workshops using Google Forms and Sheets.
I would like to point out one limitation about the implementation of the idea, you would be able to send not more than 100 emails in 24 hours, Google's Gmail API comes with a limited quota, which gets replenished every 24 hrs.
Looking forward to discuss the implementation details with you soon.
Regards
Murtaza Sadriwala