Sync companies from Google Sheets to Salesforce with smart duplicate prevention
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 - Salesforce
n8n-nodes-base.salesforce - If
n8n-nodes-base.if - Item Lists
n8n-nodes-base.itemLists - Rename Keys
n8n-nodes-base.renameKeys - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Merge
n8n-nodes-base.merge
What it does
How it works Automatically imports company data from Google Sheets into Salesforce while intelligently preventing duplicate accounts. The workflow searches for existing companies, creates new accounts only when needed, and ensures all contact information is properly associated. Key features: - Smart duplicate detection by company name matching - Dual processing paths for new vs existing companies - Automatic contact creation and association - Comprehensive error handling and data validation - Professional sectional documentation with setup guides Set up steps - Configure Google Sheets API credentials (OAuth 2.0) - Set up Salesforce Connected App with Account/Contact permissions - Prepare Google Sheets with proper column headers (Company Name, Email, Phone, Industry) - Map Salesforce field requirements in workflow nodes - Test with small dataset before full deployment Estimated setup time: 15-30 minutes Processing time: 15-45 seconds per company All detailed configuration steps, troubleshooting guides, and security best practices are included in the comprehensive sticky note documentation within the workflow.