Sync NetSuite Customers to Salesforce Accounts & Contacts with Auto Upserts — n8n Workflow

High complexity⏰ Scheduled16 nodes🤝 Sales👁 25 viewsby Entech Solutions

Overview

Short Description

Automatically exports customer records from NetSuite and syncs them into Salesforce — creating or updating Accounts and Contacts depending on whether the NetSuite record represents a company or an individual.

Who is this for / Use case

This template is designed for businesses and integration developers who:

Use NetSuite as their ERP or CRM system. Need to automatically sync customer data (both companies and individuals) into Salesforce. Want a reliable, scalable solution th

Nodes used

SalesforceCode

Workflow Preview

This n8n template demonstrates how to export
How it works
* Workflow processes 20 records per iteration until the
* To fi
Salesforce section
Records are inserted/updated into Salesforce here
Netsuite section
Records are pulled from NetSuite here
Fell free to use filter with Q parameter passed in 'NS:
For example - email START_WITH barbara
Read ab
Run for Delta records
Replace a 'NS: Customer - Get All records' node with a
I
Is Company?
N
NS: Customer - Get record
SF: Create or Update Com…
SF: Create or Update Con…
SF: Create or Update Per…
S
Split Customers Array
M
Merge Company/Contact Re…
W
Workflow is finished
H
Has More Records?
Retrieve Paging Offset a…
Update Paging Offset and…
⚡
E
Execute Workflow Daily
Init Offset
N
NS: Customer - Get Delta…
N
NS: Customer - Get All r…
Update LastExportDate
16 nodes16 edges

How it Works

  1. 1

    Trigger

    The workflow starts with a scheduled trigger, running on a defined schedule.

  2. 2

    Process

    Data flows through 16 nodes, connecting code, if, merge.

  3. 3

    Output

    The workflow completes its automation and delivers the result to the configured destination.

Node Details (16)

SA

Salesforce

salesforce

#1
CO

Code

code

#2

How to Import This Workflow

  1. 1Click Download JSON button on the right to save the workflow file.
  2. 2Open your n8n instance. Go to Workflows → New → Import from file.
  3. 3Select the downloaded sync-netsuite-customers-to-salesforce-accounts-contacts-with-auto-upserts file and click Import.
  4. 4Set up credentials for each service node (API keys, OAuth, etc.).
  5. 5Click Test Workflow to verify everything works, then activate it.

Or paste directly in n8n → Import from JSON:

{ "name": "Sync NetSuite Customers to Salesforce Accounts & Contacts with Auto Upserts", "nodes": [...], ...}

Integrations

codeifmergen8n-nodes-netsuite-rest.netsuiterestsalesforcescheduletriggersplitout

Get This Workflow

Download and import in one click

Download JSONView on n8n.io
Nodes16
Complexityhigh
Triggerscheduled
Views25
CategorySales

Created by

Entech Solutions

Entech Solutions

@entech

Tags

codeifmergen8n-nodes-netsuite-rest.netsuiterestsalesforcescheduletriggersplitout
⚡

New to n8n?

n8n is a free, open-source workflow automation tool. Self-host it or use the cloud version.

Get n8n Free →