Skip to main content
All CollectionsCreating cold email campaigns
How to upload leads with Google Sheets
How to upload leads with Google Sheets
Updated this week

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:

  1. Make the Google Sheet publicly accessible: Anyone with the link

  2. Paste in the URL

  3. Import your spreadsheet


​To avoid formatting issues, make sure to follow the steps below:

  1. Select all your rows and columns with Ctrl/Cmd + A, and then

  2. Click Format β†’ Number β†’ Plain text.

  3. Import your spreadsheet.

Checklist if you're unable to import the leads:

  1. Make sure you have no more than 20 custom variables selected

  2. The email column must not be empty.

  3. 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.

  4. There must be no grouped rows as they can cause an issue (see below for better understanding):

    Instead, split them:

    User-uploaded Image
  5. 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.

Did this answer your question?