Any help to update to the new api would be welcome. Perhaps change to use the gsheets python package
Speed up Blooket creation by having a program automate most of the work.
Steps to use:
- Create a Blooket account https://www.blooket.com/
- Create a Blooket (Add title and description, set creation method to manual, scroll down, and click create)
- Once editing the Blooket, select the green button labeled "Spreadsheet import"
- A box should pop up, select copy. You will be redirected and prompted to make a copy.
- After making a copy, share it with your Google service account.
5a. To create a google service account:
- Go to the Google APIs Console (https://console.developers.google.com/).
- Create a new project.
- Click Enable API. Search for and enable the Google Drive API.
- Search for and enable the Google Sheets API.
- Create credentials for a Web Server to access Application Data.
- Name the service account and grant it a Project Role of Editor.
- Download the JSON file.
- Rename it to
service_account.json
(Do not share this file with anyone)
- Install gspread (pip install gspread)
- Download blooketsheet.py and questions.txt.
- On line 5 change
filename
to the path of the service_account. - On line 6,
sa.open("filename")
, changefilename
to the name of the Google Sheet you copied earlier (The Google Sheet must be shared with the service worker. The service worker also needs to have permission to edit.). - Edit
questions.txt
(Use the same format as the example) - Run the program.
- Open the Google Sheet.
- Go to file and download as CSV.
- Go back to Blooket.
- Click upload as CSV (If you do not see the button, make sure you are editing the Blooket, then click "Spreadsheet Import").
Todo
- Blooket Creator Framework
- Custom tkinkter interface/web app
- True False support (adding True when the answer is False instead of randomly picking)