This personal project uses google sheets api to get form responses, create balanced League of Legend teams from the players that filled the form, and then finally output the teams back onto google sheets.
This will be helpful for next year as I will be planning round robins weekly as the Community Director at UMich, which will save me a lot of time!
Things to do for each Round Robin:
- Make google form and connect with a spreadsheet
- Share spreadsheet with service account
- Change values in 'sheetID.py' corresponding to Sheet ID and the sheet for outputting teams
- After all players entered, run 'python read.py'
- GLHF :)