Skip to content

HubSpot Data Mapping

Data Mapping and Transformation is one of the most powerful features of Connect iPaaS. When you create a workflow certain attributes of your trigger application are available to the action application for data mapping while making API calls. These attributes can be mapped to the specific attributes of the action application.

This powerful capability not only allows field mapping but it also allows complex transformation using Excel-style functions to apply hundreds of formulas and operations. The choice of Excel-style function makes data mapping on Connect iPaaS a breeze for business users who are already well versed with Microsoft Excel formulas.

Example Scenario with HubSpot Trigger

In the example workflow shown below, HubSpot is the trigger application. You can access the attributes of HubSpot event in any of the application actions while designing your workflow. In HubSpot, attributes will depend on the action you will choose.

Data Mapping on HubSpot

Figure 1. Data Mapping on HubSpot

As shown in the Figure above, we mapped parameters from HubSpot "Company Created" trigger to the Microsoft Outlook Action "Send Message". We can create the Subject and Message of mail based on data attributes of the HubSpot Trigger. In this example, the subject of the mail is constructed as a text string using Name. Also Message is constructed using CONCATENATE excel function to concatenate Street Address, City, State/Region, Country/Region and Postal Code.