I believe what you suggested is highly possible, you can send a copy of the form to Google Apps scripts but i am not sure if the google apps scripts is easy to edit. I also would suggest you to check Power Automate, I already have a working setup that is working more than a year without any error, easier for everyone to understand and edit. If you have any questions i can answer.
