A simple Google Apps Script for converting Google Spreadsheet to Google Form quiz.
To run this script, please follow these steps:
- Create a new Google Spreadsheet.
- Copy the content of create_form.xlsx then paste it to your new Google Spreadsheet.
- Click Tools -> Script Editor.
- Copy the content of Code.gs to the script editor then save it.
- Reload the Spreadsheet.
- Now there will be a new menu Kuis after the Help menu. Click it then click Buat Google Form.
- Wait until the dialog box appeared.
- Check your Google Drive, there will be a new Google Form for that quiz. You can edit it again or just publish it.
NOTE: The language in the user interface produced by this script is in Bahasa Indonesia.