Open navigation

How to fix “File not found” errors with scheduled refreshes in Google Sheets

If you see this error when running scheduled refreshes in your Supermetrics reports in Google Sheets, there are some steps you can take to troubleshoot the issue.

  • Last Status: Error: Email failed File not found


Check file ownership

Only the owner of the file can set and run Supermetrics scheduled emails.

Make sure your account has Owner access to the file.

Check file location

If the Google Sheets file has been moved to another location or another Google Drive, it can break the connection between the file and Supermetrics' scheduled report refreshes.

To check if the file and its Supermetrics refreshes are still connected, open the Supermetrics sidebar, go to the Schedules tab, and scroll down to click View all schedules in all spreadsheets

If you can't see the scheduled refresh in the list, check the file's location, and set up a new scheduled refresh for it.

Check your Google Drive type

Business Drive

If your Supermetrics license is linked to a non-business Google Account, but the file is within your Business Drive, it may automatically make the business account the file owner. This would result in the schedule refresh not finding the file. 

To resolve this, move the file back to the non-business account's Drive location and create new scheduled refreshes for it, or change the license user to the business account.

Team Drive

Team Drive locations don't have the kinds of permissions Supermetrics scheduled reports require.

For this reason, the Google Sheets files that you use with Supermetrics should be housed in the private Google Drive assigned to your license holder's Google Account.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.