Skip to content

Smartsheet 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 easy for business users who are already well versed with Microsoft Excel formulas.

Example Scenario

You can manually write data in action input fields or can map your trigger data. In the example workflow shown below, Smartsheet record is created in a sheet corresponding to the trigger data from Salesforce.

Smartsheet Data mapping and transformation

Figure 1. Example showing data mapping and transformation

As shown in the figure above, you can map parameters from the Salesforce "Object Created" trigger to Smartsheet "Add Row" action. You can create rows in Smartsheet corresponding to Contact in Salesforce.

Conversely, you can map data from Smartsheet trigger to any other action.

Smartsheet Data mapping and transformation

Figure 2. Data Mapping on Smartsheet Application

As shown in the image above, there is a mapping of parameters from Smartsheet "Row is created" trigger to Coupa "Create Object" action.