Trying to automate Google Forms with Google Sheets

[ankitpopli10]

Hello Everyone I am trying to automate Google Forms with google sheet in the following way:

1. Whenever someone enters their name into the Form response, the code creates a Google sheet by their name and append all the other information of that form to that sheet.
2. However, if the excel sheet by their name already exists it should only add another row to the Google sheet already there.

The second part seems to be very tricky and I cannot find a way to accomplish this any help is appreciated

The code that I got from Chat GPT is as follows (I use this code in the form's Script Editor) :

I have enabled all required apis and everything else, not sure why its not working, I do not see any error. I do not have a coding background so if someone has a better idea how I can make this work, please let me know. Thank you!