Google Drive API Required after 5.11.0 #1277

[lathonez]

After 5.11.0 (and I assume #1277), I needed to enable the Google Drive API on my project in order to open a google sheet (using any mechanism).

The error was very helpful:

gspread.exceptions.APIError: {'code': 403, 'message': 'Google Drive API has not been used in project 7575758011 before or it is disabled. Enable it by visiting https://console.developers.google.com/apis/api/drive.googleapis.com/overview?project=7575758011 then retry. If you enabled this API recently, wait a few minutes for the action to propagate to our systems and retry.', 'errors': [{'message': 'Google Drive API has not been used in project 7575758011 before or it is disabled. Enable it by visiting https://console.developers.google.com/apis/api/drive.googleapis.com/overview?project=7575758011 then retry. If you enabled this API recently, wait a few minutes for the action to propagate to our systems and retry.', 'domain': 'usageLimits', 'reason': 'accessNotConfigured', 'extendedHelp': 'https://console.developers.google.com'}], 'status': 'PERMISSION_DENIED', 'details': [{'@type': 'type.googleapis.com/google.rpc.Help', 'links': [{'description': 'Google developers console API activation', 'url': 'https://console.developers.google.com/apis/api/drive.googleapis.com/overview?project=7575758011'}]}, {'@type': 'type.googleapis.com/google.rpc.ErrorInfo', 'reason': 'SERVICE_DISABLED', 'domain': 'googleapis.com', 'metadata': {'consumer': 'projects/7575758011', 'service': 'drive.googleapis.com'}}]}

But it threw me. I was making a fully unrelated code change and I couldn't figure out why I'd suddenly need to enable Google Drive API. Took me a while to track it back to this PR.

From the context, it looks like #1277 is fixing a bug, and I probably should have had Google Drive API enabled the whole time.

I'm just raising this for others / in case you think it would be helpful to document the change.

[alifeee]

Hi. Thanks for this issue :) - it is something I clearly did not anticipate when implementing #1277.

Technically, our documentation says you should enable both Drive API and Sheets API. However, I can see how many people (probably myself included) would skim over it and miss out the step of enabling Drive API.

#1277 means that opening a spreadsheet now requires the Drive API as it uses it to get the metadata for "last edited time" and "created time" for the spreadsheet. Please follow the paper trail in #1277 for why we changed it to be that way. If you would have attempted to access either of these properties, you would've also come across this error (no Drive API access).

I'm just raising this for others / in case you think it would be helpful to document the change.

Thank you very much! I can see others also having this issue. We will leave this issue open for a while so it can more easily be found.

I have also added this information to the release notes

[lathonez]

Thanks for taking the time to reply and update the docs, and for the work maintaining this repo.

[alifeee]

Hi. With the new patch, you should not need Drive API access.

https://github.com/burnash/gspread/releases/tag/v5.11.1