Common Issues & Solutions

Issue #1: Nothing seems to work no matter what I do.

Solution: By any chance, have you logged in with multiple Google accounts at a time? Even though the issue has been handled, sometimes the add-on misbehaves when you have logged in with multiple Google accounts. You can logout from other Google accounts or open an incognito window, login to the Google account and work with Drive Explorer.


Issue #2: I see the following error popup when I use the add-on,

Response Code: 400. Message: <HTML>
<HEAD>
<TITLE>Bad Request</TITLE>
</HEAD>
<BODY BGCOLOR="#FFFFFF" TEXT="#000000">
<H1>Bad Request</H1>
<H2>Error 400</H2>
</BODY>
</HTML>

Solution: It is a temporary issue. Can occur sometimes. It's safe to ignore this error.


Issue #3: I see the following error alert,

API call to drive.files.list failed with error: Invalid query

Solution: Drive Explorer dynamically builds the query to fetch the file list from Drive API. This error can occur whenever you have some type of special character in the files you try to list. You will see a button to report the issue via email. Please report the issue. Your email will have the needed details for the developer to fix the issue.


Issue #4: Thumbnails in the Google Sheet disappears after sometime.

Solution: Drive Explorer populates the thumbnail from the URL it gets from Drive API. It is a short-lived temporary URL. It only lasts on the order of hours. However, as a workaround, you can enable auto refresh on open or scheduled refresh to have fresh thumbnails in the sheet always.


Issue #5: Drive Explorer's auto refresh feature (Autorefresh on open or Scheduled refresh) writes the data in a sheet I don't want it to.

Solution: If you had used Drive Explorer in that sheet in the past, this can happen. To prevent this, please select Add-ons → Drive Explorer → Clear Sheet. It will disconnect that sheet from Drive Explorer and automatic write won't happen in that particular sheet. You can learn more about this in clear sheet section. To reverse this, just use Drive Explorer again in that sheet.


Issue #6: Drive Explorer fails to list all of the files it is supposed to in the Google Sheet. I get the Exceeded maximum execution time error.

Solution: Google limits the add-on execution time to 6 minutes when you run Drive Explorer from a Google Sheet. You can extend it up to 12 minutes if you are a Gmail user or 1 hour if you are a Workspace Business/Enterprise/Education user, as explained in the batch execution section.

When you have hundreds of thousands of files, Drive Explorer may not be able to list all of your files within that time limit. There are 2 possible solutions for this issue.

  1. You can run Drive Explorer directly in your browser and let it list all the files it is supposed to without any time limit.
  2. You can reduce the number of files you try to export at a time to the sheet.