Library / CRM & Sales Pipeline
CRM & Sales Pipeline
Find New Companies in Excel Missing from Salesforce
When you run it manually, it searches Salesforce accounts, keeps companies that are new and merges them with existing account data from Excel.
What it does
# Manualtrigger Workflow ## Overview Automated workflow: Manualtrigger Workflow. This workflow processes data and performs automated tasks. ## Workflow Details - Total Nodes: 13 - Node Types: 9 - Error Handling: ✅ Implemented - Security: ✅ Hardened (no sensitive data) - Documentation: ✅ Complete ## Node Breakdown - On clicking 'execute': manualTrigger - Search Salesforce accounts: salesforce - Keep new companies: merge - Merge existing account data: merge - Account found?: if - Remove duplicate companies: itemLists - Set Account ID for existing accounts: renameKeys - Retrieve new company contacts: merge - Set new account name: set - Create Salesforce account: salesforce - ... and 3 more nodes ## Usage Instructions 1. Configure Credentials: Set up all required API keys and credentials 2. Update Variables: Replace any placeholder values with actual data 3. Test Workflow: Run in test mode to verify functionality 4. Deploy: Activate the workflow for production use ## Security Notes - All sensitive data has been removed or replaced with placeholders - Error handling is implemented for reliability - Follow security best practices when configuring credentials ## Troubleshooting - Check error logs if workflow fails - Verify all credentials are properly configured - Ensure all required services are accessible
The steps
- On clicking 'execute'
- Search Salesforce accounts
- Keep new companies
- Merge existing account data
- Account found?
- Remove duplicate companies
- Set Account ID for existing accounts
- Retrieve new company contacts
- Set new account name
- Create Salesforce account
- Create Salesforce contact
- Microsoft Excel
- Error Handler
Similar automations
CRM & Sales PipelineCreate Salesforce Accounts from Excel 365 Data12 stepsCRM & Sales PipelineAdd New Companies from Google Sheets to Salesforce Accounts14 stepsCRM & Sales PipelineFind New Companies Not Yet in Salesforce Accounts24 stepsCRM & Sales PipelineCreate Salesforce Accounts from Excel File Data13 steps