Import leads from Google Sheets

The Google Sheets importer reads rows from a Google Sheet and lets you map each column to a lead field before upload. The current importer reads a sheet by its link and requires link access. Use it only for contact data you are allowed to share this way; use a more restricted import method for confidential records.

How should I prepare the sheet?

1. Put column names in the first row and one lead on each following row. Include an Email column; the importer requires it.
2. Remove blank rows, merged cells, duplicate column names, and fields you do not need. Keep headers short: the current parser rejects a column name longer than 25 characters.
3. Format identifiers and phone numbers as plain text so Sheets does not change leading zeros or convert values to dates.
4. Remove contacts who opted out or should be suppressed. Record the list source and permission to use it.
5. The current link based parser needs a sheet it can read without your Google sign in. If you choose Anyone with the link in Google Sheets, anyone who gets that link may read the sheet. Do not use this method for sensitive or restricted contact data; choose an import path with suitable access controls instead.

How do I import and map the rows?

1. In a campaign’s Leads tab or a lead list, choose the Google Sheets import option and paste a standard Sheet URL containing /d/<sheet-id>/.
2. Start the import preview. If the app cannot read the sheet, check the URL, link access, and whether the first tab contains rows.
3. Map Email to the email field. Review suggested mappings for name, company, and other predefined fields. Map personalization columns as custom variables; exclude columns you do not need.
4. Review duplicate checks for campaigns, lists, or the workspace. Select lead verification only after checking the credits or charge displayed by the app.
5. Inspect sample values, then choose Upload all. Wait for the result before retrying; repeated uploads can create extra work even when duplicate checks are enabled.

How do I fix common errors?

• Invalid link: copy the complete Google Sheets URL from the browser, including its sheet ID.
• Unable to get data or zero rows: confirm link access and that the sheet contains rows below the header.
• Parsing error: shorten headers to 25 characters or less, remove duplicate or empty headers, and try again.
• Email column required: map the source email column to Email before upload.
• Unexpected lead count: inspect rejected or duplicate rows, then correct and import only the missing contacts.

After upload, spot check records and personalization fields. Recheck suppression and campaign readiness before sending. Remove unnecessary link access from the Sheet when the import is finished.