In this article we look at the following issues:

  • Required scopes

  • Expired authentication

  • Missing permission to read the spreadsheet

  • A file is not a valid Google Sheets Spreadsheet

  • Admin policy enforced

Required scopes

When authenticating with your Google user, we request access to three scopes:

Google Docs: View your Google Spreadsheets

This permission lets us query spreadsheets that you have access to. We won't automatically get access to all of your documents, and will only be able to query a spreadsheet once you have connected it to Funnel.

Google Drive: See information about your Google Drive files

In order to not deplete your Google Sheets API quota, we optimize the imports so that we don't query Google Sheets if the spreadsheet hasn't been updated since the last import. In order to know when the document was updated, we need this permission in Google Drive. Note that this permission does not give us access to read all of your files, only to know the metadata of a file that you have connected to Funnel.

Basic account info (such as your email address)

We request access to basic account information to be able to show you which Google user you have connected to Funnel.

Expired authentication

When you set up an import, you let Funnel access your spreadsheets on your behalf. If this access has been manually revoked or it simply has expired, you'll see this message:

Funnel no longer has permission to access Google Sheets on behalf of your Google Account.

Solution

Reconnect the Google Account to renew the access so Funnel can import the data on your behalf.

Go to the source in the data sources list, press actions and then "Reconnect...":

Missing permission to read the spreadsheet

If the Google account used to import the spreadsheet lacks permission to read the file, a message like this will appear:

The connected Google account does not have permission to read the spreadsheet

If you're not the owner of the file, your access may have been revoked.

Solution

Make sure you still have access to the file with the same Google Account used in Funnel.

The file is not a valid Google Sheets Spreadsheet

If the file in Google Drive is not an actual Google Sheets document, you will get an error message like this:

The file is not a valid Google Sheets Spreadsheet

Funnels sheets import only supports actual Google Sheets spreadsheets, not other types of file formats such as .xlsx or .csv. When viewing an .xlsx-file in Google Drive, it looks very much like an actual sheet. You can tell the difference by the small label next to the filename:

Solution

Convert the file to the native Google Sheets format and import the new file. 

To convert the file, open it in sheets and select File -> Save as Google Sheets 

Admin policy enforced

If you run in to the error admin_policy_enforced you will see something like this when trying to add a new Google user:

  • An organization in Google can restrict which third-party apps their users may use

  • The Google administrators can whitelist specific apps so they can be used within the organization

Solution

Contact your organization's Google administrators or IT support in order to whitelist Funnel's sheet import.


Did this answer your question?