Follow the following steps to store your form data to google sheets
- Create a new blank google Sheet and organize it
- Add Google Apps Script to your account
- Add and Run the google script code
- Add a new project
- Publish your project as a web app
- Create a html file and add your web app URL to the script src