Trouble connecting a Google Sheets import?

Here are some issues that may occur when trying to connect a Google Sheets import

Ilona Norman avatar
Written by Ilona Norman
Updated over a week ago

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.


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.


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:


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 

Unable to edit Google Sheets Import configuration

If you didn't create the Google Sheets Import connection/Data Source in Funnel and you try to edit the configuration, you may receive the following error:

Cannot access configuration
Only the user who connected the Google Sheet can view and edit the configuration

At the moment, only the Funnel user who connected the Google Sheet to Funnel can access and edit the configuration for security reasons.


All you need to do is reconnect with a Google user/account with access to the same sheet. Please note that the original user that connected the Google Sheet will lose their ability to access/edit the Data Source in Funnel.

Admin policy enforced

If you run into 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

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


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

Did this answer your question?