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 to replace before upgrading
| 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
What it does
This workflow shows a no code approach to creating Salesforce accounts and contacts based on data coming from Google Sheets. !image.png(fileId:667) To run the workflow: 1. Make sure you have both Google Sheets and Salesforce authenticated with n8n. 2. Have a Google Sheet with contacts and their account names ready, copy the respective sheet ID from the URL: !image.png(fileId:666) 3. Add the sheet ID to the Google Sheet node of the workflow: !image.png(fileId:668) 4. Hit Execute Workflow 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.