Import Contacts
Meetzy allows you to import contacts in bulk from Excel files (.xlsx, .xls, .xlsm) or directly from Google Sheets. This enables you to quickly populate your contact database for campaigns.Import Methods
| Method | Description | Requirements |
|---|---|---|
| 📊 Excel | Upload .xlsx, .xls, or .xlsm files | File up to 10MB |
| 📗 Google Sheets | Connect directly to your spreadsheets | Google account integration |
Import Wizard
The import process follows three steps:Excel Import
Uploading a File
- Navigate to CRM → Import Contacts
- Select Import from Excel
- Drag and drop your file or click to browse
- Supported formats:
.xlsx,.xls,.xlsm - Maximum file size: 10MB
File Validation
Once uploaded, the system analyzes your file:| Analysis | Description |
|---|---|
| Total Rows | Number of data rows detected |
| Valid Phones | Rows with valid phone numbers |
| Duplicates | Duplicate phone numbers found |
| No Phone | Rows missing phone numbers |
Google Sheets Import
Connecting Google Sheets
If not connected:- Click Connect Google Sheets
- Authorize with your Google account
- Grant access to your spreadsheets
Selecting a Spreadsheet
- Browse your available spreadsheets
- Use the search bar to find specific files
- Click on a spreadsheet to select it
- The system validates the sheet structure
Column Mapping
Required Fields
| Field | Description | Required |
|---|---|---|
| Phone | Contact phone number | ✅ Yes |
| Name | Contact name | No |
| Contact email | No |
Mapping Columns
- For each field, select the corresponding column from your file
- Preview data updates in real-time
- Highlighted columns indicate mapped fields
Custom Fields
Add additional columns as custom fields:- View available unmapped columns
- Click on a column name to include it
- Custom fields are stored with the contact
- Use them in agent prompts with input parameters
Columns already mapped to standard fields (Phone, Name, Email) cannot be added as custom fields.
Data Preview
Before importing, review your data:- First rows are displayed in a preview table
- Mapped columns are highlighted in green
- Verify data looks correct before proceeding
Sheet Selection
If your file contains multiple sheets:- A dropdown appears to select the sheet
- Choose the sheet containing your contacts
- Mapping updates based on the selected sheet’s columns
Segment Assignment
All imported contacts are automatically added to a segment:- Enter a Segment Name
- This creates a new segment with your imports
- Use segments for targeted campaigns
Admin Features
For admin users:Company Selection
- A company selector appears at the top
- Search for a company by name
- Select to import contacts to that company
- “My Account” imports to your own account
Import Process
Once configuration is complete:- Click Start Import
- A progress circle shows completion percentage
- Live stats display:
- New contacts created
- Existing contacts updated
- Rows skipped
Import Duration
Processing time depends on:- Number of rows
- Network speed
- Server load
Import Report
After completion, you’ll see:| Metric | Description |
|---|---|
| ✅ Imported | New contacts created |
| 🔄 Updated | Existing contacts updated |
| ⏭️ Skipped | Rows not imported |
| 📊 In Segment | Total contacts in segment |
Error Details
If errors occurred:- View the errors table
- Each row shows: Row number, Phone, Error message
- Common errors: Invalid phone format, missing required data
Quick Actions
- View Segment - Go to the created segment
- Import More - Start a new import
- View All Contacts - Browse your CRM
Best Practices
Clean Data First
Remove duplicates and format phone numbers before importing.
Use Headers
Ensure your first row contains column headers for accurate mapping.
Phone Format
Include country codes (e.g., +1 for US, +34 for Spain).
Test Small
Test with a small batch first to verify mapping works correctly.
Troubleshooting
| Issue | Solution |
|---|---|
| ”No phone numbers found” | Verify your phone column is selected correctly |
| ”Invalid phone format” | Add country codes to phone numbers |
| ”File too large” | Split into multiple files under 10MB |
| ”Google Sheets not connected” | Go to Integrations to reconnect |

