Using Google Sheets to upload leads entails efficiently organizing, inputting, and integrating lead data.
To import a lead list via Google Sheet, follow these steps:
Make the Google Sheet publicly accessible: Anyone with the link
Paste in the URL
Import your spreadsheet
Note:
To avoid formatting issues, make sure to follow the steps below:
Select all your rows and columns with Ctrl/Cmd + A, and then
Click Format → Number → Plain text.
Import your spreadsheet.
Checklist if you're unable to import the leads:
Make sure you have no more than 20 custom variables selected
The email column must not be empty.
If there are 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. See the example below. If so, please remove it and try to import it again.
