Skip to main content

Connect Salesforce to Feedier

Enrich you feedbacks from Salesforce data / Send data from feedbacks to Salesforce

Julien Chil avatar
Written by Julien Chil
Updated over a week ago

Menu β†’ Workflows + Salesforce


Who can access ?

Roles

Access

πŸ‘‘ Admins

Full access

πŸ› οΈ Editors

Full access

πŸ‘€ Viewers

No access

πŸ”’ Restricted Viewers

No access

What are the prerequisites ?

1. In Salesforce β†’ Install the Feedier package

  • A Salesforce Administrator must install the Feedier package using this link: Install Feedier App.

  • Access to grant : All Users or Specific users.

  • Environments to grant : both UAT and Production environments.

πŸ’‘ In case the following error appears :

It means that the user trying to install the package is not an Administrator on Salesforce.

2. In Feedier β†’ Create a Salesforce connection in Feedier

The deployment of the automatic package establishes the creation of:

  • Custom Object: FeedierFeedback__c - to store feedback

  • Custom Object: FeedierItem__c - to store feedback attributes/answers

  • Permission Set: Feedier_Integration - for API access permissions

It also check if the user Feedier_Integration has all the permissions set to execute the CRUD on the two objects : FeedierFeedback__c/FeedierItem__c

Options

Meaning

Deploy Salesforce Automatic Package

Feedier will automatically create the custom object for you, which will be used for sending back data to salesforce.

You only need to check this section :

Manual Salesforce Package

In case you want to create the custom object by yourself to send back data to sales force.

How to Enrich Feedbacks with Salesforce data ?

Before triggering the integration

After triggering the integration​


​

1. Create a Autopilot automation

Feedier β†’ Autopilot β†’ Automation


Chose the Segment of Feedbacks you want to enrich from Salesforce Object

Connect the Segment to a Salesforce Sync Object Connection

πŸ’‘ The attribute is the key used to find the record in Salesforce this could be an Account ID, Custom ID, or Contact ID. Make sure to select the attribute in Feedier that corresponds to find the feedback in Salesforce.

β†’ It's value will be available to use in the SOQL query.

2. Chose the data you want to retrieve with the SOQL Query

Salesforce β†’ Salesforce Developer Console β†’ Query Editor


SOQL (Salesforce Object Query Language) will help us to select the data from Salesforce we want in Feedier. You can also refer to Salesforce documentation for the structure: Salesforce Object Query Language (SOQL) | SOQL and SOSL Reference | Salesforce Developers

Example

SOQL query

Salesforce Developer Console

Retrieving Contact Data

SELECT Id, FirstName, LastName, Email, Phone, AccountId FROM Contact WHERE Id = 'contact_id' 

Retrieving Account Data

SELECT Id, Name, Industry, BillingCity, BillingState, BillingCountry FROM Account WHERE Id = 'Account_id'

Retrieving Contact and Account Data Based on Contact ID

SELECT Id, FirstName, LastName, Email, Phone, Account.Name, Account.Website FROM Contact WHERE Id = 'contact_id'

πŸ’‘ Select in the SOQL Query the Feedier Attribute you are using as a key. For example {salesforce_id} :

How to test the integration ?

  1. Import Feedbacks with a Salesforce ID attribute in Feedier.

  2. Make sure they match the chosen segment in the Autopilot automations.

  3. 🎊 You should see (after around 5min) Salesforce data on the feedback.

πŸ’‘ Pro tip here :

  • You can also create a Feedier Survey

  • Make sure the Feedier Survey answers matches you Segment chosen in Autopilot.

  • Answer by yourself to this survey adding a Salesforce ID attribute in the link (will be added to the feedback). Example : https://feedback.feedier.pre-prod.alkalab.com/DXoT9Z?salesforce_id=001J7000007VpctIAC.

  • 🎊 You should see (after around 5min) Salesforce data on the feedback.

How to send data to Salesforce from Feedier Feedbacks ?

1. Create a Custom Object

If you chose to do not select deploy automatic package

Salesforce Setup App β†’ Object Manager β†’ Create β†’ Custom Object


Setup a custom object called FeedierFeedback

Add the label as FeedierFeedback, Object Name should populate automatically.

πŸ’‘ The object name must be FeedierFeedback (the API will call FeedierFeedback__c).

2. Add the Field and Relationships to FeedierFeedback object

If you have chosen to do not select deploy automatic package

Now go to Fields and Relationships for the FeedierFeedback object, and start adding the following custom fields. You must add all of the following:

Salesforce Label

Data Type

Explanation

Created By

Lookup(User)

Mandatory field on Salesforce, will display the user that setup the connector

FeedierFeedbackId

Text(80)

Feedback ID in Feedier

FeedierCreatedAt

Date

The date Feedback was created

FeedierFeedbackName

Text(80)

The Name of the object

FeedierSurveyName

Text (100)

Survey name in Feedier

FeedierFeedbackLink

Text (255)

The link to the feedback responses on Feedier

FeedierNPSScore

Number(18, 0)

The answer value to NPS question

FeedierSatisfactionRatio

Number(18, 0)

Satisfaction Ratio of the feedback

FeedierPushCreatedAt

Date

The push schedule creation time (if any)

FeedierPushStatus__c

Text (255)

The push status

LastModifiedById

Lookup(User)

Mandatory field on Salesforce

OwnerId

Lookup(User,Group)

Mandatory field on Salesforce

Add a lookup relationship value

FeedierFeedback β†’ Field & Relationships β†’ New β†’ Lookup relationship β†’ [select custom field to link]

You’ll need to add a Lookup Relationship in the table in order to link this new object FeedierFeedback to an existing salesforce custom field eg. contact_id or case_id.
This is needed so the connector knows what record to update.

Any field that is wrong or missing will result in a crash of the process and the feedback will be not sent to Salesforce.

You will also need to add FeedierItem object which corresponds to the Feedier Feedback Item

Similar to step 1, create a new Salesforce object FeedierItem__c and add the following fields:

Salesforce Label

Data Type

Explanation

FeedierItemFullName

Text (255)

The question name

FeedierItemFeedbackObjectId

Lookup(FeedierFeedback)

The related FeedierFeedback that was created in the integration.

FeedierItemFeedbackId


​

Text(80)

Feedback ID in Feedier

FeedierItemSurveyName


​

Text (255)

Survey name in Feedier

FeedierItemType

Text (255)

The type of response, for most use cases this will show as β€˜question’

FeedierItemValue

Long Text Area(131072)

The answer value

FeedierItemCreatedAt

Date/Time

The answer creation time

Any field that is wrong or missing will result in a crash of the process and the feedback will be not sent to Salesforce.


3. Add a lookup relationship value

If you chose not to deploy the package automatically, you’ll need to add a Lookup Relationship in the table in order to link this new object FeedierFeedback to an existing salesforce custom field eg. contact_id or case_id.
This is needed so the connector knows what record to update.

FeedierFeedback β†’ Field & Relationships β†’ New β†’ Lookup relationship β†’ [select custom field to link]


Salesforce Label

Data Type

Explanation

eg. Case

eg. Lookup(Case) / Lookup(Contact)

Relationship lookup:
​The attribute from Feedier that connects to Salesforce


To test :

1) Go to feedier

2) Create a segment

3) Create an autopilot workflow

4) Link segment to salesforce integration

5) Choose your Salesforce Relationship Object Field on which your feedback will be attached ( e.g contact or account )

6) Choose the Attribute on which your contact will match the feedback

7) Save then Publish

Finally Reply to a survey sent to you by email and you should see your feedback on salesforce

Here is a video to better understand the steps :

Did this answer your question?