Hello Everyone I am trying to automate Google Forms with google sheet in the following way:
- 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.
- 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!