workflows.fit
Back to n8n workflows
n8n templateFreeBy Tom

Create Salesforce accounts based on Excel file data

This workflow shows a no code approach to creating Salesforce accounts and contacts based on data coming from an Excel file. For Excel 365 (the online version of Microsoft Excel) check out [this workflow](https://n8n....

DevelopmentCore NodesSalesCommunicationData & StorageManual TriggerSalesforceMerge
Loading interactive preview...

Template notes

This workflow shows a no code approach to creating Salesforce accounts and contacts based on data coming from an Excel file. For Excel 365 (the online version of Microsoft Excel) check out [this workflow](https://n8n.io/workflows/1793-create-salesforce-accounts-based-on-excel-365-data/) instead.

![image.png](fileId:674)

To run the workflow:

1. Make sure your Salesforce account is authenticated with n8n. 2. Have a Microsoft Excel workbook with contacts and their account names ready. The workflow uses [this example file](https://static.thomasmartens.eu/n8n/Excel-File-to-Salesforce.xlsx), but you probably want to use your own data instead. ![image.png](fileId:673) 3. Hit the Execute Workflow button at the bottom of the n8n canvas.

Here is how it works:

The workflow first searches for existing Salesforce accounts by name. It then branches out depending on whether the account already exists in Salesforce or not. If an account does not exist yet, it will be created. The data is then normalised before both branches converge again. Finally the contacts are created or updated as needed in Salesforce.