A Google Spreadsheet add-on that allow you to create and analyze google forms using friendly UI. Use case can be a surveys system for school or university, where you may need many different forms with the same questions, one for each teacher / lecturer.
This project is separated to two part, the first one design for very specific task, and the second is more general.
The first part is a small python script (just scrapSelenium.py file) witch made to scrap data from Yedion Website The idea is make a csv file with the details of all the courses in a given semester at Ort Braude Collage of Engineering. Once we have this file, we can create a surveys system, using the second part of this project.
The second and the main part of this project is the google sheet add-on. This add-on allows you to create, manage and analyze many Google form files via friendly UI. Using this add-on, we can take a sheet of data (the data from the first part for example), and create unique Google form of each row in the sheet. Once we do that, we have a database of google form files, witch can be used for a survey system.
If you want to contribute to this project, or you wish to understand better this project structure, please click here.
- Create hundreds of custom google forms just with one click.
- Manage your created forms:
- Allow / do not allow new responses
- Publish / do not publish results
- Show / do not show link to another respond
- Custom confirmation message
- Custom close-form message
- Remove duplicate responses!
- Remove unauthorized responses
- Calculate responses average
- Create a copy of Many-Forms-Spreadsheet on your google account.
- Open the spreadsheet and Follow the instructions, watch the following demo gifs or watch the YouTube tutorial.
