Import from Google Sheets

Import contacts directly from Google Sheets into your CRM.

Import contacts without downloading or converting files. The extension reads your spreadsheet directly and creates contacts in your CRM.

Prerequisites

• Google Sheet with contact data (name, phone required)
• Header row in the first row of your sheet
• Chrome browser with Consuelo extension installed
• Signed in to Consuelo

Prepare Your Sheet

Required Columns

Your sheet must have at minimum:

Column	Content	Required
Name	Contact’s full name	Yes
Phone	Phone number (any format)	Yes

Optional Columns

Column	Content
Email	Email address
Company	Company name
Notes	Free-form notes
Tags	Comma-separated tags (e.g., prospect, Q1)

Example Sheet

Name	Phone	Email	Company	Tags
John Doe	[phone]	[e-mail]	Acme Corp	prospect
Jane Smith	[phone]	[e-mail]	Globex Inc	customer, vip

Phone numbers can be in any format. The system normalizes them automatically.

Step 1: Open the Sheet in Chrome

1. Navigate to your Google Sheet in Chrome
2. Ensure you’re logged into Google with view access
3. Keep the sheet tab active

Step 2: Open the Extension

Side Panel (Recommended)

1. Click the Consuelo icon in your toolbar 2. Click Open Side Panel 3. Go to the Contacts tab

Popup

1. Click the Consuelo icon in your toolbar 2. Go to the Contacts tab

Step 3: Start Import

1. Click Import from Sheets (or the import icon)
2. If this is your first time, Chrome prompts for Google Sheets permission
3. Click Allow to grant access

Permission is requested only once. Future imports won’t prompt.

Step 4: Map Columns

The import flow shows your sheet’s columns and asks you to map them:

Auto-Detection

The system tries to match columns automatically:

• “Name”, “Full Name”, “Contact” → Name field
• “Phone”, “Phone Number”, “Mobile” → Phone field
• “Email”, “Email Address” → Email field

Manual Mapping

If auto-detection is wrong:

1. Click on a column in the left panel
2. Select the correct Consuelo field from the dropdown
3. Repeat for each column you want to import

Skip Columns

Columns you don’t map are ignored during import. This is useful if your sheet has extra data you don’t need in your CRM.

Step 5: Preview

Before importing, review the preview:

Check	What to Look For
Data preview	First 5 rows show mapped data
Phone format	Numbers look correct after normalization
Missing data	Required fields (name, phone) have values
Errors	Rows with problems are highlighted

Preview Status

Status	Meaning
✓ Valid	Row will import successfully
⚠ Warning	Row will import but may have minor issues
✗ Error	Row will be skipped (missing required field)

Step 6: Import

1. Review the preview
2. Click Import
3. Watch the progress bar

Import Progress

Importing 150 contacts...
[████████████████████████████████] 100%

Imported: 147 contacts
Skipped: 3 contacts (duplicates)

Step 7: Review Results

After import completes, you see:

Result	Description
Imported	Successfully created contacts
Duplicates skipped	Phone number already existed in CRM
Errors	Rows that couldn’t be imported

Handle Duplicates

Duplicate phone numbers are skipped automatically. The existing contact is not modified.

To update existing contacts, use the web app’s import feature with “update existing” enabled.

Verify Import

Check your new contacts:

1. In the extension, go to Contacts tab
2. Search for one of your imported contacts
3. Verify the data looks correct

Or in the web app:

1. Go to consuelohq.com
2. Navigate to Contacts
3. Filter by a tag you imported (if used)

Common Issues

”No data detected”

Cause: Sheet doesn’t have a header row or data starts in wrong row.

Fix:

• Ensure row 1 contains column headers
• Ensure data starts in row 2
• Remove any empty rows at the top

”Permission denied”

Cause: Extension doesn’t have Google Sheets access.

Fix:

1. Click the lock icon in Chrome’s address bar
2. Find “Google Sheets” or “docs.google.com”
3. Change permission to “Allow”
4. Refresh the page and retry

”All rows showing errors”

Cause: Required columns not mapped.

Fix:

• Verify Name column is mapped to Name field
• Verify Phone column is mapped to Phone field
• Check that mapped columns have data (not empty)

“Phone numbers look wrong”

Cause: Phone format in sheet is unusual.

Fix:

• Phone numbers are auto-normalized
• The preview shows what will be saved
• If preview looks wrong, check your source data

Large Imports

For sheets with 1000+ rows:

• Import may take several minutes
• Progress bar shows completion percentage
• Don’t close the extension during import
• Maximum is 10,000 rows per import

For very large imports (5000+ rows), consider splitting into multiple sheets.

Best Practices

Before Import

• Clean your data in the sheet first
• Remove duplicate phone numbers
• Ensure all rows have name and phone

After Import

• Add tags to segment imported contacts
• Create a queue for follow-up calls
• Review any skipped rows

Sheet Template

Create a template sheet for your team:

1. Set up columns: Name, Phone, Email, Company, Tags
2. Share with team members
3. They can duplicate and use for imports

Next Steps

• Contact Management — Manage imported contacts
• Run a Queue Campaign — Call your new contacts
• Troubleshoot Extension — Fix import issues