Extract and transform Salesforce data to spreadsheets
Workflow Description
Automation that retrieves records from Salesforce, renames fields to match operational requirements, merges data from multiple sources with conditional logic, and exports the processed results to a shareable spreadsheet file for analysis and reporting.
How it works
- 1.Trigger the workflow manually or on Salesforce record updates
- 2.Query Salesforce objects and retrieve relevant records with filters
- 3.Rename data fields to align with downstream system requirements
- 4.Merge multiple record sets and apply conditional logic for data validation
- 5.Export processed data to a spreadsheet file
Use cases
- Export customer lists and sales opportunities from Salesforce for monthly reporting
- Sync updated sales data to internal analytics platforms on a scheduled basis
- Create automated backups of Salesforce records in standardized spreadsheet format
Requirements
- Active Salesforce account with data access permissions
- Knowledge of field and object names used in your Salesforce instance
- Access to storage systems for creating and managing spreadsheet exports
Service Value
Ready-made workflow template for automation delivery and service execution.
Apps Used
Details
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (14)
On clicking 'execute'
Manual Trigger
Search Salesforce accounts
Salesforce
Keep new companies
Merge
Merge existing account data
Merge
Account found?
If
Remove duplicate companies
Item Lists
Set Account ID for existing accounts
Rename Keys
Retrieve new company contacts
Merge
Set new account name
Set
Create Salesforce account
Salesforce
Create Salesforce contact
Salesforce
Note
Sticky Note
Download file
HTTP Request
Spreadsheet File
Spreadsheet File