Hi,
I understand your requirements, I did similar work before for one of our client, I created report from the collected data in text file once user submit the google form and email the same, I am aware of the libraries used in the same,
I will provide you the solution on your requirements, Please initiate the chat so we can discuss further on the same.
Thanks