IssueTracker

Hi Google AppScript Support person,

This morning I had a perfectly working script that searches through google sheets by iterating over all files in the Google Drive of the executing user.

However, after switching the associated Google Cloud Project, I started seeing the mysterious error "Something Went Wrong - Please reload the page to try again".

I was able to narrow it down to a script that just runs

var files = DriveApp.getFiles();
var hasFiles = files.hasNext()  // <- this causes the error

This script, when created on a new AppScript project (with the "default" GCP project), runs fine. However, when I associate the script with any GCP project that does not have the Google Drive API enabled, I get the above error.

What steps will reproduce the problem?

1. Create a new project with the above code snippet.
2. Associate the project with a GCP project that has 'Google Drive API' disabled.
3. Run the script.

This took quite a while to debug mostly due to the lack of information in the error or logs, along with the unclear documentation.

The former complaint, about the clarity of the error is, I think, a source of frustration in the community, as I've seen quite a few posts from people getting stumped by this error (I answered one of the questions with my solution here: https://stackoverflow.com/a/69596292/484127).

The latter, on the documentation, is quite possibly a bug in the docs, as under Advanced services - requirements section it's stated:

You must make sure the API corresponding to the advanced service is enabled in the Cloud Platform (GCP) project your script uses.

If your script project uses a default GCP project created on or after April 8, 2019, the API is enabled automatically after you enable the advanced service and save the script project. If you have not done so already, you may also be asked to agree to the Google Cloud Platform and Google APIs Terms of Service as well.

If your script project uses a standard GCP project or an older default GCP project, you must enable the advanced service's corresponding API in the GCP project manually. You must have edit access to the GCP project to make this change.

However, what is unclear is why some of the DriveApp functions are also considered to be "Advanced service" even though the reference does not mention this.

I'm certain we can work togethe to help some of the other people who experience this issue. Please ping me if you have any asks.

Thanks, Pavel