Create Salesforce accounts based on Google Sheets data
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: Item Lists (legacy). 1 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 12 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets and Salesforce.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Read Google Sheet (Google Sheets): uses Google Sheets
- Search Salesforce accounts (Salesforce): work with search
- Keep new companies (Merge): merges the data from its input branches
- Merge: merges the data from its input branches
- Remove duplicate companies (Item Lists): reshapes item lists (legacy Item Lists node)
- Retrieve new company contacts (Merge): merges the data from its input branches
- Account found? (If): checks a condition and branches into true / false
- Create Salesforce account (Salesforce): work with account
- Create Salesforce contact (Salesforce): create or update (contact)
- Set Account ID for existing accounts (Rename Keys): uses Rename Keys
…plus 1 more step. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- Item Lists (legacy) in Remove duplicate companies: replace with Split Out, Aggregate, Sort, Limit, Remove Duplicates or Summarize (match the operation used).
| Removed in 3.0 | Replace with |
|---|---|
| Item Lists (legacy) Remove duplicate companies | Split Out, Aggregate, Sort, Limit, Remove Duplicates or Summarize (match the operation used) |
Nodes used (8)
- Manual Trigger
n8n-nodes-base.manualTrigger - Google Sheets
n8n-nodes-base.googleSheets - Salesforce
n8n-nodes-base.salesforce - Merge
n8n-nodes-base.merge - If
n8n-nodes-base.if - Item Lists
n8n-nodes-base.itemLists - Rename Keys
n8n-nodes-base.renameKeys - Edit Fields (Set)
n8n-nodes-base.set
From the author
This workflow shows a no code approach to creating Salesforce accounts and contacts based on data coming from Google Sheets. To run the workflow: 1. Make sure you have both Google Sheets and Salesforce authenticated with n8n. 2. Have a Google Sheet with…