If you use Google Sheets instead, you can program (using blocks and google apps script) for each user to have their own private "sheet" in a spreadsheet, or to have their own private spreadsheet, but these would be run under your google account.
It gets (much) more complicated if you want them to use their own google drive...
It will all depend on how private you want things to be.
Each user will have a weekly score, time and opponent.
My plan is, to instead having all bunch of blocks to save information. Just add all to a user excel sheet all at once and then use blocks to pull off the information for where I need it.
I dont need it to save on their drive, but I would like to have each user to have their own private "sheet".
example:
User 1: score 2-1 Time: 14:00 Opp: Mike
score 5-1 Time: 10:00 Opp: John
score 5-1 Time: 20:00 Opp: alex
User 2: score 2-5 Time: 110:00 Opp: Ross
score 5-5 Time: 10:00 Opp: John
score 5-1 Time: 20:00 Opp: Jack