Data Processing & Analysis

0258 Microsoftexcel Manual Create Triggered

Manual

High

Nodes

Manual

Trigger

High

Complexity

7/22/2025

Added

Workflow Overview

Total Nodes

Node Types

manual Trigger

On clicking 'execute'

1 node

salesforce

Search Salesforce accounts, Create Salesforce account, Create Salesforce contact

3 nodes

merge

Keep new companies, Merge existing account data, Retrieve new company contacts

3 nodes

Account found?

1 node

item Lists

Remove duplicate companies

1 node

rename Keys

Set Account ID for existing accounts

1 node

set

Set new account name

1 node

microsoft Excel

Microsoft Excel

1 node

Workflow JSON

8.48 KB

{
  "name": "0258 Microsoftexcel Manual Create Triggered",
  "nodes": [
    {
      "id": "e67d505c-20a3-4318-ba6b-d73db55e88e4",
      "name": "On clicking 'execute'",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        240,
        240
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "172d7c44-c488-4523-a0ad-1c903374c3e8",
      "name": "Search Salesforce accounts",
      "type": "n8n-nodes-base.salesforce",
      "position": [
        680,
        240
      ],
      "parameters": {
        "query": "=SELECT id, Name FROM Account WHERE Name = '{{$json[\"Company Name\"].replace(/'/g, '\\\\\\'')}}'",
        "resource": "search"
      },
      "credentials": {
        "salesforceOAuth2Api": {
          "id": "40",
          "name": "Salesforce account"
        }
      },
      "typeVersion": 1,
      "alwaysOutputData": false
    },
    {
      "id": "ae559728-f82e-44d6-8cfe-512151ee6867",
      "name": "Keep new companies",
      "...

Showing first 1000 characters. Click "Expand" to view the full JSON.