Hi there!
I will be happy to help you with that one. The script will be activated when the form is submitted, then it will read the user response, add the data into the spreadsheet and send the email.
It can also add dynamic fields into the email, like adding the recipient name to the email body.
I will be happy to address any of your questions!
Sincerely,
Mohamed