AcademyWorkflowsSales

Create Salesforce Accounts and Contacts from Google Sheets

Sales operations teams that keep contact lists in spreadsheets and need them loaded into Salesforce without duplicate accounts.

  • Recommendedour rating
  • 3,351views on n8n
Open on n8n.io ↗

Paste it straight onto an n8n canvas with Ctrl+V or Cmd+V.

create-salesforce-accounts-based-on-google-sheets-data.json

Loading the file...

What it does

Reads contacts and their account names from a Google Sheet and searches Salesforce for each account. If the account does not exist it is created, then the data is normalized and the contacts are created or updated in Salesforce. It is a no-code way to load spreadsheet data into the CRM.

Use cases

  1. 01Import a trade show contact list into Salesforce
  2. 02Create missing accounts from a partner spreadsheet
  3. 03Update existing contacts from a cleaned sheet

Connects

Google Sheets · Salesforce

Questions about
Create Salesforce Accounts and Contacts from Google Sheets.

What is Create Salesforce Accounts and Contacts from Google Sheets used for?

Sales operations teams that keep contact lists in spreadsheets and need them loaded into Salesforce without duplicate accounts. Reads contacts and their account names from a Google Sheet and searches Salesforce for each account. If the account does not exist it is created, then the data is normalized and the contacts are created or updated in Salesforce. It is a no-code way to load spreadsheet data into the CRM.

How do I import Create Salesforce Accounts and Contacts from Google Sheets into n8n?

Copy the workflow JSON from this page and paste it onto the n8n canvas with Ctrl+V or Cmd+V. Then connect your credentials in each node.

Is Create Salesforce Accounts and Contacts from Google Sheets safe to use?

It passed our automatic scan for credential theft, hidden instructions and risky install commands. Third party open source software. Sabemos AI does not maintain it. Check the code and permissions before you connect it to company data.