FM
FlowMarket
Ecommerce & Sales Intermediate ⚡ 12 n8n Nodes

Create Salesforce accounts based on Excel 365 data

This workflow shows a no code approach to creating Salesforce accounts and contacts based on data coming from Excel 365 (the online version of Microsoft Exce...

🔌 Nodes & Integrations Used (4)

Salesforce Item Lists Rename Keys Microsoft Excel

📖 Implementation & Setup Guide

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

To run the workflow:

  1. Make sure you have both Excel 365 and Salesforce authenticated with n8n.
  2. Have a Microsoft Excel workbook with contacts and their account names ready:
  3. Select the workbook and sheet in the Microsoft Excel node of the workflow, then configure the range to read data from:
  4. 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.

⚡ How to import this workflow into n8n:

  1. Click the Direct Download JSON button above to save Create Salesforce accounts based on Excel 365 data.json.
  2. Log in to your n8n Cloud or self-hosted n8n instance.
  3. In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
  4. Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
  5. Click Execute Workflow to test and switch to Active!

Related Ecommerce & Sales Workflows

View All in Ecommerce & Sales →