Hi there,
I will be happy to help you with that project. We can create a Google Script and bound it to the form. Then install onSubmit trigger for the script, when a new submission is submitted, the script will perform the six tasks you described in the job description.
I will be happy to address any of your questions!
Sincerely,
Mohamed