User Mapping in CRM Integration

Updated 

User mapping is a critical process in integrating Sprinklr with CRM systems. It ensures that users can access the Sprinklr Care Console iFrame within CRM. This process ensures that each user in CRM is associated with a corresponding user in Sprinklr, facilitating data governance, compliance, and streamlined communication between the two systems.

This guide will walk you through the step-by-step process of user mapping, including importing, updating, deleting, and exporting user mappings.

Understanding User Mapping

User mapping is essentially a 1-to-1 association between a CRM user and a Sprinklr user, primarily to manage iFrame access. This ensures that all features within the iFrame, controlled by permissions, are consistent with the associated Sprinklr user.

Key Benefits

  • Data Governance: Ensures that user actions are tracked and audited across both systems.

  • Compliance: Maintains consistency in user roles and permissions.

  • Streamlined Operations: Simplifies user management by keeping a synchronized record of users.

Prerequisites

Before beginning the user mapping process, ensure you have the following prerequisites in place:

1.CRM Connector Configuration

The CRM Connector must be configured in the Sprinklr Marketplace.

Note: Access to CRM Connector configuration may be permission controlled. Ensure you have the necessary permissions to proceed.

2. Valid Sprinklr User Account

To map users, you will need a valid Sprinklr User account access. A Sprinklr user can be mapped using User ID or Email.

1. Access User Details

  • Click the New Tab icon in Sprinklr.

  • Under the Platform Modules, select "Users" within the "Collaborate" section.

2. Locate User ID

  • Hover over the user’s options icon and select "Details."

  • The Sprinklr User ID can be found within the URL string in your browser.

You can find the user Email id in the same panel.

3. CRM User ID

CRM User ID is required to map with a Sprinklr User ID. As an example, refer to this guide to learn about how to obtain Salesforce CRM User ID.

Note: User Mapping can be performed in two ways:

1. Sprinklr Marketplace UI: We will be covering UI based User Mapping in this document.

2. API Based: To learn more about how to do User Mapping through APIs, refer to this document.

Create User Mapping

Creating a user mapping is essential to link your Sprinklr users with their corresponding CRM User IDs. This ensures that data flows seamlessly between systems, enabling efficient user management.

Create a Single User Mapping

When you need to map individual users, you can create a single user mapping. This allows you to manually link a specific Sprinklr user to their respective CRM user ID.

Follow the steps below to create a single user mapping:

Step 1: Access the Sprinklr Marketplace

  • Navigate to the Sprinklr ‘Marketplace’ tab within your Sprinklr launchpad.

  • Click on ‘Installed Apps’ to view all the installed connectors.

Step 2: Locate the CRM Connector App

  • Scroll through the list of installed apps to find the CRM connector app.

  • Hover over the CRM connector to reveal additional options.

Step 3: Initiate User Mapping

Click on the ‘User Mapping’ button. This action will display a list of Sprinklr users that are currently mapped to CRM users.

Step 4: Add New User Mapping

  • To add a new user mapping, click the ‘User Mapping’ button.

  • In the dropdown, select the Sprinklr User for the user you want to map. This dropdown will show a list of available Sprinklr users.

  • Enter the corresponding CRM User ID to complete the mapping.

Step 5: Save the User Mapping

Once you have entered the necessary details, click ‘Save’.

You have successfully created a user mapping.

Bulk Import of User Mapping

For onboarding or managing multiple users at once, performing a bulk import of user mappings is the most efficient method. This process allows you to upload a file with multiple user mappings in one go.

Follow the steps below to do a bulk import of user mappings:

Step 1: Access Bulk Import

Within the User Mapping section, click the Import button located in the toolbar. This action will open the Import User Mappings window.

Step 2: Download the Template

In the Import User Mapping window, click on Download Sample Template to get a CSV file template. This template will guide you on the format required for bulk imports.

Step 3: Prepare the CSV File

Open the downloaded template and populate it with the necessary information:

  • Sprinklr User ID/Email: Enter the ID or email associated with the Sprinklr account.

  • CRM User ID: Enter the corresponding CRM User ID.

Step 4: Upload the CSV File

  • Once your CSV file is prepared, go back to the Import User Mapping window.

  • Upload your file by either dragging it into the window or using the Browse option.

Step 5: Submit the Bulk Import

After the file is uploaded, click Submit.

