test: change service account to oauth client
I got hit with
The user's Drive storage quota has been exceeded
when trying to test with a service account created from my gmail.com account. Apparently service accounts have 0 Drive storage space available, and I couldn't do any test with client.create(name), since that requires creating a sheet in the service account's Drive.
I tried some workarounds to no avail:
- Share a folder with the service account with
Editorpermission and doclient.create(name, folder_id=...), still fails. - Enable domain-wide-delegation so that the service account can impersonate my
gmail.comaccount, fails because I cannot login toadmin.google.comwith agmail.comaccount.
Unless I'm seriously misunderstanding something, the only way for a regular gmail.com user to add new tests now is by authenticating with OAuth instead so that test sheets can be created.
sorry, I do not have much time to review PRs right now. I hope that is okay :] — I am discussing gspread maintenance with @lavigne958.