Skip to main content

Overview

Import leads into your workspace using multiple methods: CSV upload, Google Sheets, HubSpot, or Salesforce integration.

Quick Start

New to importing leads? Start with CSV Upload for the easiest experience.

CSV Upload

The recommended method for beginners. Upload a CSV file with your lead data.

Step 1: Prepare Your CSV File

Your CSV must include these required fields:
firstName
string
required
Lead’s first name
lastName
string
required
Lead’s last name
email
string
required
Primary email address
phone
string
required
Primary phone number (include country code, e.g., +1234567890)
Optional fields:
altPhone1, altPhone2, altPhone3
string
Alternate phone numbers
altEmail1, altEmail2, altEmail3
string
Alternate email addresses
companyName
string
Company or organization name
jobTitle
string
Position or role
linkedinUrl
string
LinkedIn profile URL
notes
string
Additional notes or context
Any additional columns will be stored as custom fields.

Step 2: Download Template (Optional)

Click the Download Template button to get a pre-formatted CSV with all fields.

Step 3: Upload Your File

  1. Navigate to Leads β†’ Import
  2. Select CSV File method
  3. Drag & drop your file or click Choose File
  4. File size limit: 10MB max

Step 4: Select or Create a List

Choose whether to:
  • Add to an existing list (select from dropdown)
  • Create a new list (enter list name)

Step 5: Map Fields

The system will auto-map common field names. Review and adjust:
  • Each CSV column maps to one lead field
  • Required fields must be mapped
  • See live preview of sample data

Step 6: Preview & Import

  • Review first 10 records
  • See validation summary (valid leads, invalid records)
  • Click Import to save
Import Results:
  • βœ… Number of leads saved
  • ⚠️ Invalid records skipped
  • πŸ“‹ List assignment confirmation

Google Sheets Integration

Import leads directly from Google Sheets.

Prerequisites

1

Google API Access Token

Generate an access token from Google Cloud Console
2

Spreadsheet ID

Found in your Google Sheet URL
3

Sheet Name

Default: β€œSheet1” (optional parameter)

Import Steps

  1. Navigate to Leads β†’ Import
  2. Select Google Sheets
  3. Enter credentials:
    • Access Token
    • Spreadsheet ID
    • Sheet Name (optional)
  4. Click Connect & Import
Your Google Sheet must follow the same field structure as CSV (see above).

HubSpot Integration

Premium Feature - Requires HubSpot account and premium plan

Features

  • βœ“ Bidirectional sync
  • βœ“ Contact properties
  • βœ“ Deal tracking
  • βœ“ Activity logs

Setup Steps

  1. Navigate to Leads β†’ Import
  2. Select HubSpot
  3. Click Authorize & Import
  4. Log in to HubSpot and grant permissions
  5. System automatically imports contacts

Salesforce Integration

Premium Feature - Requires Salesforce account and premium plan

Features

  • βœ“ Lead & Contact sync
  • βœ“ Custom fields support
  • βœ“ Campaign tracking
  • βœ“ Opportunity data

Setup Steps

  1. Navigate to Leads β†’ Import
  2. Select Salesforce
  3. Click Authorize & Import
  4. Log in to Salesforce and grant permissions
  5. System automatically imports leads

Data Validation Rules

Phone Numbers

Phone numbers are automatically formatted according to these rules:
Input FormatOutput FormatDescription
10 digits+1XXXXXXXXXXAssumes US number
11 digits (starts with 1)+1XXXXXXXXXXUS number with country code
Other formatsMust be E.164International: +[country][number]

Email Addresses

  • Must contain @ and .
  • Automatically converted to lowercase
  • Whitespace trimmed

Duplicate Detection

Duplicates are detected by email address:
  • Duplicate rows in same CSV are skipped
  • Existing database duplicates are handled gracefully

API Reference

Upload leads programmatically using our REST API.

API Endpoint

View complete API documentation for lead uploads

Quick Example

POST /api/leads
Request:
{
  "leads": [
    {
      "firstName": "John",
      "lastName": "Doe",
      "email": "[email protected]",
      "phone": "+12025551234",
      "companyName": "Acme Corp",
      "jobTitle": "CEO",
      "customFields": {
        "industry": "Technology",
        "revenue": "1M-5M"
      }
    }
  ],
  "listId": "507f1f77bcf86cd799439011",
  "source": "csv_import"
}
Response:
{
  "message": "Leads saved successfully",
  "savedCount": 1,
  "listId": "507f1f77bcf86cd799439011"
}

Error Codes

CodeDescription
400Invalid data or missing required fields
401Unauthorized (missing/invalid auth token)
404List not found
500Server error

Best Practices

Download and use our CSV template to ensure proper formatting
Review your data for completeness and accuracy before importing
Create specific lists for different campaigns or lead sources
Set up automated syncs with HubSpot/Salesforce for up-to-date data