Developer & DevOps

Extract and transform Salesforce data to spreadsheets

14 nodes 191 99 Automatic trigger
Download

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. 1.Trigger the workflow manually or on Salesforce record updates
  2. 2.Query Salesforce objects and retrieve relevant records with filters
  3. 3.Rename data fields to align with downstream system requirements
  4. 4.Merge multiple record sets and apply conditional logic for data validation
  5. 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

Salesforce Rename Keys Spreadsheet File

Details

Trigger Automatic trigger
Nodes 14
Apps 3
Views 191
Downloads 99

How to Use

  1. 1.Click "Download Template"
  2. 2.Open your n8n dashboard
  3. 3.Go to Workflows > Import from File
  4. 4.Select downloaded file and configure credentials

Nodes Used (14)

/

On clicking 'execute'

Manual Trigger

#1

Search Salesforce accounts

Salesforce

#2

Keep new companies

Merge

#3

Merge existing account data

Merge

#4

Account found?

If

#5

Remove duplicate companies

Item Lists

#6

Set Account ID for existing accounts

Rename Keys

#7

Retrieve new company contacts

Merge

#8

Set new account name

Set

#9

Create Salesforce account

Salesforce

#10

Create Salesforce contact

Salesforce

#11

Note

Sticky Note

#12

Download file

HTTP Request

#13

Spreadsheet File

Spreadsheet File

#14