To import a lead list via google sheet make the google sheet publicly accessible and then paste in the URL.
To avoid formatting issues:
Select all your rows and columns with Ctrl/Cmd + A, and then
Click Format → Number → Plain text
Finally, import your spreadsheet
Important:
Make sure you have no more than 20 custom variables selected
The email column must not be empty
If there are some column names that are longer than 20 characters, try to shorten them. E.g. a column heading name is:- Instagram_Average_Comments which is 26 characters - You can change it to Instagram_Comments which is 18 characters etc.
There must be no grouped rows as they can cause an issue (see below for better understanding):
Instead split them:
If one of the values is Boolean it throws an error since Google is returning it as boolean (true/false) instead of a text. For example:
Please remove it and try to import again.