Push Enriched Contacts to HubSpot Automatically

This tutorial shows how to enrich a list of contacts in TexAu and push them directly to HubSpot as new contacts. You will build a table that handles both the enrichment and the CRM sync in one run.

Before you begin

• Connect these integrations in Settings > Integrations:
  • BetterEnrich (for email and phone finding)
  • HubSpot (for contact creation) - requires HubSpot OAuth connection
• Make sure your HubSpot account has the contacts permission for the API scope you connected.

What you will build

A single table with enrichment and HubSpot push in the same run:

Step 1: Set up the table

1. Click New Table and name it Enrich and Push to HubSpot.
2. Import your LinkedIn URL list as a CSV or paste them in.
3. Name the first column LinkedIn URL.

Step 2: Enrich profile data

1. Click Add Column and select Action Column.
2. Select Enrich Contact (B2B Enrichment).
3. Map LinkedIn URL to the LinkedIn Profile URL input.
4. Select these outputs: First Name, Last Name, Current Job Title, Current Company Name.
5. Click Save.

Step 3: Find work email

1. Click Add Column and select Action Column.
2. Select Find Work Email by LinkedIn URL (BetterEnrich).
3. Map LinkedIn URL as input.
4. Select Email as output.
5. Click Save.

This action costs 2 credits per row.

Step 4: Find mobile number

1. Click Add Column and select Action Column.
2. Select Find Mobile Number by LinkedIn URL (BetterEnrich).
3. Map LinkedIn URL as input.
4. Select Phone Number as output.
5. Click Save.

This action costs 10 credits per row.

Step 5: Configure the HubSpot push

1. Click Add Column and select Action Column.
2. Search for and select Create Contact (HubSpot).
3. Map each field:
   • Email - map to Work Email column (required)
   • First Name - map to First Name
   • Last Name - map to Last Name
   • Job Title - map to Job Title
   • Company - map to Company Name
   • Phone - map to Mobile Number
4. Click Save.

Step 6: Add a pre-send filter

To avoid pushing contacts with no email to HubSpot (which would create incomplete records), add a condition to the HubSpot column.

1. Open the Create Contact (HubSpot) column settings.
2. Click Add Condition.
3. Set: only run this column when Work Email is not empty.
4. Click Save.

Step 7: Run the table

1. Click Run All Rows.
2. After completion, check the HubSpot Contact ID output column. Rows with a Contact ID were successfully pushed to HubSpot.
3. Open HubSpot and verify the new contacts appear in your Contacts list.

Step 8: Handle duplicates

If a contact with the same email already exists in HubSpot, Create Contact (HubSpot) will fail with a duplicate error. To update existing contacts instead:

1. Remove the Create Contact (HubSpot) column.
2. Add an Update Contact (HubSpot) column instead.
3. First look up the existing HubSpot Contact ID using Search Contacts (HubSpot) with the email as a filter.
4. Map the returned Contact ID and the enriched fields to Update Contact (HubSpot).

Troubleshooting

HubSpot push column shows errors for some rows. The most common cause is a missing required field (Email is required for HubSpot contact creation). Check that the Work Email column has a value for the failing rows. Use the pre-send filter from Step 6 to skip empty email rows completely.

Contacts are created in HubSpot but some fields are empty. The field may be empty because the enrichment step returned no data for that row. Check the enrichment columns to see which rows have missing data. This is expected for contacts with limited LinkedIn profile data.

The HubSpot integration disconnects after a few hundred rows. HubSpot uses OAuth. If the OAuth token expires mid-run, reconnect the HubSpot integration in Settings > Integrations and re-run the failed rows. Consider batching very large lists (1,000+ contacts) into multiple runs of 500 rows each.