Hello sir
I have experience in automation google forms, sheets, docs through google API and python. In this project, your form will be linked with a Google sheet. I've extract data from that sheet using Python. Once I get the data, I'll send a confirmation email to the user as well the volunteers that a new case is available. The status of the case will be maintained in the backend. Once the case is solved the volunteer can fill another form(or send any data to me) to confirm that the case is solved and I'll mark the case as solved in the previous spreadsheet.
Hope to hear from you soon.
Regards
Pulkit