Overview

When integrating HubSpot Contacts with Google Contacts, direct mapping of the Emails, PhoneNumbers, and Addresses fields can lead to an error, because these fields are structured differently in each system.

Why This Happens

• In Google Contacts, the Emails field (and similarly PhoneNumbers, Addresses) is an array that can hold multiple entries.
• In HubSpot, the Email field contains only a single value.
• Because of this structural difference, a direct one-to-one mapping between the two fields is not compatible and will cause a mapping error.

A single entry in the Google Contacts Emails field looks like this:

[{"Address":"example@mail.com","Type":"other","IsPrimary":true}]

Resolution

To resolve the mapping error, use an expression on the HubSpot to Google Contacts mapping to wrap the single HubSpot value into the array format that Google Contacts expects.

1. For the Emails field, use an expression similar to:

   "[{\"Address\":\"" + Email + "\",\"Type\":\"other\",\"IsPrimary\":true}]"

2. For the PhoneNumbers field, use an expression similar to:

   "[{\"PhoneNumber\":\"" + (DT_WSTR, 30)[MobileNumber] + "\",\"Type\":\"Mobile\"}]"

3. For the Addresses field, use an expression similar to:

   "[{\"Country\":\"" + [Country] + "\",\"City\":\"" + [City] + "\",\"Street\":\"" + [Street] + "\",\"Type\":\"other\"}]"

Important Notes

• These expressions build a single-entry JSON array. If you need to map multiple emails, phone numbers, or addresses per contact, the expression logic needs to be adapted accordingly.
• Field and column names (such as Email, MobileNumber, Country, City, Street) must match the actual source field names used in your integration task.

Still Having Issues?

If the expression mapping above does not resolve the issue, submit a request through our support ticket form with details of your integration.