You have successfully completed a bulk import

Update User Mapping

User mappings may need to be updated over time as users or roles change. Updating a user mapping ensures that your systems remain synchronized with the latest information.

Update a Single User Mapping

When only one user’s mapping needs modification, you can update a single user mapping. This option lets you edit the details for a specific user directly within the interface.

Follow these steps to update user mapping:

Step 1: Select the User Mapping to Update

  • In the User Mapping window, browse through the list to find the user mapping you wish to update.

  • Select the specific user mapping that requires modification.

Step 2: Edit the User Mapping

  • Click the Edit button associated with the selected user mapping.

  • Modify the existing information as needed, such as updating the Sprinklr User ID or CRM User ID.

Step 3: Save the Updated Mapping

After making the necessary changes, click the Update button.

You have successfully updated the selected user mapping.

Bulk Update on User Mappings

If you have multiple user mappings that require changes, performing a bulk update allows you to modify and re-import the mappings efficiently, ensuring all updates are applied simultaneously.

Follow the steps below to do a bulk update on the existing user mapping:

Step 1: Export Existing User Mapping

  • In the User Mapping window, click the Export button to export the existing mappings.

  • You will receive an in-platform notification once your export file is ready for download.

Step 2: Download and Edit the Exported File

  • Download the exported file from the notifications area within the platform.

  • Open the file using a spreadsheet editor (e.g., Excel).

  • Update the necessary columns, such as the Sprinklr User ID/Email or CRM User ID and save the file.

Step 3: Import the Updated File

  • Return to the User Mapping window in Sprinklr.

  • Click the Import button and upload the edited file by following the steps mentioned in the Bulk Import User Mapping section.

  • After the file is successfully uploaded, the user mappings will be updated according to the new data in the file.

Delete User Mapping

Occasionally, user mappings need to be removed, either because a user is no longer active, or the mapping is no longer necessary. Deleting user mappings helps maintain a clean and accurate system.

Delete a Single User Mapping

To remove an individual user’s mapping, you can delete a single user mapping. This option is useful when only one mapping needs to be discarded. Follow the steps below to remove individual user mapping.

Step 1: Open the User Mapping Window

Navigate to the User Mapping window within your Salesforce connector app.

Step 2: Select the User Mapping

Find the specific user mapping you want to delete. Click on the user mapping to highlight it.

Step 3: Click ‘Delete’ and Confirm

  • Once selected, click the ‘Delete’ button located at the top of the window.

  • A confirmation dialog will appear. Click ‘Submit’ to finalize and delete the selected user mapping.

You have successfully deleted the selected user mapping.

Bulk Delete User Mapping

When it is necessary to remove multiple user mappings at once, bulk delete allows you to quickly and efficiently clear out large numbers of mappings, helping to keep your system organized.

Bulk delete user mapping.

Follow these steps to delete all existing user mappings within the connector app:

Step 1: Select All Mappings

In the User Mapping window, click the checkbox located in the top-left corner of the list. This will select all user mappings in the list.

Step 2: Click ‘Delete’ and Confirm

  • With all mappings selected, click the ‘Delete’ button at the top of the window.

  • A confirmation dialog will appear. Confirm the action by clicking ‘Submit’.

This action will delete all user mappings currently present in the Salesforce connector app.

Additional Functionalities

The User Mapping interface provides several additional functionalities to enhance your experience, including Search, Export, Filter, and Refresh. Below is a breakdown of each function:

Additional functionalities in user mapping dashboard.

Search

Quickly locate specific user mappings within the interface using the search bar.

Export User Mapping

  • Click the "Export" button to export existing user mappings.

  • You will receive an in-platform notification when your export file is ready for download.

  • Download the exported file from the notifications area within the platform.

Refresh

Use the Refresh button to update the interface and ensure you are viewing the most current data.

Customize Columns

Customize the displayed columns by selecting or deselecting the following options:

  • Sprinklr User

  • Sprinklr User Email

  • CRM User ID

  • Last Modified On

  • Last Modified By

  • Created On

  • Created By

Column filter in user mapping.

User Mapping is a crucial component in the integration between Sprinklr and CRM system, ensuring that user permissions and data consistency are maintained across both platforms. By mapping CRM users to their corresponding Sprinklr identities, you enable seamless access to the Sprinklr Care Console iFrame within CRM system, providing a unified experience for users.