INTEGRATIONS · HUBSPOT

ZipLead and HubSpot: a CSV, not a sync.

Yes, ZipLead works with HubSpot, and it is worth being exact about how. ZipLead does not connect to your HubSpot account. No button pushes a record into HubSpot and nothing comes back. What you get is a CSV of the businesses you pulled, with columns HubSpot's import tool maps to company or contact properties. You upload it, match the columns, and the records land in HubSpot. The whole thing takes a few minutes the first time and about one the times after.

THE FILE

What is in the CSV.

These are the columns in a search export, in order. A list export carries a shorter set (name, category, address, ZIP, phone, website, rating, reviews, score, tier, ownership, pipeline status and estimated annual value).

SEARCH EXPORT29 COLUMNS
NameCategoryNAICSNAICS IndustryAddressPhoneExtra PhonesDecision MakerWebsiteEmail(s)RatingReviewsScoreTierPipeline StatusPipeline NoteSourceFacebookInstagramLinkedInTwitterPlatformSSLMobile FriendlyRunning AdsEmail VerifiedCategory RankBusinesses In CategoryRank Note

Two honest notes.The Email Verified column reads "not checked" today, because email verification is not switched on, so treat every address as unverified. And Running Ads is a yes or no on whether the site carries a Meta Pixel or Google Ads tag. It is not a spend figure.

SETUP

From ZipLead to HubSpot in six steps.

STEP 01

Pull the list

Run a search in ZipLead, or open a saved list under Lists. Enrich the ones you want contact emails for first, since enrichment is what fills the Email(s), Decision Maker and Platform columns.

STEP 02

Download the CSV

On the search results page, click CSV at the top right, next to Enrich. On a list, click Download CSV. The file is named ziplead-<area>-<id>.csv and already leaves out anything on your exclusion list.

STEP 03

Start a HubSpot import

In HubSpot go to Companies, click Import in the top right, then Start an import. Choose File from computer, One file, One object, and pick Companies. (Pick Contacts instead if you want each email to become a person.)

STEP 04

Upload the file

Drag the CSV in. HubSpot reads the header row and moves you to the column mapping screen.

STEP 05

Map the columns

Name to Company name. Phone to Phone number. Website to Website URL. Address to Street address. Category to Industry if you like. For Score, Tier and Pipeline Status, open the dropdown and choose Create a new property, or skip them. Skipped columns are ignored and nothing breaks.

STEP 06

Finish, then check one record

Run the import, open one company, and confirm the phone and website landed where you expect. If the Email(s) column held two addresses separated by a semicolon, HubSpot will have kept the whole string. Split those by hand or leave them as a note.

IF YOU WANT IT AUTOMATIC

ZipLead fires a webhook when a search finishes, when prospects are enriched, when an enriched prospect scores 85 or higher, and when you move prospects in the pipeline. A Zap or a Make scenario can catch that and create a HubSpot company. Setup is on the Zapier page and the Make page.

WHAT THE WEBHOOK CARRIES

The prospect's id, name, score and tier. Not the phone, website or address. So a Zap that creates a HubSpot company from the webhook gets a name and a score, and the rest comes from the CSV or from GET /api/v1/prospects with the job_id in the event. The Webhook URL field is on Command ($179/mo), the plan that includes API access. Operator and the free plan do not have it.

QUESTIONS

HubSpot questions, answered straight.

Is there a live sync between ZipLead and HubSpot?

No. ZipLead does not connect to your HubSpot account, there is no OAuth screen, and nothing flows back from HubSpot to ZipLead. The integration is a CSV file plus HubSpot's import tool. If you need records to appear in HubSpot on their own when something happens in ZipLead, that is a Zapier or Make job driven by ZipLead's webhook, and those pages cover it.

Should I import as companies or contacts?

Companies, usually. Each row in the file is a business, so the fit is one row to one company. Choose Contacts if you mainly want the email addresses as people. Be aware the Email(s) column can hold more than one address separated by semicolons, and HubSpot will not split it for you.

Will my own customers end up in the file?

Not if they are on your exclusion list. The export applies the list the same way the screen does, so a business you excluded never reaches the CSV.

Which plan do I need?

The pricing page lists CSV export under Operator ($59/mo) and Command ($179/mo). Score and Tier are in the file on both. If you want the automatic route through Zapier or Make instead of a file, The Webhook URL field is on Command ($179/mo), the plan that includes API access. Operator and the free plan do not have it.

Try the file on a market you know.

5 free searches a month, no card. Pull your own ZIP and see whether the top of the list is worth a HubSpot record.

Run a free search