Importing data from a Google Sheet is different than importing data from another platform. When we fetch data from our out-of-the-box integrations, Funnel has already determined the unit (data type), name and other necessary information for each field on your behalf.
In this case of importing data from Google Sheets, you control both the data and its formatting, and how Funnel should interpret and import the data. We do our best to help you set up a working configuration by applying smart suggestions, but we can't control how the data looks. Because of this, you may run into import errors when Funnel is unable to successfully parse the data for your current configuration.
We know how important it is for you to get accurate data. This is why we raise these errors so you are able to address them, rather than hide them and risk you getting inaccurate data.
Header no longer found in sheet
Funnel uses the data headers to identify which column is which. If a header has been removed or renamed from the data, you'll see an error such as this:
The column header 'Impressions' could not be found in the sheet. Has it been renamed or removed?
Either make sure a column with that exact header exists in the sheet, or edit the import configuration and remove that field entirely.
Failed to parse cells
When you get an error starting with
Failed to parse cells it means that we were unable to successfully take the value from a cell in your spreadsheet and convert it to the unit you want in Funnel.
You will get a summary of all columns that could not be imported with examples of cells that failed.
Type conversion error
When Funnel cannot convert a data type in the spreadsheet to the unit you specified in the field configuration, you will get an error such as this:
Type conversion error. Could not convert cell value to a number.
In this specific case, the field is set to be "Number" but the cell value could not be parsed as a number (i.e. it might be a plain text such as "-" or "N/A").
To resolve this, make sure all cells in number columns are indeed numbers.
If a cell contains a formula error, you will get a
Cell error with an explanation of the type of error. These errors happen in Google Sheets when a formula for some reason cannot calculate its value, such as dividing a number by 0 (resulting in a
To resolve this, either fix the errors in the sheet, or write a formula that gracefully handles errors using the
=IFERROR function (https://support.google.com/docs/answer/3093304?hl=en).
Failed to parse Google Sheets datetime as a date
This happens when Funnel tries to parse a cell value as a date. You can read more about how dates should be formatted here: https://help.funnel.io/en/articles/3870942#dates
Data Source errors
You may experience errors related to the Google Account such as:
- Expired authentication
- Missing permission to read the spreadsheet
- A file is not a valid Google Sheets Spreadsheet
- Admin policy enforced
Go to this article for more information on how to resolve those: https://help.funnel.io/en/articles/3849023-trouble-connecting-a-google-sheets-import