A premium form code generator that connects directly to Google Sheets and Google Drive for storing form information.
You can use this tool to generate HTML code and simply embed it to store your survey data in Google Sheets.
Credits
This website is generated by Abdullah Al Asek.
Phase 1: Designing Your Form
Use the Toolbox buttons in the interface to build your form structure.
- Short Ans / Long Ans: Use these for names, emails, or messages.
- Text A/B / Text Multi: Use these for multiple-choice questions.
- File: Adds a file upload button. You must fill in the blank space with a Google Drive Folder ID. You can easily get this after uploading your pictures to Google Drive. Don’t forget to set the folder to public viewing.
- Img Multi / A–B: Specialized image selection questions (requires Google Drive image IDs).
- Page Break: Splits your form into multiple steps/pages.
- Terms Gate: Adds a mandatory checkbox (e.g., “I agree to the terms”) that does not save data to the sheet but prevents submission if unchecked.
Phase 2: Connecting to Google
- Go to Google Sheets and create a new spreadsheet.
- In the first row (Row 1), add your headers. These must match the data you plan to collect. You can get the header data (Sheet Keywords) from this website.
- Click Extensions - Apps Script.
- Clear everything from
Code.gs and paste the new code generated by this website (Google Apps Script).
- Click Deploy - New Deployment.
- Select Web app as the deployment type.
- Set Execute as to Me.
- Set Who has access to Anyone.
- Click Deploy, authorize permissions, and copy the Google Web App URL.
After getting the URL, paste it back into this website and copy the generated form code.
Phase 3: Generating Data
After getting the code, you can either host it on any website or simply save it as an HTML file and open it in a browser. You can then enter your data, and it will be saved directly to a Google Sheet.