Creating New Records in Salesforce

To create new records in Salesforce you will only need a spreadsheet with your data.

In this example we’ll load Contacts as this is probably the most common scenario in any CRM. Below the spreadsheet that we need to load.

To load the above contacts to the following:

Log in to Salesforce by clicking the Log in button.

Select values in Excel so that your selection spans across all rows, e.g.:

Go to the Push Data tab in the XL-Connector 365 sidebar and click on Create/Modify -> Insert Selected:

In the subsequent screen, select the Salesforce object (table) you are creating records in:

Click on Mappings Manager and make sure your columns are mapped correctly to the respective fields in Salesforce and click on Apply:

You can also define constant mappings in the Mapping page of each flow step.

Any manual push operation will be saved the mappings and other settings in a reusable “Flow Step” that can be later run separately or as a part of a larger Flow. The following setting determines the behavior of the flow step if the operation returns at least one error:

There are also several options that you can adjust for each Insert operation and the associated flow step:

Click on Run and Save to run the Insert operation according to the provided settings and save all the settings as a reusable Flow Step. In this case you’ll be able to run the same Insert operation again from the same area in your sheet with a single click on the Run Flow or Run Flow Step button.
Click Run to only run the Insert operation of the selected data and not save the mappings and other settings as a reusable Flow Step.
Click Save to save all the provided settings as a reusable Flow Step. In this case you’ll be able to run the same Insert operation again from the same area in your sheet with a single click on the Run Flow or Run Flow Step button.

After the operation is completed, all operation results, along with the newly created record Ids will be written on the right from your data, one column over: